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

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

    Asked by ctrevizo on November 17, 2016 at 02: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.

    My Forms excel sheet how
  • Profile Image
    JotForm Support

    Answered by Jan on November 17, 2016 at 04: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.