Feedback

  • Contents
 

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

  1. Open the Excel file (.xls, .xlsx).

  2. From the File menu, choose Save As.

  3. From the Save as type list, select CSV (Comma Delimited) (*.csv).

  4. Click the Windows Start menu, click All Programs, click Accessories, and then click Notepad.

  5. From the File menu, click Open.

  6. In the list next to the File name box, select All Files.

  7. Browse to your .CSV file, select it, and then click Open.

  8. From the File menu, click Save As.

  9. 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.

  10. In the File name box, type a name that is similar to the original file name.

  11. Click Save.