- TaniaAsked 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.
- JotForm Supportashwin_dAnswered on May 07, 2014 at 12:51 PM
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.