How can I automate importing submission data to a table then exporting the table to Excel

  • Profile Image
    Asked on October 27, 2020 at 11:23 AM

    I'd like to automate a process using Windows scheduler that periodically imports recent submission data to a table, then exports the table to Excel, and repeats this process with any new submissions that were input after the last import to table. Is this possible?

  • Profile Image
    Answered on October 27, 2020 at 12:44 PM

    It is possible to import data to the JotForm Tables. Please check the following guide:

    How to Import Data in JotForm Tables

    When you import submissions, you can then download them as Excel.

    How to Download Form Submissions as Excel/CSV/PDF

    It is not possible to import more submissions to the table with imported data, but you can manually add new entries or import the new data to another table.