If your form includes a photo, video, or sound recording question, these files will be uploaded to the server along with your other data. When exporting your dataset to XLS or CSV these files will include references to the filenames of the media attachments, but not the files themselves. To download your media files choose the ZIP option under 'Download data'.
The following explains other options for downloading and accessing your collected media files.
Adding direct hyperlinks to collected media in Excel
- Download your data to XLS and open the file
- In a new column next to the one that contains the filenames of your images, enter the following formula: If using the KoBoToolbox server: =HYPERLINK("https://kc.kobotoolbox.org/attachment/original?media_file=username/attachments/"&A2) If using OCHA's server: =HYPERLINK("https://kc.humanitarianresponse.info/attachment/original?media_file=username/attachments/"&A2)
- In the formula replace 'username' with your own username and 'A2' with the first cell reference that contains the file name of your photo. Then copy the formula down for all your records.
Creating an alternative batch download of collected media
As an alternative to the ZIP download of all your media files (which can take a long time to download in case of a large number of collected images or videos), use the following trick to download all or some of your media as quickly as possible:
- Save your Excel file with the added hyperlinks (see instructions above) as an HTML file to your Desktop, using the File > Save as... option (choose 'Web page')
- Log in to your KoBoToolbox account where your photos are hosted using the Firefox browser
- In Firefox install the DownThemAll extension
- Still in Firefox, open the HTM web page saved on your Desktop
- Right-click somewhere on that page and choose 'DownThemAll!...'
- Choose a folder on your computer where the images should be saved
- Under 'Filters' choose 'All files' and then click 'Start!'
- Optional: In the window that opens set a download speed limit to avoid using all available bandwidth. The settings also allow you to set the number of attempts that should be made for each file in case of connection issues.
If you have a lot of media files this will take a while to download. But the DownThemAll download manager will make sure you have downloaded all the images and let you know in case any of them were not downloaded so you can try again.