Saving your data file using the UTF-8 Character Set
  • 1 Minute to read
  • Dark
    Light

Saving your data file using the UTF-8 Character Set

  • Dark
    Light

Article summary

CSV files imported into infoodle need to be saved with UTF-8 character encoding. The following information provides the step on how this can be achieved on Windows when using Notepad, Excel, and Libre Office Calc, and on MmacOS with Numbers.

UTF-8 Encoding in Notepad (Windows)

  • Open your CSV file in Notepad.
  • Select File in the top-left corner of your screen.
  • Select Save as...

Select the following options:

  • In the Save as type drop-down, select All Files.
  • In the Encoding drop-down, select UTF-8.
  • Rename your file using the .csv extension (For example: infoodle_data.csv).
  • Save.

Your new CSV file is now encoded using the UTF-8 format and is ready for importing into infoodle.

UTF-8 Encoding in Microsoft Excel (Windows)

  • Open your CSV file in Microsoft Excel.
  • Select File in the top-left corner of Excel.
  • Select Save as...
  • Select the File format drop-down menu.
  • Select CSV UTF-8 (Comma delimited) (.csv) from the drop-down menu.
  • Save.

Your new CSV file is now encoded using the UTF-8 format and is ready for importing into infoodle.

UTF-8 Encoding in LireOfiice Calc (Windows)

  • Open your CSV file in Libre Office Calc.
  • Select File in the top-left corner of Excel.
  • Select Save as...
  • Select the File format drop-down menu.
  • Select Text CSV from the Save as type drop-down menu.
  • Select Edit filter settings
  • Save.
  • Confirm that you wish to Use Text CSV Format
  • In the Export Text File dialogue ensure that the Character set: is Unicode (UTF-8)
  • Set the other options as required and select OK

Your new CSV file is now encoded using the UTF-8 format and is ready for importing into infoodle.

UTF-8 Encoding in Numbers (macOS)

  • Open your CSV file in Numbers.
  • Select File in the top-left corner of Numbers.
  • Select Export to... -> CSV...
  • Select Advanced options.
  • Click the Text Encoding drop-down menu.
  • Select Unicode (UTF-8).
  • Select Next
  • Enter a name and select a location for your new file and then Save.

Your new CSV file is now encoded using the UTF-8 format and is ready for importing into infoodle.


Was this article helpful?