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 I import an existing spreadsheet into JotForm?

    Asked by mstand 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?

    responses and can can i
  • Profile Image

    Answered by sercanseco 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
    JotForm Support

    Answered by Jim_R 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.