Can I import an existing spreadsheet into JotForm?

  • mstand
    Asked on October 6, 2016 at 4:45 PM

    We have a department contacts directory. I want to create a form so that employees can update their own information, but I want to be able to upload the information we already have entered into a spreadsheet. Is that possible?

  • sercanseco
    Replied on October 6, 2016 at 6:00 PM

    hi there,

     

    you can use Import Data application for importing spreadsheet data to your forms. But as mentioned in this thread, the formatting of the to be imported spreadsheet must be in accordance with the formatting of your form's spreadsheet data.

  • Support_Management Jotform Support
    Replied on October 6, 2016 at 10:10 PM

    I'm not sure I properly understood what you're trying to achieve.

    You said "I want to create a form so that employees can update their own information, but I want to be able to upload the information we already have entered into a spreadsheet"

    When respondents (in your case, your employees) fill out a form, each submission they do will be a new record/submission in your account.

    If what you're aiming to do is have all your existing data (from a spreadsheet) to be imported to your JotForm Submission data, then have your employees update those, then try the Import App to import your spreadsheet.

    We have a very detailed guide on how to use this app: Import-App-Easily-import-your-Excel-or-CSV-data-into-JotForm

    I highly recommend you take your time reviewing the guide above, specifically step #5, where you have to check the formatting needed for the column headers.