When uploading contact lists to Remarkety with information that's not always in English, you may run into trouble with the file encoding, which means that names, addresses etc will show up as gibberish.

Remarkety supports uploads of contacts lists encoded with UTF8. However, the CSV file you have may be generated from a system which encoded the file differently. Here's how to convert the file to UTF-8 with Microsoft Excel 2016 (other versions should be similar):

1. Open up a new Excel document with a blank workbook.

2. In the Data ribbon, select: "From CSV/Text".

3. Find the CSV file you want to import, and choose it.

4. In the "File Origin" dropdown, select the file's current encoding. Excel will preview the data so make sure that it shows up properly.


5. Click "Load"

6. Now, you should have a workbook with the data properly visible. To export the data into a UTF-8 encoded CSV, simply choose File -> Save As and select CSV UTF-8 as the file type. 

Click Save and voila! You've just converted a non-UTF8 to a UTF8 encoded file which you can upload to Remarkety.

Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.