Skip to main content
All CollectionsImport/Export
How to encode a .csv file in UTF-8
How to encode a .csv file in UTF-8
Paul Sullivan avatar
Written by Paul Sullivan
Updated over 4 months ago

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:

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

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

Did this answer your question?