Characters Not Displaying Correctly

Your CSV files are more likely to load smoothly if they are encoded with UTF-8. If you're having problems with some characters rendering incorrectly, you can convert the files to UTF-8 encoding before loading the data.

You might see unexpected characters in your data, especially characters whose ASCII values are at the high and low end of possible values. Some examples of characters that can appear incorrectly are: æ, ñ, ä, í, ö.

If this happens, your data will look like this:

Incorrectly displaying characters

Instead of displaying correctly like this:

Correctly displaying characters

To encode your data as UTF-8:

1. On Windows, open your CSV file in Notepad. Save the file as CSV with the Unicode option.
2. On Linux or MacOS, issue a command like:

   $ iconv -f UTF-8 in.csv > out.csv

3. Drop the table and then recreate it.
4. Attempt to import it again.