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
- Click File > Save As...
- When saving your file, choose CSV UTF-8 (Comma delimited) (.csv).
Windows
- Choose Save as type: CSV (Comma delimited) (*.csv).
- Click Tools > Web Options.
- Go to the Encoding tab and choose Unicode (UTF-8) under "Save this document as."
- Click OK, then Save.
Notepad (Windows)
- Open your file in Notepad.
- Go to File > Save As.
- In the "Encoding" dropdown, select UTF-8.
- Click Save.
TextEdit (Mac)
TextEdit saves files in UTF-8 by default, but you must ensure the file is in Plain Text mode.q
- Go to Format > Make Plain Text (you can also use
Shift + Command + T
to switch between Rich Text and Plain Text).
- Then, go to File > Save.
Make sure the file extension is .csv
when saving.