Best Practices for Data Import

Please ensure that your CSV file is UTF-8 Encoded.

There are several ways to do this:

  1. 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.

  2. 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.

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