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.

 

For 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'.

 

For Mac 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.
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.