Author

Profile Image 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.


Welcome to the JotForm blog, where you can read about new JotForm features and find helpful online form tips for creating top-notch forms, user case studies, and much more.

Feel free to stay a while, drop a comment or two, laugh at our corny jokes, and make sure to share the articles you like on social media.




Connect Your Forms to Excel with Zapier

June 22, 2016

Connect JotForm to Excel

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! 



5 Comments...


   
goquote (June 23, 2016 at 08:48 AM)

Can you connect to google sheets?

View Answer


   
jackieohs (June 23, 2016 at 08:57 AM)

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

View Answer


   
David_Sanchez (June 23, 2016 at 11:47 AM)

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


   
AngeroDAVID (June 27, 2016 at 09:47 AM)

its okay


   
GuyPalinckx (September 21, 2016 at 08:42 AM)

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

Any idee?

G

View Answer


Send Comment