Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Title: Windows "List separator" settings may cause CSV Return Value of Excel (.xlsx) contents not to separate columns properly with commas.


Q.  I am using CSV as Return Value of a plugin and reading data from an Excel file (.xlsx). However the CSV results put all columns in one column and do not separate them correctly. How do I fix it?

A. One likely cause is the settings of your Windows. Windows has a setting called "List separator". It is hidden deep at the bottom layer of Region settings (for some Microsoft reason).

    Please follow the steps below. It should fix it.

Image RemovedWindows

Go to
Settings => Region => Related Settings (Additional date, time, and regional settings)
You will now arrive at 
Control Panel\Clock and Region
Click Change date, time, or number formats

Click Additional settings...


List separator to comma as in the second popup window.

Need help?

Technical contact to tech@argos-labs.com


May you search all documents,


Excerpt Include
FAQ
FAQ
nopaneltrue