CSV file downloaded in the wrong format

After exporting a CSV file from Cognism and opening it in Excel, you may notice that the data is displayed in the wrong format. The problem is related to the separator that breaks the data into their respective columns. Please follow the steps below to adjust your settings and then re-download the file. If at first it doesn’t work, please try rebooting your computer and try again.

You may also have data containing special characters and the data may not display properly in Excel. Follow the steps under Import to Excel for these to display in the correct manner.

Jump to a section

Windows 8 and Windows 10 Users

Windows 11 Users

MacOS Users

Windows 8 and Windows 10 Users

  1. Close the Excel file
  2. Windows 8 > go to Control Panel and select Regional and Language Options.
    Windows 10 > go to Control Panel, then Clock and Region and finally select Region.
  3. Click Additional Settings.
    mceclip0.png
  4. Change the ‘Decimal Symbol’ to a full stop ( . ).
  5. Change the ‘List Separator’ to a comma ( , ).
    mceclip1.png
  6. Click 'Apply', then 'OK'.

Windows 11 Users

  1. Open Settings.
  2. Click on Time & language.
  3. Click the Language & region page on the right side.
  4. Under the "Related settings" section, click the Administrative language settings option.
  5. Click the Formats tab.
  6. Click the Additional settings button.

     

     

  7. Click the Numbers tab.
  8. Change the ‘Decimal Symbol’ to a full stop ( . ).
  9. Change the ‘List Separator’ to a comma ( , ).

     

     

MacOS Users

Mac OS version 10.10.1.

  1. Close the Excel file.
  2. Click on the Apple button and go to System Preferences.
  3. Select Language & Region and click Advanced.
  4. Change the 'Decimal' separator to a full stop ( . ).
  5. Click on OK/Save.

Import to Excel

Microsoft Excel is unable to properly display UTF-8 compliant CSV files when they contain special characters. As a result your file may include ‘?’ or random symbols instead of non-English characters like:é, è, ç etc.

As a result it’s always recommended to import such files into Excel instead of opening them directly.

To do so you can follow the steps below: 

1. Open Excel

2. Click the 'Data' menu

3. Click on 'From Text/CSV"

4. Find the file you want to import. Click on file > Import

5. Choose "65001: Unicode(UTF-8) in the top File Origin dropdown

6. Click 'Load'

Was this article helpful?
0 out of 3 found this helpful

Comments

0 comments

Please sign in to leave a comment.