Saving your data file using the UTF-8 Character Set

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.