I need an efficient way to connect enumerators’ tablets and extract data in Excel format. Unfortunately, I can’t access the original server where the tool was developed, which is why I need to retrieve the data directly from the tablets instead me going through manually.
I would greatly appreciate your guidance on the best approach.
You can pull submitted forms directly off plugged-in devices using adb. There are some instructions how to do this here: Using Android Debug Bridge with Collect - ODK Docs. [KoboCollect is ostensibly a rebranded ODK Collect, so the same instructions apply]
Note, this submission data with be in its raw XML form, so it will still need to be manually ‘submitted’ into Kobo or otherwise translated to convert it into an Excel spreadsheet. But at least you will have a copy of all the raw data.
Again, all these approaches require attaching your device via a USB cable to a computer, navigating down the on-device filesystem on the phone to the location where filled-in forms are stored, manually copying them onto your computer (via USB) and then manually submitting them from your computer instead.
If you still have problems with this please post a (new) followup on the Forum here describing exactly what approach you tried and what isn’t working.