How can we Help?

CSV Files and Regional Settings

Follow

This is the solution for customers that are trying to import reports from a .csv file, and the results only appear in the first column. In order to prepare the .csv (comma separated variables) files correctly in your spreadsheet application (e.g., Excel, Google Sheets) please follow the steps below. We have covered Windows and Mac operating systems.

Windows

Follow the steps and retest the import when complete. If at first it doesn't work, try rebooting the machine and try again.

Windows 8 & Windows 10

  1. Close the spreadsheet application.
  2. Windows 8 - click Start and select Control Panel. Select Regional and Language Options.
    Windows 10 - click on Start, start typing “Control Panel”, select it, and go to Region.
  3. Click Additional Settings.
    CSV_Win_1.png

  4. For “Decimal Symbol”, enter a full stop ( . ).
  5. For “List Separator”, enter a comma ( , ).
    CSV_Win_2.jpg

  6. Click on Apply, then Ok.


Windows 7

  1. Close the spreadsheet application.
  2. Click Windows/Start and select Control Panel.
  3. Select Region and Language and click on the Formats tab.
  4. Click on Additional Setting and locate the List Separator.
  5. Change the Decimal separator from a full stop (.) to a comma (,).
  6. Click on Apply, then Ok.

Mac

Follow the steps and retest the import when complete. If at first it doesn't work, try rebooting the machine and try again.

Mac OS version 10.10.1.

  1. Close the spreadsheet application.
  2. Click on the Apple button and select System Preferences.
    CSV_Mac_1.png

  3. Select Language & Region and click Advanced.
    CSV_Mac_2.png

  4. Change the Decimal separator from a comma ( , ) to a full stop ( . ).
    CSV_Mac_3.png
  5. Click on Ok/Save.

Mac OS version 10.8.3.

  1. Close the spreadsheet application.
  2. Click on the Apple button and select System Preferences.
  3. Select Language & Text and click on Region.
  4. Under Numbers select Customize.
  5. Change the Decimal separator from a comma ( , ) to a full stop ( . ).
  6. Click on Ok/Save.

Mac OS version 10.7.4.

  1. Close the spreadsheet application.
  2. Click on the Apple menu button and select System Preferences.
  3. Select Text & Language and click on Formats.
  4. Under Numbers select Customize.
  5. Change the Decimal separator from a comma ( , ) to a full stop ( . ).
  6. Click on Ok/Save.

 

 

All Articles ""
Please sign in to submit a request.