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 " , "?

  1. Go to your Settings page clicking on the link in the top-right corner of your screen (You have to be an admin)
  2. 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”