Problems in trasferring rating variable from Kobo to Excel

User Support Data Management
#1

Hi everyone!
I’m new in Kobo, I had a problem with transferring data from a question which rate from 1 (poor) to 5 (very good) in Excel… I want the variable to show the chosen number (1 or 2 or 3 etc…) but instead it appears on the Excel sheet as 1 for the chosen answer and 0 for the others together with a string type variable showing the label of the chosen option.

Thanks for your answer!

#2

Welcome to the community @chiara_cris82! Would you mind sharing with us a screenshot of the data that you see in your server i.e. DATA>Table and also a comparative screenshot of what you see while downloading the same in your excel data format.