Understand the error
The Import Importer Tool requires .csv files to conform to the UTF-8 standards in order for them to be parsed accurately by the system. The most common reason for this error is if a non-UTF-8 character such as “Å” is present in the .csv file. To successfully upload your .csv file, you will need to open your .csv file and change the file type. This process will look different depending on the program you are using, so the steps below cover both Excel and Numbers.Format in Windows
- Open your .csv in Excel.
Note: If you use a different spreadsheet program, check their support documentation for instructions on how to download as a CSV UTF-8.
- Select File and click Save As.
- From the file type dropdown, select CSV UTF-8 (Comma delimited (*.csv).
- Click Save.
Format in macOS
- Open your .csv in Numbers.
- Select File.
- Hover over Export To and select .csv.
- In the export options, select Advanced Options, and specify Unicode (UTF-8). If there is another .csv export option shown, click into the dropdown and choose Unicode (UTF-8).
- Confirm by selecting Export on the following screen.