9.6 Export of data to a file
You can export the data captured in a form in order to process it in a business statistics application such as PowerBI or a spreadsheet such as Microsoft Excel. The export is done from the Dashboard’s Form list. If data has been entered in more than one version of the form and you wish to export all of the data records, you must run an export for each of the versions and merge the data manually. You can choose between just exporting “Data”, that is text-based information, or exporting both data and media (pictures, videos, signatures, etc.)
Exporting data only
- In the Dashboard, click on the folder and then the form you wish to export data from.
- Click on the striped menu button next to the version number that contains the data you want.
- Select Export Data if you want to just export the character-based data (text, numbers, dates, etc.).
- Choose between exporting to an Excel file with columns
or a CSV format file with Comma Separated Values (“name,address,city,country,date….”) - The data will now be downloaded to your browser as a ZIP file
and you will find it in your download folder.
You can then open and save the individual files and process the data further in your application of choice.
The ZIP file includes a file named after the Element ID of the main form element. This file contains the main answers to the form questions. Notes, remarks, and repeat answers are stored in separate files.
Exporting data and media
As export files with media may contain many large photos and videos, they may take a long time to generate and cannot be sent as an email attachment. Instead, our Zegeba staff will create a file for you to download from a file link.
- In the Dashboard, click on the folder and then the form you wish to export data and media from.
- Click on the striped menu button next to the version number that contains the data you want.
- Select Export Data and Media to export both text-based data and files with pictures, videos, attachments, signatures, etc.)
- You will now be informed that you must send an email til Zegeba Support.
Press [Request Export] to open your email software with an automatically generated email.
Send this to Zegeba Support.
- After one or two business days you will get an email with a link you can press to download the new export file.