URL address of a table FROM JOTFORM and enter in Excel DATA FROM WEB

  • Profile Image
    ipponjt
    Asked on April 29, 2022 at 12:10 PM
     f you copy the URL address of a table FROM JOTFORM and enter in Excel DATA FROM WEB can it be updated automatically when there are new registrants?


  • Profile Image
    Fahad
    Answered on April 29, 2022 at 01:55 PM

    Hi Michael,

    Unfortunately it would not updated automatically when there would be new submissions added you need to import the Jotform table again with new submissions to Excel Data import.

    There's a workaround for this. You first will need to integrate your form with Google Sheets. Then we can make it Excel get and copy the Google Sheets data. You can check guide How to Integrate Forms with Google Sheets. With this Google sheet integration each time new submissions added to Jotform it will be added to google sheet.

    Then you can link the Google sheet to you excel using excel Data import using the new web query "From Web".

    I hope it helps, If you further questions feel free to contact us again.