How to encode your CSV files using the UTF-8 format.

Occasionally, when importing a CSV file that contains non-English or special characters, TradeGecko is unable to understand and process the file due to the way it’s encoded by your spreadsheet application.

In these instances, TradeGecko will present the error 'invalid byte sequence in UTF-8'.

Encoding your CSV files in the UTF-8 format will ensure that TradeGecko is able to correctly read the contents of your CSV files.

We’ll guide you through selecting the UTF-8 format for the most commonly used applications:

Microsoft Excel 2016

Windows

  1. Open your CSV file Excel document.
  2. Click File in the upper left corner.
  3. Select Save As towards the left-hand side.
  4. Directly below the name of your file, there’s a file type dropdown menu. From here select CSV UTF-8 (Comma Deliminated) (*.CSV).
  5. Save your file, then upload into TradeGecko as normal.

    WinExcel.png

Mac

  1. Open your CSV file Excel document.
  2. Click File in the Menu Bar.
  3. Select Save As towards the left-hand side.
  4. Directly below the name of your file, there’s a file type dropdown menu. From here select CSV UTF-8 (Comma Deliminated) (*.CSV).
  5. Save your file.

    MacExcel16.png

Google Sheets

  1. Open your CSV file in Google Sheets.
  2. Click File in the upper left corner.
  3. Select Download As in the File menu.
  4. Select Comma-separated values (.csv, current sheet)
  5. Save your file, then upload into TradeGecko as normal.

    Gsheets.png

Once your CSV file has been saved using UTF-8 encoding it's ready to be uploaded into TradeGecko. 

Note
If you need assistance with a different application, please feel free to contact us.
Print Friendly Version of this pagePrint Get a PDF version of this webpagePDF
Have more questions? Submit a request
Was this article helpful?
2 out of 3 found this helpful

Comments

NEW TO TRADEGECKO? START A 14 DAY FREE TRIAL, NO CREDIT CARD REQUIRED