Skip to content

Save accented characters in csv

Saving Accented Characters

Importing modified csv files into other systems

If customers need to import modified Excel files containing accented characters (French, German, etc) into their system and they're using Microsoft Excel to create their CSV file, they may run into an issue. When you're using accented characters (such as é, ç, ü, etc.) - Microsoft Excel does not generate a UTF-8 compliantCSV file. To resolve this issue, please do the following:

  • Save the Excel file as a CSV file.
  • Open the CSV file generated by Excel using another software which can create UTF-8 compliant CSV files.

Windows

  • Open the file using Notepad.
  • Click "File > Save As".
  • In the dialog window that appears - select "UTF-8" from the "Encoding" field. Then click "Save".

Mac

  • Use either the "Numbers" application, or the free LibreOffice, instead of Excel.
  • Click "File > Save As".
  • In the dialog window that appears - select "UTF-8" from the "Encoding" field. Then click "Save".

Your saved file will be ready to import into your UTF-8 compliant database system.