Importing data from Excel into KoboToolbox project

I have a project where I started collecting data in Excel but am now switching to data collection in a KoboToolbox project. I would like to upload the data I have in Excel into my KoboToolbox project so that collaborators can see all of the data and download it as needed. I see how to download data but not how to upload data. I have over 3000 records; reentering these into the KoboToolbox project would undoubtedly introduce some level of error that would have to be checked and edited so an upload is preferable. Any tips on how to upload data?

We use kobotoolbox with a mysql database. Your 3000+ can be imported into mysql db and with kobo api you can update mysql table.

ยทยทยท

On Tuesday, 1 August 2017 23:29:34 UTC+1, Elizabeth Moore wrote:

I have a project where I started collecting data in Excel but am now switching to data collection in a KoboToolbox project. I would like to upload the data I have in Excel into my KoboToolbox project so that collaborators can see all of the data and download it as needed. I see how to download data but not how to upload data. I have over 3000 records; reentering these into the KoboToolbox project would undoubtedly introduce some level of error that would have to be checked and edited so an upload is preferable. Any tips on how to upload data?

Hi!
I have exactly the same problem as Elizabeth_Moore. I want to be able to upload form data in CSV form back into a Kobo Form data table. We want to use Kobo as a way for those filling in form to also see the table data of the form. This allows them to view for example if a beneficiary is already registered. Our worry is that we can download backups in csv but if sth goes wrong with the form (lets say it is mistakenly erased or an error occurs) we cannot re-upload the gathered data into a copy of the form. So this function of being able to consult the table would no longer be available.

I am not sure that the answer from Joseph_Aghatise addresses this exactly. Or let us say that I do not understand it properly as more of a lay person. Could you expand on your reply and specify if it addresses specifically this question of uploading csv data back into the table of an form?

Thank you, that would help a lot!

Hi team. I am Romeo. New community Toolbox community.

I have a question indeed. How do I import data excel into kobo toolbox . If any idea or suggestion please feel free to drop me a line.

Welcome to the community @Romeo! This feature at the moment is not available in KoBoToolbox. However you could do the same using python code as discussed in the earlier post:

1 Like