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

    Can the data from forms be collated and transferred to a database?

    Asked by betteblance on March 29, 2015 at 06:58 PM

    We are a not for profit organisation and looking to have data collected from Jotform  automatically to a spreadsheet ?

    form to database database export excel
  • Profile Image
    JotForm Support

    Answered by EltonCris on March 30, 2015 at 02:08 AM

    Hi,

    Thank you for using Jotform.

    Here are 3 possible solutions.

    1. This is so far the easiest solution. All you have to do is to integrate your form to Google Spreadsheet. A copy of the submissions data will be automatically sent to the integrated Google Spreadsheet file.

    2. If you want to export your form submissions data to an Excel file format, I would recommend this method. Guide: http://www.jotform.com/help/73-How-to-Download-Form-Submissions-to-Excel-CSV-PDF

    3. This one is a bit advanced since it requires basic PHP knowledge. If you want to send every form submissions to your MySQL database, follow this guide: http://www.jotform.com/help/126-How-to-Insert-Update-Submissions-to-Your-MySQL-Database-Using-PHP

    Let us know if you need further help with any of these. Thank you!