How to encode a .csv file in UTF-8

There are a number of different solutions you can use to change your file to UTF-8 encoding.

Using Google Sheets

1. Create a new Google Sheets document.

2. In the new Google Sheets document, import your CSV file by clicking on File > Import > and select your .csv file

3. Once you import your file, you can click on File > Download As > Comma-Separated Values to save the file to your computer.

Your new CSV file is now encoded using the UTF-8 format and is ready to be imported into Coconut

Using Microsoft Excel

1. Open your CSV file in Microsoft Excel, then click File > Save As

2. Enter any name for the file, then select "CSV UTF-8 (Comma delimited) (*.csv)" as your desired file format.

3. Click Save.

Your new CSV file is now encoded using the UTF-8 format and is ready to be imported into Coconut

Using Notepad (Windows)

1. Open your CSV file in Notepad.

2. Click File > Save as...

3. In the dialog which appears, select the following options:

4. • 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 (Example: Staff.csv).

   • Click Save.

5. Click Save.

Your new CSV file is now encoded using the UTF-8 format and is ready to be imported into Coconut

Using Numbers (MacOS)

1. Open your CSV file in Numbers.

2. Click File in the top-left corner of your screen.

3. Select Export to... -> CSV...

4. Click Advanced options.

5. Click the drop-down menu next to Text Encoding.

6. Select Unicode (UTF-8).

7. Click Next

8. Choose a name and location for your new file and click Save.

Your new CSV file is now encoded using the UTF-8 format and is ready to be imported into Coconut