How to export 123FormBuilder form submissions to Excel?

With our form builder, 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 your form submissions to Excel, as follows:

1. Once logged in to your 123FormBuilder account, select the desired form to open its Form Editor. Afterward, click on the Results button to access the Submissions section.

Results - Submissions

2. Use the dropdown on the top right side of the submissions table and select Excel.

Export to excel

3. A lightbox will pop up on the screen where you can type the email address where the download will be sent to. By default, the email address associated with 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.

Export to Excel 123FormBuilder

Another option of exporting your Excel/CSV file is to Download file directly in browser. If you check this option, your file will be downloaded directly in browser and not sent via email.

Download file directly in browser 123FormBuilder

4. Press Download EXCEL and wait for the email that contains the downloadable link. If you checked Download file directly in browser, then a banner will be shown at the top of the page and the file will automatically download in that page.

Export submissions

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

Finally, the email with your Excel export will look as in the image below.

Download excel link

Important Note

In order to be able to download the .xlsx file, you need to be logged in to your email account and 123FormBuilder account in the same browser.

When using Export to Excel option, maximum 10,000 submissions will be available in the exported file. If you need to export more than 10,000 submissions, we strongly recommend using CSV option and then formatting the file as needed.

23 comments

  1. Do I know have to have a paid version in order to download to Excel? It has worked in the past but now all I get is an upgrade screen.

    1. Hi David! That is correct, for quite a few years now the option to export submissions to excel or CSV has become available starting from the Gold plan. Please feel free to contact us if you need any help finding the plan that best suits your needs.

  2. I have been using a starter plan and all of a sudden export to excel no longer functions, and I am asked to upgrade to a Gold Plan before exporting is available again. This is totally not acceptable as I am already using a paid-plan. Please fix it and allow the old function of exporting to excel via email again at once, or I have to stop paying for the starter plan immediately. After all, I have not seen a notice from your company about changing the contents of my plan.

  3. I keep getting the following message?
    “You must log into your account before exporting the message archive to EXCEL. Make sure you access the EXCEL archive in a browser where you are already logged in.”
    I am logged into my 123 account and email on the same browser.

    1. Hi Sara! This happens when you access the download link from a different browser than the one in which you are logged in to you 123FormBuilder account. For example, let’s say that you normally use browser A when working with your forms. But browser B is set as default for opening email links. The download link will not work, because it will open up in browser B, whilst you are authenticated on 123FormBuilder account in browser A. Please set that your download links are opened in that browser as well. If you still encounter that error, please drop us a line here.

  4. Can you exclude entrys from the download. I would be running reports weekly and do not want to include entries from a previous week. It would be nice to be able to use the checkbox to indicate whether you want to include that entry in the Excel or CSV download

    1. Hi Anne! You need to apply a filter to your entries. Click on Advanced search at the top of your submissions table and used the data filter (submissions from X date to Y date) to show the relevant data for your reports. After that, select them all and hit Export – Excel/CSV. In the spreadsheet you will see only the filtered entries. Here is a screenshot to guide you.

  5. Why am I getting the following message?
    “You must log into your account before exporting the message archive to EXCEL. Make sure you access the EXCEL archive in a browser where you are already logged in.”

    I am logged into my 123 account.

  6. I keep trying to export submissions to excel. When I get the email with the link, the link sends this message:
    You must log into your account before exporting the message archive to EXCEL. Make sure you access the EXCEL archive in a browser where you are already logged in.

    I don’t understand what this is asking me to do? I am logged in to my account and following all the instructions exactly. Please explain?

    1. Hi Amy,

      When downloading submissions as an Excel or CSV file, you need to be logged into both your 123FormBuilder account and your email account, in the same browser session. This requirement is an additional security feature.

      Thanks.

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

    1. 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 page.

      Thanks!

    1. 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 *

Frequently Asked Questions

Here is a list of the most frequently asked questions. For more FAQs, please browse through the  FAQs page.

Is this service free?
Yes, we offer a free form builder service. Just sign up to the Basic plan and you are all set. This plan is forever free, but you are limited with a few features only, such as 5 forms per account, 100 submissions per month and you have to keep the backlink to 123FormBuilder on your forms. Check out our features matrix for more information.
How many forms can I create?
It depends on the service plan you are on. Higher service plans enable more features, including more web forms for your account. If you need more forms, go to the My Account section of your account and click the upgrade button. To create an unlimited number of forms, either upgrade to the Platinum service plan or higher. Consult our features matrix for more information.
How can I publish my forms?
You can publish your forms in many ways, by using their direct URL or HTML link, embedding them with a JavaScript code, Inline HTML or iFrame, using the Facebook app or the WordPress plugin, using popups, the Blogger code snippet and many more. Once you have created and customized your form, go to the Publish section to complete your work. Read more in our documentation.
How do I change my form design?
You can change the design of your form for more information. in the Themes section, which is located in your form settings. We offer a set of more than 30 predefined form themes for your forms, but you can also create your own from scratch. You can customize the submit button, the logo and more. To apply your own stylesheets, all forms come with a custom CSS editor.

Can't find what you're looking for?