All records CSV file does not display correctly
Can't read the file you just downloaded? Don't worry!
There are two ways to solve this problem:
1. If you use Excel to view your CSV file: 2.
By default, Excel processes txt / csv files with Windows Charset (ANSI).
This is how it works when you open the file by double clicking on it. Excel takes over and applies the default charset.
To choose the correct charset, open a new blank sheet and choose charset 65001: Unicode (UTF-8).
The import should be successful and you should be able to see the data split into columns.
2. If you use Google Sheets to view your CSV file:.
Select the first column, where all the data is stored.
Search for Data and click Split text to columns.
Select the comma or semicolon to split the data and you're done!
There are two ways to solve this problem:
1. If you use Excel to view your CSV file: 2.
By default, Excel processes txt / csv files with Windows Charset (ANSI).
This is how it works when you open the file by double clicking on it. Excel takes over and applies the default charset.
To choose the correct charset, open a new blank sheet and choose charset 65001: Unicode (UTF-8).
The import should be successful and you should be able to see the data split into columns.
2. If you use Google Sheets to view your CSV file:.
Select the first column, where all the data is stored.
Search for Data and click Split text to columns.
Select the comma or semicolon to split the data and you're done!
Updated on: 15/12/2023
Thank you!