Can I utilize a JotForm to enter data that will be stored in Excel?

  • Tim Rose
    Asked on October 17, 2018 at 7:47 PM

    If you say that there is a way we can do this, you are a life saver! Excel makes it very difficult to create data entry forms that user can tab to each data field to enter a value then tab to the next field to enter other value- all of these values being mapped to specific cells in an Excel worksheet.

    Can I accomplish this using a custom created JotForm? 

  • Mike
    Replied on October 17, 2018 at 10:44 PM

    Thank you for contacting us.

    The form entries will be stored in your JotForm account.

    The data can be accessed and managed via form submissions page. Here is an example:

    Can I utilize a JotForm to enter data that will be stored in Excel?  Image 1 Screenshot 20

    We are also working on a new spreadsheet-like submissions page format.

    From the form submissions page, the data can be downloaded in the Excel/CSV/PDF format:

    How to Download Form Submissions as Excel/CSV/PDF

    We also support a Google Sheets integration. The form data can be automatically forwarded to your Google Spreadsheet.

    How to Integrate Forms with Google Sheets

    However, you will not be able to individually map the fields. The columns are being generated automatically based on the form fields.

    If you have any follow up questions, please let us know.