All Collections
Accounting
Why are there strange symbols in my CSV export?
Why are there strange symbols in my CSV export?
Cee avatar
Written by Cee
Updated over a week ago

All our CSV files are exported with UTF-8 encoding. By default, programs such as Microsoft Excel do not load the files with their correct UTF-8 encoding, and so may display foreign characters or punctuation in odd ways.

To view the files correctly in Excel, please use the following steps:

  1. Open Microsoft Excel.

  2. Click on the Data menu bar option.

  3. Click on the From Text icon.

  4. Navigate to the location of the file that you want to import. Click on the filename and then click on the Import button. The Text Import Wizard - Step 1 or 3 window will now appear on the screen.

  5. Choose the file type that best describes your data - Delimited or Fixed Width.

  6. Choose 65001: Unicode (UTF-8) from the drop-down list that appears next to File origin.

  7. Click on the Next button to display the Text Import Wizard - Step 2 or 3 window.

  8. Place a checkmark next to the delimiter that was used in the file you wish to import into Microsoft Excel 2007. The Data preview window will show you how your data will appear based on the delimiter that you chose.

  9. Click on the Next button to display the Text Import Wizard - Step 3 of 3.

  10. Choose the appropriate data format for each column of data that you want to import. You also have the option to not import one or more columns of data if you want.

  11. Click on the Finish button to finish importing your data into Microsoft.

Please note that if you are importing the sheets back into Label Engine after converting, either save them as xls / xlsx, or be sure to save them with UTF-8 encoding.

Did this answer your question?