I'm having troubles reading CSV files in Excel. What can I do?

Follow

If you're having troubles reading the CSV (character-separated values) files that are downloaded from our platform. You might consider 1 of the following possibilities:

  1. Change the CSV file extension to TXT (when you open a TXT file with Excel it will start the text file import wizard where you can choose the delimiter) 

  2. In your CSV file(s), use a text editor to replace all commas,with semicolons;

  3. In your Windows Control Panel, change your Regional and Language settings

The last solution is our preferred one. To change regional settings:

  • Go to Start > Control Panel > Regional and Language Options
  • Click Additional Settings
  • For Decimal Symbol, enter a dot:.
  • For List Separator, enter a comma:,

Now, when you open a CSV file in Excel it will automatically find the data fields and open it appropriately.

Have more questions? Submit a request

Comments

Powered by Zendesk