How to export form submissions to excel?

How to export form submissions to excel?

With 123FormBuilder you can manage your submissions as you see fit in the Submissions section and export them to CSV or Excel (.xlsx format). Exporting your submissions to CSV is explained in this article. Below we will explain how to export to excel your form submissions, as follows:

1. Once logged in your 123FormBuilder account, go to the Submissions section of your form.

2. Use the drop down on the top right side of the submissions table to select Excel.

export to excel form submissions

3. A lightbox will popup on screen where you may type the email address where the download will be sent to. By default, your email address associated to your 123FormBuilder account will receive the download. You may opt to include or exclude the table header by checking the box.

We do not send the excel file in the content of the email, but the link from where you can download it. This is a measure to secure your data.

how to export to excel submissions

4. Press Download EXCEL and wait for the email that contains the downloadable link.

If you have problems receiving emails from 123FormBuilder, try creating a white list in your email client, as explained in our documentation here.

Finally, the email with your excel export should look as in the image below.

export to excel form submissions

If you require assistance, don’t hesitate to contact customer support at support@123formbuilder.com.

Olivian Stoica
Olivian Stoica
Oli's enthusiasm for helping our fellow users led him to write thorough know-how articles and tutorials that would make form building a bliss on 123FormBuilder.

6 Comments

  1. Michele says:

    Can I exclude certain columns from the download? I’m not interested in columns like IP address, browser, referrer and so on.

    • vlad says:

      Hello Michele.

      When downloading submissions columns cannot be excluded. You can, however, manually delete the respective columns from the spreadsheet. You will be able to select a whole column containing multiple data and after pressing the Delete button, all the information from that column will disappear.

      If you need further assistance, please do not hesitate to contact our Support team at support@123formbuilder.com, or, via our contact form.

      Thanks!

  2. adam says:

    I don’t receive the email containing the download link. Why is that?

  3. Rachel says:

    Can I automate form export downloads on an interval basis (say: daily)?

    • vlad says:

      Hello Rachel,

      Please note that exporting submissions can only be triggered manually. You can, however, integrate Google Drive on your form in order to have submissions directly sent to a spreadsheet. In this case the spreadsheet is automatically updated after each submission.

      Please make sure to contact our Support Team at support@123formbuilder.com, if you need any further assistance.

      Thanks.

Leave a Reply

Your email address will not be published. Required fields are marked *