Exporting form data to Excel

Hello,

I am contracted with a website builder who is helping me create a registration page for our website. We are using Jotform to track registrations. I'd like to be able to track responses in Excel. Is it true that only the owner of the form can do that?

Thank you!

Kate

Hi Kate,

Thanks for reaching out to Jotform Support. I'm an AI assistant. I'll do my best to help you until someone from the support team is available.

Only the owner of the form can export the form data to Excel. The owner can download submissions from Jotform Tables by selecting "Download All" and choosing Excel as the file format. This allows tracking responses easily in Excel.

Give it a try and let us know how it goes.

Best regards,
Jotform Support

Hi Kate,

Do you want to track your registration in real time through a spreadsheet software? If yes, then I can confirm that only form owners can set that up, and we recommend setting up a Google Sheets Integration so that form submissions can be imported to your existing Google Sheet. Let me show you how to set that up. First, let's connect your Google account to the form:

1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.
2. In the menu on the left, click on Integrations and select the Google Sheets integration.
3. Now, select Use an Existing Spreadsheet and click on Next.
4. Then, click on Authenticate and connect your Google account.

Then, let's set up the integration settings:

1. Once you connect your Google account, click on Add Action.
2. In the Select a Spreadsheet section, click on Select, and
3. Select your Google Spreadsheet in the window that opens and click on Select.
4. Scroll down, make sure Send Existing Submissions to the Sheet option is selected and click the on Save button at the bottom right of the settings. That’s it.

Once everything is set up, your existing submissions will be sent to your spreadsheet. Any new submissions to your form will also update your Google Spreadsheet automatically. Check out the screencast below to see how it'll work:

Alternatively, the form owner can easily download data from Jotform Tables as a CSV, Excel, or PDF file. Let me show you how:

1. On your My Tables page, hover over the form whose data you want to download, and click on View Table.
2. On the upper-right side of the page, click the on Download All button. 
3. Now, select Download as CSV, Excel, or PDF to download your data.

You can also check out our How to Download Form Submissions as Excel, CSV, or PDF guide for more information.  Just note that this method, unlike the Google Sheets Integration, won’t show real-time updates for all registrations, so you’ll need to download the data from time to time.

Let us know if you need any other help.