Hi everyone,
My data is being automatically uploaded from Kobo to Excel. I recently deleted one field in my Kobo form and added a new question in its place. The new question appears correctly in Excel for all new submissions.
However, for older submissions, even though I went back into each record in Kobo and filled in the new question manually, the data for that question is still not showing up in my Excel file. It remains blank for those older records.
Does anyone know why the manually added data for older submissions doesn’t appear in the Excel export, and how I can fix this so that all updated records are reflected in Excel?
Thanks in advance for your help!
Hello!
Appreciate your feedback on this!
Even after exporting and downloading the XLS file directly from Kobo, all the fields appear empty (those that were edited). Only the new entries are showing. However, when I open a form using “Edit,” I can see the manually adjusted entries — they just don’t appear in the downloaded file.
@mireillejazi, it seems you’re trying to synchronize your KoboToolbox project data with Excel. When you delete a question from a form and add a new one, the deleted question is still stored on the server (project). You can verify this by downloading your data in XLS format.
In this case, you may need to manually hide the deleted variable in Excel or manage it by using the Advanced Options (select questions to be exported) when exporting your data to create a synchronized export (API).
