JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Can I automatically update an excel sheet when submissions are madeAsked by cris74 on November 03, 2016 at 09:00 AM
When will you replace the manual process by an automatic data flow, as already exists for Google sheets?
This is a re-post of a comment on How to Create an Excel Report?
Can you please provide us more details regarding your concern? Currently, once you created an Excel Report, you will have a link where you can download the updated submission data of your form. What are you referring to with the manual process?
We will wait for your response.
I would have an Excel file updated in real time by new subscriptions. For now exploit the submissions, I have to sign on my JotForm space, select my form, click report, copy the file from the download directory: these manual operations are reliable but are not automatic.
However, by integrating "Google spreadsheets" Google sheets automatically updates all submissions to this form. I would like an Excel integration to do the same. Because the Google sheets can not be used by the VBA code of Excel workbook.
Though it is not possible to update the sheet directly via JotForm, this can be done through Zapier:
This does require a Microsoft OneDrive Business account.