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.


  • Profile Image

    Can I automatically update an excel sheet when submissions are made

    Asked 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?

  • Profile Image
    JotForm Support

    Answered by Chriistian 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

    Answered by cris74 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
    JotForm Support

    Answered by david 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.