Create a UTF-8 encoded .CSV file

Envisio Analytics file upload feature requires UTF-8 encoded .CSV files. This type of encoding ensures that your data will be parsed properly. This article will show you how to save your .csv file with UTF-8 encoding if this encoding is not offered where you exported the data from.

Excel For Windows

1. Open your file in Excel. Then select Save As.
2. In the Save As Type dropdown menu, select "CSV (Comma Delimited)"
3. Select 'Web Options' in the 'Tools...' dropdown at the bottom of the dialog box.
4. Select the 'Encoding' tab.
5. In the 'Save this document as:' dropdown, select 'Unicode (UTF-8)' 

 

Excel For Macs

1. Open your file in Excel. Then select Save As.
2. In the Save As dropdown menu, choose the File Format "CSV UTF-8 (Comma delimited) (.csv)"
3. Click Save and close the file.

 

Google Sheet

1. Open the Google Spreadsheet and relevant data tab.
2. Click File > Download As > Comma-separated values (.csv, current sheet)

 

Other Spreadsheets

1. Open the spreadsheet, select the relevant cells and copy the data to the clipboard.
2. Open a new Google Sheet, select cell A1 and go to Edit > Paste Special and click on Paste values only
3. Click File > Download As > Comma-separated values (.csv, current sheet)