Fix CSV file download issues in Cognism, including column formatting and UTF-8 encoding errors in Excel.
Cognism CSV files use commas as separators and UTF-8 encoding. If the file opens in one column, or characters such as é show as é, Excel is reading it with the wrong settings. The quickest fix for both is to import the file instead of double-clicking it: in Excel, go to Data > From Text/CSV, set File Origin to 65001: Unicode (UTF-8) and Delimiter to Comma, then click Load.
Common questions about Cognism CSV files
How do I export a CSV in UTF-8?
You don't need to change anything when you export. Cognism CSV files are already UTF-8. To keep special characters correct, import the file into Excel with Data > From Text/CSV and choose 65001: Unicode (UTF-8) as the File Origin.
Why do names show strange characters like é instead of é?
Excel opened the UTF-8 file with a different encoding. The data in Cognism is correct. Import the file with Data > From Text/CSV and set File Origin to 65001: Unicode (UTF-8). This also fixes characters that show as ? or empty boxes.
Why is all my data in one column?
Your computer's list separator is probably a semicolon (;), which is common in European regional settings, but Cognism files use commas. Import the file with Data > From Text/CSV and set Delimiter to Comma, or change your list separator to a comma using the steps for your operating system below.
Why do phone numbers lose the + or show as 4.47E+11?
Excel turns long numbers into numbers automatically. Import the file with Data > From Text/CSV, select Transform Data, and set the phone number columns to Text before loading.
The characters broke again after I saved the file. Why?
Saving as plain CSV in Excel can change the encoding. Save it as CSV UTF-8 (Comma delimited) or as an Excel workbook (.xlsx).
Can I open the file without Excel?
Yes. Google Sheets reads Cognism CSV files correctly. Go to File > Import > Upload and select the file.
You may notice:
- All data appears in one column
- Columns look jumbled
- Special characters display incorrectly
These issues usually occur due to regional settings or character encoding.
How to fix common issues with CSV files?
Fix incorrect column separation
If all data appears in one column, your device is likely using a different list separator from the one used in the CSV file.
Most Cognism CSV files use a comma (,) as the separator.
Update your system settings using the steps below, then re-download the file. If the issue persists, restart your device and try again.
Windows 8 and Windows 10
- Close Excel.
- Open Control Panel.
- Select Region (Windows 10: Control Panel > Clock and Region > Region).
Click Additional settings.

- Under the Numbers tab:
- Set Decimal symbol to a full stop (.)
Set List separator to a comma (,)

- Click Apply, then OK.
- Re-download and open your CSV file.
Windows 11
- Open Settings.
- Select Time & language.
- Click Language & region.
- Under Related settings, select Administrative language settings.
- In the Formats tab, click Additional settings.
- Under the Numbers tab:
- Set Decimal symbol to a full stop (.)
Set List separator to a comma (,)
- Click Apply, then OK.
- Re-download and open your CSV file.
macOS
macOS does not allow you to directly set a default CSV delimiter. Instead, apps such as Excel and Numbers use your regional settings to determine the expected separator.
In many European regions, a semicolon (;) is used because a comma is treated as a decimal separator.
Change your region settings
- Go to System Settings.
- Select General > Language & Region.
- Change the Region to a country that uses a comma as the list separator, such as United States.
- Restart Excel or Numbers.
- Re-download and open your CSV file.
Check decimal and thousands separators (optional)
- In Language & Region, select Advanced or Customise (depending on your macOS version).
- Confirm:
- Decimal is set to (.)
- Thousands is set to (,)
These settings influence which delimiter spreadsheet apps expect.
Fix special character issues (UTF-8 encoding)
Import a CSV file using UTF-8 encoding
- Open Excel.
- Select the Data tab.
- Click From Text/CSV.
- Select your file and click Import.
- In the File Origin dropdown, choose 65001: Unicode (UTF-8).
- Click Load.
Excel will now display special characters correctly.
Expected result
- Data appears in separate columns.
- Special characters display correctly.
- The file opens without formatting issues.