When exporting large amounts of data to Excel, there is an ongoing character encoding issue that occasionally occurs on the export. This will only be a problem if there is a unique character within the data anywhere; it will then appear in the export with additional coding characters next to it. This is happening because Excel tries to localise the character set and changes the format from Unicode to their local format, which can cause issues with unique characters.
This article covers our recommended way to avoid this happening when exporting your data.
To export your data accurately, follow the below steps:
Export your data as you normally would from Insight
Open a new spreadsheet
Select the data button at the top of the page
Select “from text/CSV” in the top left corner
Find your data download (usually it will be in the downloads folder)
Select file origin and change from 1252 to 65001
Select load
The data will then load in the correct format with no character encoding issues.
