Related Questions:
Why did special characters get skipped in my imported records?
How do I Fix Encoding Issues When Importing?
Why are there missing letters in my import?
How do I Import special characters?
What does incompatible character encodings: ASCII-8BIT and UTF-8 mean?
Answer:
To avoid problems with encoding and decoding text files, you can save files with Unicode encoding. Unicode accommodates most characters sets across all the languages that are commonly used. The suggested encoding is UTF-8.
The examples below demonstrate how to ensure characters display properly by selecting the UTF-8 encoding when exporting files from various spreadsheet tools.
If you have already run your import and used External ID's, you can re-run it and use the 'merge' function. This will override your previously imported data.
Apple Numbers
Select File > Export To > CSV
Set Text Encoding to Unicode (UTF-8)
Click next to export the data
Proceed with importing in Event Temple
Microsoft Excel
Select File > Save as
Select More options
Set the Save as type to CSV UTF-8 (Comma delimited)
Click next to export the data
Proceed with importing in Event Temple
Google Sheets
Google Sheets will automatically convert your file to UTF-8 when you open it. When you download your file, it will automatically be downloaded in UTF-8 format .