How to Create a Valid UTF-8 CSV File for Importing

When importing CSV files into YoPrint, the file must be encoded in UTF-8 to ensure all data is read and processed correctly. Here's how to save your CSV file in UTF-8 format using different tools.

Google Sheets (Web)

Go to File > Download > Comma-separated values (.csv, current sheet).

Google Sheets automatically saves the file with UTF-8 encoding.

Microsoft Excel

Mac

  1. Click File > Save As...
  2. When saving your file, choose CSV UTF-8 (Comma delimited) (.csv).

Windows

  1. Choose Save as type: CSV (Comma delimited) (*.csv).

  1. Click Tools > Web Options.

  1. Go to the Encoding tab and choose Unicode (UTF-8) under "Save this document as."

  1. Click OK, then Save.

Notepad (Windows)

  1. Open your file in Notepad.
  2. Go to File > Save As.
  3. In the "Encoding" dropdown, select UTF-8.
  4. Click Save.

TextEdit (Mac)

TextEdit saves files in UTF-8 by default, but you must ensure the file is in Plain Text mode.q

  1. Go to Format > Make Plain Text (you can also use Shift + Command + T to switch between Rich Text and Plain Text).

  1. Then, go to File > Save.

Make sure the file extension is .csv when saving.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.