Can I import an existing spreadsheet into JotForm?

  • Profile Image
    mstand
    Asked on October 06, 2016 at 04: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?

  • Profile Image
    sercanseco
    Answered on October 06, 2016 at 06: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.

  • Profile Image
    Jim_R
    Answered on October 06, 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.