All Collections
Frequently Asked Questions
How do I export my spreadsheet to a UTF-8 encoded CSV?
How do I export my spreadsheet to a UTF-8 encoded CSV?
Vincent avatar
Written by Vincent
Updated over a week ago

Windows

If you use Excel

We do not recommend using Excel for exporting to .csv as it tends to create unreadable characters in .csv files.

If you use Notepad

  1. Click on File

  2. Choose Save As

  3. There are three items to update in the Save dialog that comes up: Save as type: change this to All FilesFile name: name your file and add the .csv extension to it - e.g.: myupdates.csvEncoding: Click on the dropdown and choose UTF-8

  4. Save!

Mac

If you use Excel for Mac, we highly recommend that you open your spreadsheet in either Numbers or Google Sheets to convert and export the final CSV file to UTF-8 encoding. Excel for Mac does not natively support the import or export of UTF-8 encoded files.

If you use Numbers

  1. Click on File

  2. Hover over Export 

  3. In the submenu that appears, choose CSV

  4. Click on Advanced Options to show the Text Encoding dropdown

  5. Select Unicode (UTF-8) from the dropdown menu

  6. Click Next

  7. Save!

Google Sheets

  1. Click File

  2. Click on or hover over Download As

  3. Choose the option Comma-separated values (.csv, current sheet)

  4. After clicking on that option, your file will be automatically downloaded to your computer

Related articles:

Did this answer your question?