Please i need assistance as to how to export odk data into stata or others
thank you
@seroo ODK data comes most easily in .csv (comma-delimited) format. If you are using ODK2 you can download csvs with suitcase from your server or export from Tables from a particular tablet. I believe ODK briefcase achieves a similar effect with ODK1 (Collect). You can also send data to google sheets (all of these options are in the docs).
Once you have a csv, STATA can import with an "import delimited" command like this:
import delimited "04_Removal of finalized data/this_week/quest1_00_0/link_unformatted.csv", stringcols(_all) case(preserve) clear encoding(UTF-8)
All the options are documented in import delimited.
Best,
Caroline
3 Likes