Kobo report opening in exl not in colums

User Support Data Management
1

Hi, please i need a help. When I down load a report and open it in excel, the report open as a straight rows not in column

Kobo exl Error
Kobo exl Error1043×688 634 KB

2

@samsamba
You’re downloading the report in CSV and it uses ; as separator.
You can either download directly as XLS.
Or use Text Import Wizard to open the CSV and set the separator as ;

1 Like
3

@nmambre, :clap: :heart: :partying_face:

4

@samsamba, this support article Exporting and Downloading Your Data should also be helpful for you to understand more options when downloading your data.