Can I automatically update an excel sheet when submissions are made

  • Profile Image
    Asked 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

  • Profile Image
    Answered on November 03, 2016 at 11:18 AM

    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.

  • Profile Image
    Answered on November 03, 2016 at 12:40 PM

    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.

  • Profile Image
    Answered on November 03, 2016 at 02:13 PM

    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.