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
Click on File
Choose Save As
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
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
Click on File
Hover over Export
In the submenu that appears, choose CSV
Click on Advanced Options to show the Text Encoding dropdown
Select Unicode (UTF-8) from the dropdown menu
Click Next
Save!
Google Sheets
Click File
Click on or hover over Download As
Choose the option Comma-separated values (.csv, current sheet)
After clicking on that option, your file will be automatically downloaded to your computer