- Contents
Interaction Administrator Help
CSV files with non-English column headings
If you want to use a CSV file that uses non-English column headings or non-ANSI data, you must save the data as UTF-8 first. Otherwise, the data does displays incorrectly and you receive error messages.
To save a CSV file in UTF-8 format
-
Open the Excel file (.xls, .xlsx).
-
From the File menu, choose Save As.
-
From the Save as type list, select CSV (Comma Delimited) (*.csv).
-
Click the Windows Start menu, click All Programs, click Accessories, and then click Notepad.
-
From the File menu, click Open.
-
In the list next to the File name box, select All Files.
-
Browse to your .CSV file, select it, and then click Open.
-
From the File menu, click Save As.
-
In the Encoding list, select UTF-8.
Note: Do NOT use ANSI or you lose all accents and other language-specific characters. After selecting UTF-8, then save the file to a slightly different file name from the original.
-
In the File name box, type a name that is similar to the original file name.
-
Click Save.