Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Export to CSV, strange Excel File

Gilles Plante
in FMPerception / FMComparison

Featured Replies

Hi,

 

I am running version 17.0.2 and for a specific table, when I export to CSV what I get in the file is strange. This is what I get:

 

image.thumb.png.687cfe243a6ffdc6c00554ba0bf591fb.png

Row 1 to 11 are almost right (but for strange characters like the A with a tilde). But then from 13 it's getting wild. At some point further down it's getting back Ok for a while and then it turns wild again.

What is the explanation for that ? And strangely if I import into FileMaker it's Ok.

Thanks

 

Hey, Gilles,

Excel has its own particular rules when it comes to CSV, particularly related to Unicode and line feeds.  I did optimize that export for feeding back into FileMaker.

It's been on my agenda to do some further checking to see if I can determine why Excel is being funky... But that agenda is a long list.

Create an account or sign in to comment

https://fmforums.com/topic/103618-export-to-csv-strange-excel-file/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.