Importing Data using XLS

[ife]

Hello Team.

My team had been using Scan IT for data collection before we discovered KoboToolbox.

The data collected so far has been exported as xls. Is there a way we can import the file (data) into Kobotoolbox such that we can data can become part of the new data being collected through Kobo Collect?

[Kal_Lam]

@ife, you should be able to upload your data to the KoboToolbox server using this python script:

Uploading Data from XLS to the server

Hi @brighton_zocs, you can try using this (no longer supported) script: You can also try following these yet-to-be-published, draft tutorials on doing this through the API: Part 1 Part 2

If you are not familiar with python, you could also upload your survey project with the ODK Briefcase as outlined in the post discussed previously:

Can I push data, which have been pulled from Aggregate?

Hi @imran3may, You could migrate your KoboToolbox project from one server (from humanitarian to non-humanitarian or vice versa) to the other using ODK Briefcase as follows: In this post, I will illustrate on how to migrate a survey project from a non-humanitarian server (Kobo server) to a humanitarian server (OCHA server). At the moment, my non-humanitarian server (Kobo server) has a project with 5 submissions. [Image 0_1] I would wish to migrate this project to the humanitarian server (OC…

[ife]

Thank you for your prompt response @Kal_Lam. However, I’m not familiar with Python and the second option shows how to migrate from one server to another using ODK Briefcase.

The data I have was collected via google server. Will the ODK Briefcase solution still work with google server?

[Kal_Lam]

@ife, if it’s comparable with ODK then it should solve your issue.

[ife]

Thank you @Kal_Lam