Can I automatically update an excel sheet when submissions are made

  • Profile Image
    cris74
    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
    Chriistian
    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.
    Regards.

  • Profile Image
    cris74
    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
    david
    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:

    https://www.jotform.com/blog/221-Connect-Your-Forms-to-Excel-with-Zapier

    This does require a Microsoft OneDrive Business account.