JotForm User Guide / Advanced Features /

How to Use the Spreadsheet to Form Widget

How to Use the Spreadsheet to Form Widget

Are you hoping to populate your form fields from an external Excel Sheet? Perhaps you wanted to pull existing records and display them on your form? If so, your long wait is over. Meet the new Spreadsheet to Form Widget.

The Spreadsheet to Form Widget allows you to upload a spreadsheet to your form and use the values you have on the spreadsheet to pre-populate the form. By using a unique code present on each row of your spreadsheet, you can access that specific row when it matches the unique code entered on the form. Think of it as querying a database using the Unique Code as the key index.

Before we proceed, here are some limitations and key points you should be aware of:

1. The widget requires an .xls, .xlsx, or even a .csv file and it won't accept any other format.

2. The Unique Code on your sheet doesn't necessarily need to be on the 1st column. You can place it anywhere for as long as you configure the widget with the respective column index (more on this later).

3. The Unique Code is case-sensitive.

4. The Column Names on your sheet should match the Field Labels on your form.

For example, if your form fields were labeled like this:

Then, the column names on your sheet should be labeled exactly the same.

Fullname > Email > Time > Short Text Entry > Long Text Entry > Dropdown > Single Choice > Multiple Choice > Star Rating > Scale Rating

5. The arrangement of the form fields on your form won't matter even if you have other fields in between. What's important is to ensure that the Field Labels and Column Names match.

6. The Widget only supports the following fields:

🔘 Full Name

🔘 Email

🔘 Time

🔘 Short Text Entry (Textbox)

🔘 Long Text Entry (Textarea)

🔘 Dropdown

🔘 Single Choice (Radio Button)

🔘 Multiple Choice (Checkbox)

🔘 Scale Rating

🔘 Star Rating

(all other fields not mentioned on the list above will not work with the widget)

7. When the Unique Code is correct, the values inside the fields to be populated will be cleared and replaced by the values fetched from the spreadsheet.

If everything above looks good, let's get on with it!

Step 1 - Prepare your Spreadsheet and Form.

Step 2 - Add the widget to your form.

Step 3 - Upload the spreadsheet you'll use.

NOTE: The bigger the file, the longer it will take for the data to load on the form.

Step 4 - Setup the other options on the widget.

Access Code Column

The Unique Code column index. This will help identify each data row you want to appear on the form. Say, your Unique Codes are placed on Column K in Excel, then you type in K on this section.

Labels Row

The column labels row number. This will identify each column label and fill in the exact question label from your form. Same idea applies if your column labels are on Row 1, then type in 1 on this section.

The other options, Fill Button Text and Loading Message, are relatively straight forward.

To test it out, here's a demo form:

And here's a screenshot of the actual data within the spreadsheet used for this form:

If you want to use this same spreadsheet to do your own tests, feel free to download it from this link.

Questions? Don't hesitate to post them in our Support Forum.

Contact Support:
Our customer support team is available 24/7 and our average response time is between one to two hours.
Our team can be contacted via:
Contact JotForm Support:

Send Comment


