How can export my forms to an excel sheet using API?

  • ctrevizo
    Asked on November 17, 2016 at 2:31 PM

    Hello,

     

     

    We currently have an account with Jotform and have many forms we utilize.  One of those forms, Gemini Timesheet, is critical since this is the form our field employees use to log their time.  I want to be able to use API to retrieve all submission details without having to log on to jotform and I want to be able to use this via excel (Power Query).  Is there an easy way to retrieve this information via excel?  My goal is use Power Query to get all timesheets data/info using the proper parameters.  I’m new to Power Query and API keys but trying to learn as much as I can as I go.  Any info will help, thank you.

  • Jan
    Replied on November 17, 2016 at 4:11 PM

    You may check our API documentation if you want to connect the form submissions to Excel via API. Here's the link: http://api.jotform.com/docs/.

    You may also contact our API team at api@jotform.com.

    Hope that helps. Thank you.