Encoding CSV file in UTF-8

For your store locations to import properly your .csv file must use UTF-8 character encoding. If your spreadsheet isn't already encoded in UTF-8 or you're unsure you can use Notepad if you're using Windows or Google Docs to convert it for you by following the instructions below.

UTF-8 Encoding with Notepad

Windows users only.
  1. Save your spreadsheet as a .csv file.

  2. Open Notepad on your computer.

  3. Click File and then Open.

  4. Find your .csv file and click the Open button.

  5. Click on File and Save As.

  6. Add .csv to the end of the File name. For Save as type select All files and for Encoding select UTF-8. Then click Save.

  7. Your new file is ready to be imported.

UTF-8 Encoding with Google Docs

  1. Login to Google Sheets: https://www.google.com/sheets using your Google account or create a new account if you don't already have one.

  2. Under Start a new spreadsheet click on Blank.

  3. Click on File and Import.

  4. In the window that appears select the Upload option.

  5. Click on the Select a file from your computer button and find your .csv file on your computer to upload it.

  6. In most cases keep the Replace spreadsheet and Detect automatically options selected and click the Import button.

  7. Click on File and Download as.

  8. Select Comma-separated values (.csv, current sheet) and save the file to your computer. Google will automatically encode your .csv file in UTF-8.

  9. Your new file is ready to be imported.

Need help? Contact us at: [email protected]