Hi, I am trying to export my database to a CSV with multiple Columns
However each time I export, it groups everything into Column A and still separates with spaces
I have tried < tab >, record unit, and other separators but nothing populates in the other Columns of the outputted CSV
What am I doing wrong here?
I’ve just checked and ‘export to CSV file’ works as expected to me. Let me check with the dev team on what could be the potential issue here.
Hey @Emily, which tool do you use to open the CSV file you export? It will be very helpful if you also share a few screenshots so we can better understand what is going wrong with the export.
Turns out I was simply downloading the exported CSV file & directly opening it in Excel.
I didn’t realise I had to ‘import’ the data in an excel file first
Once I did that, the data transposed correctly into the columns
Thank you for the help!