See all comments
  • InfiniteEye

    Great tool!! I'm a new user and having some trouble.
    Maybe I'm not familiar enough with the program yet. But, can I have multiple unique codes for a single row? If the unique code is an email address and that is associated with data, can the program look at more than 1 field for the unique code and bring up the associated data?

  • pollinatorpartnership

    Thanks! This tool is great.

    Do you know when it will be able to take number and address fields?

  • Ssarav01

    How do you use this if your form has translations?

  • robertmk20


    This is an awesome feature - can this feature be used offline as well?


  • waynelaidlaw

    How can I fix the numbers to show only 2 decimal points in the spreadsheet to form.
    The spreadsheet number is .67 but it shows .67155898999 (for example)
    I have toggles the limt entry characters on but that did not work
    I have limited the characters to 4 and that still did not work.
    Also can you use this in a table format?
    Thanks in advance

  • foegler

    Hello, this feature could bring a lot of value to me.

    Is there a way, using the Multiple Choice (Checkbox), to pass along a value through the "Other" option? So a value that is not predefined?


  • JDog84

    I have tried to use this widget and I select the unique key. It says "Fields Have Been Auto Filled" but I check the fields that are labeled with the column headers and nothing shows up. Did I miss a step in the setup?

    Form address is

  • bfackrell

    This is pretty cool but, is there a way to open an excel file from within the live form to populate the data?

    I don't want to have to go back into the form design and upload a new Excel file each time. May data will be different each time I use the form.

  • Western_Shield

    HI, Just wondering how I can use a spreadsheet to populate a field based on an answer to a previous field. For example species of animal have a common name and a scientific name. I have created a dropdown list of common names but I want the jotform to look at that name and then select the appropriate scientific name from the excel spreadsheet and insert that into a another field. There are over 100 names so I didn't want to create a conditional logic for each option.

    my form is:


    Can we use a Google or Jotform Spreadsheet instead of file upload.

  • PESJotForm

    How do you make a pulldown field populate the speadsheet to form field? I saw one thread on the update/calculate field but cannnot find this function.

    Thank you.

  • Jackson_Matt

    Hi. How can we do this using google sheets instead of Excel?

  • Teiyonab

    Hello, I'm currently using the Spreadsheet to form widget. I keep receiving this error message, "There are errors on the form. Please fix them before continuing". Please assist.

  • essilorvisionfoundation

    Is it possible to point this at a spreadsheet that is hosted on the web or a Google Sheet so the file can be updated with new values?

  • Hasan

    What a great and amazing widget! Does this work also on conditional drop-downs?


    Are you registered with ASA?

    Yes / No

    No - nothing happens
    Yes - please input your ASA ID

    So can the ASA ID be pre-populated as well given that it is a field that only shows up on the conditional YES answer.


  • ifec

    works great!

    Is there a way to not have to type in the unique code and then hit the button for auto complete and use a drop down menu to select the unique code?

  • taxi88test

    Hi, we are geting the "Unknown Column Key" error now, November 18, 2019. I have over 52K submissions in this form, i need it desperately to continue functioning!
    Oh, and it doesn't even work on YOUR OWN DEMO

  • ISCAForms

    Have the same issue as several here. As of this morning - we are getting "Unknown Column Key" errors. NO CHANGES have been made to the form or the spreadsheet! Been a rocky road the last few weeks with this widget.

  • whitefieldgujarati

    Our forms where working fine suddenly we are getting "Unknown column key" error message, please debug the same at earliest and let us know the resolution.

    Thank you

  • walkersl

    I have the exact same problem as freshii below. Everything was working fine this morning, and now it just gives me the unknown access code error.

  • freshii

    Hi I am receiving an error "Unknown access code". I have been using my spreadsheet for 6 months and it just broke! I need to get this fixed ASAP, can you look into it?


  • trav80

    I cant get the Spreadsheet to form widget to work.
    I have been using the for over 6 months with not much hassle and now cannot get it to auto fill my form.
    This is a hugely important form in our business

  • tallerservimanpa

    No work

  • workadvisor

    I do not understand. Until today the form worked perfectly and suddenly it doesn't work.
    I have not changed anything.
    The form no longer recognizes field data of the Access code column.
    Do you have an explanation please?
    It's very important because I use this form every day at work...
    Thanks !

  • Stefano

    Hi, it all seems very nice but basically I didn't understand a fundamental thing;
    a data base (excel) is composed principally of numbers (prices), in an order form (or product configurator with prices) how can I associate the choice (eg. check box) that the customer makes ONLY to the price that is in the excel file? This should be the first reason for wanting to integrate a database.

  • tallerservimanpa

    Can I access a list with several names of the same unique code and show all option of this selecction? For example:
    COUNTRY Province Population
    Country1 Pma 17782
    Country1 Mpa 52773
    Country2 Jty 57893
    Country2 Gtw 92934
    If select Country2 show:
    COUNTRY Province Population
    Country2 Jty 57893
    Country2 Gtw 92934

  • GoofyCoolGO

    Previously my Dates in the Excel file uploaded to this widget, was able to display the Dates into a Short Text Field as text as seen in my Excel file,
    But seems recently the widget now only shows the Date as serial numbers instead of Date format as in Excel.
    Is there a way to have the widget display in Date format as per Excel?
    my test form: Text Excel

  • mayeongyahoo

    Fantastic! It's worked exactly the way I wanted.
    Thank you so much!!!

  • BAZIN11

    I have an error message : "server error",
    when i try to upload my .xlsx file...
    Thank you for your response.

  • remfranquias

    Is it possible to use this in the SINGLE QUESTION FORM format?

  • pakenhamlakers

    This would be great if the widget can look up a google sheet and also have the Date field added. I have a registration form that users complete 2 times a year and if they were able to use a unique ID to pre populate the details it would be fantastic, just need the date field added and the Number field added.

    can this be done?

  • jean.minks

    How do you stop the cannot find access code error message for rows added to the spreadsheet? I saved the spreadsheet for changes and waited, but the only way I've been able to get the widget to recognize a new row on the spreadsheet is to upload the spreadsheet again. Thank you.

  • flatratecontemporary

    literally can't get this to work. can you send an individualized (personalized) contract to each member of an email list that automatically populates with

  • funside

    Absolutely brilliant! Thank you!

  • info5058

    After my first reading of this, I don't yet understand what this is for. A video would be helpful.

  • aensharjah

    Can't we have dynamic checkbox? I have a requirement where there is a list of family members for a particular Unique Code and checkbox should get populated with that list. Is this possible?

  • brij.agrwl


    If I make field as required, it does not pull the information, but same filed if is not required (optional), then it pulls information.

    Try value 1 in unique to pull value.

  • brij.agrwl

    My form is able to pull information when in single page mode, but one question per page mode its not pulling information. Please advise.

  • JulieannPersonal

    Please import numbers

    This is wonderful, I'm so excited to use it. My first use case includes fields that have digits. I saw the list of accepted fields, and "number" isn't one of them.

    Is this still true? Or if I've missed something please let me know where to find special instructions for importing numbers.

    Thank you!

  • nituema

    1st - I am having problems with the extension "Spreadsheet to form":
    the data is not updated in PREVIEW.
    2º- When using "UNIQUEID" column "AO" returns the following error:
    -Internal error: Access code column must point to a single cell only.
    NOTE: The values are not the same.

  • christophschemel

    I have just posted this here, but it might be better placed here.

    There is a problem, as it is not possible to use dropdown or (forced) autocomplete, so the user has to know beforehand, what to write exactly and how to spell this - which is not practically possible.

    I have implemented your linked solution using a pagebreak ( ), and it works fine if done in one process. In my case, it does not seem to work though:

    I attached an "edit-form" link to my autoresponder, so the client can update his form submission. If he does though, your two-page soltution does not work, the field does not get prepulatedt. Any solution or workaround? That would be so important. Actually, this is already a workaround, what really would be needes is the combination of the autocomplete-functionality (or also the dropdown-functionalitiy) and the spreadsheet to form widget!


  • Sebastian

    Cool widget, but it would be much more useful if it could fetch the data from an online Google Spreadsheet, and configure the lookup function on endless columns. That way the data source could be updated constantly without having to upload new files... do you plan to add a functionality like this anytime soon?

  • gptqmarketing

    I have a small question on this. Instead of using an excel spreadsheet that needs to be uploaded each time, can we get the widget to look up data that sits at the backend of this form itself? I'm trying to get my form to identify someone who has revisited us, greet them by name and prepopulate their details in it.

  • NewPerspectivesTravel

    Is there an answer to tutuprat and ViaInsideSales' questions? I want to do the same thing and have a pre-populated (drop-down) instead of text question.

  • tutuprat

    Same as last question, any way to make it as a dropdown instead of a text field?
    Also, will this widget populate hidden fields? I want to have several answers on the final submission but I want the end user to only see a few.


  • ViaInsideSales

    How can I include the number option and the input table, to get populated with spreadsheet to Form Widget?, or is there another option to get pre populated?

  • ViaInsideSales

    I have the option multiple choice, but is not working, how has to be displaid in the excell cell?
    example of data in a cell:



  • txforesttrail

    This is really cool!
    Can you suggest an easy way to prevent errors from users entering the unique code incorrectly (typos). For example, would it be possible to populate the input field for the unique code with a user's previous selection from a dropdown?

  • YoungsIncentive

    Is it only possible to have one Unique Code input field per form? I can get this to work great, but need the ability to add multiple fields and have unique information pull for each. When I add a second Spreadsheet to Form Widget, and enter the next Unique Code, it updates all fields, even those for the previous entry.

    I'm trying to create a form where the user inputs an item number and then the description, pricing and details for each is auto populated. Need to be able to have multiple entries, 10 - 20 items per form.


  • AnkeetModi

    i tried testing the data but i get the error "undefined"

    what does that mean?