Hi Kate,
Why is CBT exporting the .csv into one column in excel?
Cheers and thanks,
Gerhard
Hi Kate,
Why is CBT exporting the .csv into one column in excel?
Cheers and thanks,
Gerhard
Hi Gerhard
This is not a CyberTracker issue, but an Excel issue. Your Excel is not recognising the commas in the CSV as separators.
You have two options:
Import data
Changing your settings
From this article:
The behavior of Excel when opening CSV files heavily depends on your local settings and the used list separator
under Region and language » Formats » Advanced
. By default Excel will assume every CSV was saved with that separator.
The list separator should be set as a comma.
Not sure what version of Windows (are you using Windows?) you have, in Windows 10 you need to go through the old Control Panel (press Start and type Control Panel).
Kind regards, Kate