How to Autofill Jotform Using Excel Easily 2026

Start from an existing form — in this walkthrough, a Product Order Form with Full Name and E-mail fields already laid out — and make sure you're on the BUILD tab rather than Settings or Publish. The Add Element control sits in the top-left corner of the canvas; that's the entry point for adding any new field or widget, including the one that handles autofill.

Clicking Add Element opens the Form Elements panel, split into Basic, Payments, and Widgets tabs. Switch to Widgets and type into the search box — searching "spread" surfaces Spreadsheet, Spreadsheet to Form, and Rss Reader as matches. Spreadsheet to Form is the one built specifically for this use case: it reads an uploaded file and uses it to populate other fields on the same form based on a lookup value.

Before uploading anything, structure your spreadsheet so one column holds a unique identifier per row — an order number, a customer ID, a code you've already issued — since this is what a user will type in to trigger the lookup. Every other column becomes a candidate for autofilling a form field: name, address, phone number, order details, whatever your form needs pre-populated. A spreadsheet without a clean, unique key column won't map reliably, so get this structure right before uploading.

Clicking Spreadsheet to Form from the search results drops it onto your form canvas and opens its configuration panel. From there you upload the prepared .xlsx file directly — the widget reads the column headers from the file so you can reference them in the next step. Keep the file's header row clean and consistent, since those exact header labels are what you'll be mapping shortly.

In the widget's settings, designate which uploaded column is the access code — the lookup key — and then map the remaining spreadsheet columns to the corresponding fields already on your form, like matching an "Email" column header to the form's E-mail field. This mapping step is what actually connects a spreadsheet row to specific inputs on the page; get a mapping wrong and that field will either populate with the wrong data or stay empty.

The widget adds a front-end input box where users type their access code, along with a verification button — both are customizable, so you can adjust the label text and button styling to match your form's design rather than leaving Jotform's defaults. Once configured, preview the form and test the flow end to end: enter a code from your spreadsheet and confirm every mapped field populates correctly, then repeat the check on a mobile viewport, since form layouts often behave differently at narrow widths.