...
Why do I need to save my spreadsheet as UTF-8 CSV instead of .xls, .odt, or another filetype?
...
Microsoft Excel and many other spreadsheet applications do not properly handle Indigenous characters using the default 'Comma Separated Values (.csv)' exporter, or the other usual spreadsheet filetypes like .xls, .odt, etc.
By saving your spreadsheet as a .csv UTF-8 (comma delimited), you will ensure that your entries will render properly with all of the correct characters.
...
How to save your spreadsheet
...
as UTF-8 CSV
...
Most spreadsheet applications are able to save and/or export in CSV UTF-8 (comma delimited) format.
| Tip |
|---|
Choosing an application FirstVoices recommends OpenOffice or LibreOffice because they handle Indigenous characters correctly using the Save As: CSV option. They are also open-source projects. |
Open Office
If you are using Open Office, once your file is ready click "File".
Click "Save as".
Select "Text CSV (.csv)" under the "File type" drop down.
After choosing "Save anyway" accept the default settings (as per the image below) by clicking OK.
Excel
If you are using Excel, once your file is ready click "Export".
Click "Change File Type".
Click "Save As Another File Type".
Choose "CSV UTF-8 (Comma delimited) (.csv)" format
...
If you are using LibreOffice, once your file is ready click "File".
Click "Save as".
Select "Text CSV (.csv)" from the "Save as type" drop-down.
Check the "Edit filter settings" options.
Click "Save".
From the "Export Text File" dialog box that appears, select the "Unicode (UTF-8)" option from the "Character set" drop-down.
Click "OK."
...
If you are using Numbers, once your file is ready click "File".
Click "File".
Hover over "Export To" and click on "CSV".
Click "Advanced Options".
Select "UTF-8" as the choice for Text Encoding.
Click "Next".
Select the save location for the file
Click "Export."
...
Choosing an application
...
| Note |
|---|
Check your file!After exporting/saving your file in UTF-8 CSV format, always open the exported file to make sure that all your words and characters are displaying correctly in the new format. |
...