Best Practices for Data Import
Please ensure that your CSV file is UTF-8 Encoded.
There are several ways to do this:
-
Using Microsoft Excel
Open your CSV file in Microsoft Excel.
Click File in the top-left corner of your screen.
Select Save as...
Click the drop-down menu next to File format.
Select CSV UTF-8 (Comma delimited) (.csv) from the drop-down menu.
Click Save. -
Using Notepad (Windows)
Open your CSV file in Notepad.
Click File in the top-left corner of your screen.
Click Save as...
In the dialog which appears, select the following options:
In the "Save as type" drop-down, select All Files.
In the "Encoding" drop-down, select UTF-8.
Rename your file using the .csv extension (Example: myproject.csv).
Click Save. -
Using Numbers (macOS)
Open your CSV file in Numbers.
Click File in the top-left corner of your screen.
Select Export to... -> CSV...
Click Advanced options.
Click the drop-down menu next to Text Encoding.
Select Unicode (UTF-8).
Click Next
Choose a name and location for your new file and click Save.
Updated over 2 years ago