Exporting your spreadsheet to a UTF-8 encoded CSV

Using Excel on a Windows device

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

Using Notepad on a Windows device

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 Files

   File name: name your file and add the .csv extension to it - e.g.: myupdates.csv

   Encoding: Click on the dropdown and choose UTF-8

4. Hit Save

On 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. Hit 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. Your file will be downloaded to your computer