Author Profile Image

AUTHOR

Aytekin Tank

Aytekin Tank is founder of JotForm. He currently leads the JotForm development team. He loves to hear from JotForm users. Feel free to shoot him an email at aytekin at jotform.com.

SUBSCRIBE TO OUR NEWSLETTER

Don’t miss out the latest posts!

Connect JotForm to Excel

Connect Your Forms to Excel with Zapier

Looking for a way to send form submissions to Microsoft Excel? With Zapier and JotForm, you can. If your company already depends on Excel to manage data, this integration should come in handy. You can add new rows for every new form submission you receive, or even update existing rows if you want to allow users to adjust their submissions.

Just make sure you have your Excel files on a Microsoft OneDrive for Business account (which is included with Office 365 or Sharepoint Server), otherwise we won't be able to access them. 

Setup Assistance:

Once in your Zapier account, you’ll start by connecting your JotForm account. 

Then connecting your Excel account. 

Then you'll choose the form you’d like to connect with Excel. 

JotForm and Excel

Select which Excel file and form fields you’d like merged. 

 

And just like that, your form is ready to send data straight into your Excel file: Whenever someone submits a new response to your form, Zapier will copy it over for you. The great thing about this integration is that you can choose custom fields you’d like merged, so you can pick and choose if you don’t need data from the entire form. Whatever’s most important to you and your team will be seamlessly imported into your working Excel sheet. 

Here's a quick form with the form fields filled out. 

And here's how it shows up in Excel immediately after you submit the response. Just like that! 


Do you use Excel? What kind of data will you send to Excel files using JotForm? Let us know in the comments! 


Author Profile Image

AUTHOR

Aytekin Tank

Aytekin Tank is founder of JotForm. He currently leads the JotForm development team. He loves to hear from JotForm users. Feel free to shoot him an email at aytekin at jotform.com.

Send Comment

5 Comments...

  • GuyPalinckx

    I'm having issues to connect with excel, I keep on getting error messages that Zapier can't connect to Excel.

    Any idee?

    G

  • AngeroDAVID

    its okay

  • David_Sanchez

    Is the tool perfect for my work, thank you for the help and soport.

  • jackieohs

    is there any way to get around using onedrive? we don't like onedrive.

  • goquote

    Can you connect to google sheets?