All Collections
Troubleshooting
Exporting data - recommended process
Exporting data - recommended process

This article walks through how we recommend you export your data should you need to.

Matthew Hammett avatar
Written by Matthew Hammett
Updated over a week ago

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:

  1. Export your data as you normally would from Insight

  2. Open a new spreadsheet

  3. Select the data button at the top of the page

  4. Select “from text/CSV” in the top left corner

  5. Find your data download (usually it will be in the downloads folder)

  6. Select file origin and change from 1252 to 65001

  7. Select load

  8. The data will then load in the correct format with no character encoding issues.

Did this answer your question?