How do I convert CSV files to the UTF-8 encoded format?

ChartMogul only accepts CSV files encoded in UTF-8 — a character encoding standard that ensures your data imports correctly. This guide shows you how to convert any CSV file to UTF-8 using Google Sheets or Microsoft Excel.

How to Convert a CSV File Using Google Sheets

To convert a CSV to UTF-8 using Google Sheets:

1. Navigate to File > Open > Upload and drag and drop your CSV file.
2. Select File > Download > Comma Separated Values (.csv).
3. Find a location on your drive and click Save.

Google Sheets saves your current sheet as a UTF-8 encoded CSV file.

How to Convert a CSV File Using Microsoft Excel

To convert a CSV to UTF-8 using Microsoft Excel:

1. Navigate to File > Open > Browse.
2. From the drop-down of file types, select Text Files (*.prn;*.txt;*.csv).
3. Navigate to the location of your file, select the file and click Open.
4. Go to File > Save As > Browse.
5. From the Save as type drop-down, select CSV UTF-8 (Comma delimited) (*.csv).
6. Find a location on your drive and click Save.

Excel saves the content of the current sheet as a UTF-8 encoded CSV file.

Once complete, upload your data using flexible CSV import or structured CSV import.