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:
- All questions/columns are separated using commas
- 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