Data
      Back to home
      1. Knowledge Base
      2. FAQs
      3. Data

      How do I export my spreadsheet to a UTF-8 encoded CSV?

      How do I export my spreadsheet to a UTF-8 encoded CSV?

      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:

        1. Save as type: change this to All Files

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

        3. Encoding: 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