How to copy/paste values to Excel sheet in the Form?

  • Bettermailingnow
    Asked on March 3, 2019 at 3:44 PM
    Is there something with cells that form fillers can paste multiple values in? Cells would be ideal because we want to have column headers such as attached. We’re in need of the ability to have column headers and allow form fillers to fill in their information under each column by pasting excel values directly in (instead of having to type them).
     
    Background on this is we need a way for someone to fill out the form for multiple people and provide lots of data without having to type in fields individually. So we want them to be able to take any excel spreadsheets they have, copy their data and paste it directly into any table/grid/spreadsheet you offer that we’ve already labeled with column headers so the data can be organized.
     
    See example attached.
    Jotform Thread 1749174 Screenshot
  • roneet
    Replied on March 3, 2019 at 11:01 PM

    You can embed Google spreadsheet in your form, here is how:

    1) Insert iFrame embed widget to your form:

    How to copy/paste values to Excel sheet in the Form? Image 1 Screenshot 40


    2) Open your Spreadsheet and take the iFrame URL from it:

    How to copy/paste values to Excel sheet in the Form? Image 2 Screenshot 51

    3) When you copy the URL to your iFrame widget the sheet will show in the form:

    How to copy/paste values to Excel sheet in the Form? Image 3 Screenshot 62

    Please try and let us know if you have any further questions.

    Thank you!

  • Bettermailingnow
    Replied on March 4, 2019 at 11:43 PM
    Thanks for that!
    ...