When I open the CSV file I exported, all data appear in 1 column instead of several
It
may happen that your spreadsheet editor (Excel for example), when you
open the CSV file you just exported from BeeBole, will show the data in
one single column instead of nicely splitting them in several columns.
The
reason behind this behavior is that CSV files (Comma Separated Values)
are splitting data into columns using " , " as separator by default. But
in certain countries, the default value used as separator is " ; "
instead.
So, what should you do if your computer expect " ; " instead of " , "?
- Go to your Settings page clicking on the link in the top-right corner of your screen (You have to be an admin)
- In the Localization module, change the "List separator for exports" field from "coma ( , )" to "semicolon ( ; )"
Alternatively,
you might want to change the Regional Settings of your computer if it
happens for several app you use and not only BeeBole
Then, in Windows for example:
Go to Start>Settings>Control Panel>Regional and Language Options.
Click “Customize”.
Enter “,” for “List Separator”
source : http://help.beebole.com/home/faq/csv-format-does-not-work-in-excel
