In this article we will give an overview of how to download your data into a spreadsheet, for a specific form.

In order for you to do this, your form will have to have a Device Magic Database Destination. This web store is created by default on creation of a form.
The Device Magic Database is where you can download form submission data.

To access your submissions, first go to your Forms list. You can either click the button in the submissions column next to your form or click on the settings icon on the right hand side and click on "submissions".

Note: If there are no submissions this form, this button will read "0".

You'll then be redirected to your form's Device Magic Database.
If you have submissions in your Device Magic Database (Web store), you will see a list like this:

1) Select the entries you'd like to download to the left of each submission.

2) Then, click the 'Bulk Actions' button and select the format in which you'd like to download the data. A download will be triggered.

To download all your form's submissions, click "Download All" in the top-right-hand corner, and select Excel or CSV file.

For large downloads (more than 1000 submissions) you will see the option to select 'Send to email' after selecting 'Download All'.

This is to prevent your browser from timing out while it processes a large amount of data.

After selecting 'Send to Email', enter your email address, select your format and select a date range.
Click 'Export' and an email will then be sent to the email address you specify with the attached document.

Once you have downloaded and opened your Excel / CSV data export file, you should be able to see your submissions in a spreadsheet format. Some meta-data as well as your Field Labels will be set as column headers and your submission data will be in rows beneath this.

Note: When using Repeat Groups in your form, a row will be created for each repeat group entry. This will contain each repeat group item's unique data and duplicate the rest of the submission's data in the row. Please reference the "Submission ID" for associated data.

You may find empty columns in your spreadsheet. This could mean that the field was not completed in the submission, or these empty columns may be from old fields that had data, but have since been removed from your form. If you would like to remove these additional columns, use either of the 2 methods below:

2. Remove your form's Device Magic Database Destination from your form's Destination's list.

Then add the Device Magic Database Destination again.

The Device Magic Support Team can redeliver any submissions which don't contain the unwanted fields that create these columns.

3. Make a copy of your form. Upon submitting a form to the copy (new form), only fields that have data will create columns. Please note, that old submissions will only be visible in the original form and cannot be copied over to the new form.

If you have any questions or comments feel free to send us a message at support@devicemagic.com.