How can I update an Excel file automatically every time a new submission is received?

  • Profile Image
    Anastacia 
    Asked on March 20, 2015 at 03:53 AM

    Hello!

    How to make the exported Excel file is automatically updated upon receipt of a new application form on the website?

    Thanks

  • Profile Image
    raul
    Answered on March 20, 2015 at 10:39 AM

    I'm not quite sure if I understand your question correctly.

    When you export your submissions to Excel, the file will always contain the most updated information once is generated. Or, you can also create an Excel report to download the submissions to Excel in a quicker way (direct link).

    Let us know if this answers your question.
    Thanks.

  • Profile Image
    Anastacia
    Answered on March 20, 2015 at 11:02 AM

    Sorry for my English, is not my native language. 
    I mean, I need the auto-export to Excel document, not manually export.
    Without clicking the button "download excel report". 
    If I have a new submission, my Excel document ON MY SERVER (not on jotform.com) automatically updates the data

    Thank you

  • Profile Image
    raul
    Answered on March 20, 2015 at 12:25 PM

    Oh sorry, my apologies for not getting it the first time.

    We support the integration with Google Spreadsheet which is automatically updated every time a submission is made. If this wouldn't be a viable solution for you, it's also possible to capture your submissions in your own database and then use it as the data source of your Excel file.

    Hope this helps.

    If you need further assistance, please let us know. We'll be happy to help.