CSV file data download error

User Support Data Management
,
1

Hi,

I have an issue exporting the file contained 2nd language, into CSV file. The column mismatched between answer and question which look perfectly fine when I download in excel format.
I have to use the csv file to put data into the online dashboard,
any suggestion would be appreciate,
Okard

2

Hi @Okard,

Would you also mind sharing with us the screenshot of the images from the Excel version as well as the csv version. This would help us understand your issue pictorally.

Have a great day!

3

Hi,
Normally the way a CSV is defined, as you may be aware, denotes comma seperated valued. When using a different application such as IBM SPSS, Stata, or other data analysi/processin application, it is important to really check your conversion protocol clearly. You should know the following about CSV downloaded from Kobotoolbox:

  1. All questions/columns are separated using commas
  2. When your text contains commas e.g, an open text question which required a user to type a long text which has a comma it, then you need to use text delimiter as " " to define text. This will allow a comma within the text question not to be confused as a column seperator.

The problem is that you likely did not define your delimiter appropriately thus the misalignment of columns

Regards,
Stephane

5

Hello,
I have had a similar problem to the one described above. I can see that the issue is that there are commas at various points in the questions and in some respondents’ responses, and this is causing confusion, such that columns do not align and some of one respondent’s responses are entered on new rows (rows 5-9 in the screenshot are responses to the last few survey questions which should appear in row 4):

image
image1990Ă—460 37.5 KB

I am trying to import this data into Power BI. Is the simplest way to fix this to bring it across in xlsx format instead of csv, or is there a simple way of fixing the issues with the csv export?

Thanks!