Forum Discussion
Excell and .csv files
How to I get Excell to open .csv files and automatically (when I double click the downloaded .csv file) open in in column format?
1 Reply
Excel should automatically split the data into columns if the .csv file uses the same list separator as specified in your system (usually comma for countries that use point as decimal separator, and semi-colon for countries that use comma as decimal separator).
Otherwise, all data will be in the first column, and you'll have to use Data > Text to Columns to split the data.
