What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Integrate Jotforms with ExcelAsked by Tania on May 07, 2014 at 11:01 AM
I am trying integrate JotForms with excel. I have a sophistacted formula heavy excel spreadsheet that I use to track the JotForm responses. Normally I have to run the excel report in JotForms, locate just the NEW submissions and copy and paste those into my existing formula heavey excel spreadsheet. Is there anyway to automatically pull in just the new submissions and add them to my existing spreadsheet without me having to locate the new submissions and copy and paste into the spreadsheet.
Unfortunately there is no automated way to sync your form's submission to your excel file. Though you can integarte your form with google spreadsheet but I am not sure if it will help you.
You will have to anyway manually copy the new submission data from your google spreadsheet / exported excel and copy it in your excel sheet which has formula. You can probably take a look at some 3rd party syncing software which will sync your google spreadsheet with your local excel file. Please take a look at one of the product here: http://www.funbutlearn.com/2013/12/introducing-sync-sheet-sync-ms-excel.html
Hope this helps.
Do get back to us if you have any questions.