Importing xls data into KoBoToolbox

Hello im a cobocollect user, i have an issue with my collected data.

I analysed a work that i collected with cobocollect and i downloaded the file into excel but after some time i deleted the record on my server but im still having the excel file. My question is to know if there is any way that i can import that excel file into cobocollect serveur.

Please i need your help.

Hi @Gloire,

Sorry to inform you that at the moment KoBoToolbox does not have a feature that would support uploading xls data into KoBoToolbox.

It is a very required function, you should seriously think about implementing it. Something similar happens to us, we have about 600 records that update and load 1 to 1 means a lot of time and resources that we do not have.

2 Likes

Hi @Kal_Lam,

Do you know if this feature will exist in the near future? We are transferring from another survey platform and are having a difficult time figuring out how to get our old records into Kobo. We’ve looked into ODK, but if there is no way to import .xls files, the only apparent solution is to write a script that converts the each record from the .xls to its own xml file. We’re really trying to avoid this as each survey would need a custom script.

If no xls import feature is coming, are there any tools you know of that would help with this?
Thanks!

@sareep, a while back have created a method for converting XLS data into XML with a Python script so that they can be submitted via the API. This requires an existing deployed form to be in your account.

Everything is documented in this repository: https://github.com/kobotoolbox/xls-import. I hope this works for you.

1 Like
How do i import csv data to KoBoToobox server?
Import data from XLS?
Is it possible to upload xls dataset into KoBoToolbox server?
You Cant Upload Data in XLS onto the Platform
Migrating data from another platform to KoBoToolbox
Uploading or transferring data from one KoboToolbox survey to another (after data cleaning)
Nested group issue on xls-import script
How we can upload a data in excel to Kobo Toolbox to generate a map?
Data management (Data Import)
Data Cleaning & Uploading Excel files into Kobo
Importing data from Excel into KoboToolbox project
Upload data to Kobo
Transferring data from OCHA server to HHI server
About transfering of data from one server to other
How to import data in KoBoToolbox
Data Transfer / Migration between different servers or account
Data edit in excel and uploading it to kobo to generate report
Can I export a project from KoBotollbox server to my own server?
How to upload old form data to new form?
Receiving Data from a different User
Decrypt Data then return to Database
Uploading xls data back to the KoBoToolbox server
Any way to change the submitter username after the instance has been submitted?
Import data to another account
Bulk Upload
How to update existing data
Integrate existing data into a new form
Data from OCHA server to my own server (self hosted KoBoToolbox server)
Import data to a project from CSV file
Transfer old entries to kobo
Uploading xls data sheet into Kobotool
KoBo API examples, using new KPI endpoints
Adding Submissions to Kobo toolbox using submissions endpoint
Move records from one data sheet to another
Enkoto showing empty record when wanting to edit
Kobo API & Beyond
Import record
I downloaded and edited my data. I want to upload again now. How can I do it?
Anticipate issue of uploading questionnaire in a remote area
Importing data into kobo via the REST api
Restoring data from a deleted form
Edited Data upload and replace

Hello, will this work on csv file (decrypted data from kobo)?

Thanks!

Hi @james_murillo
Ideally it should. Have you checked the article indicated in the last post?

Stephane