How to Embed Spreadsheet in Your Form

Embedding a Google Spreadsheet or Jotform Table into your form is easy using the Iframe Embed widget. It lets you display live data directly in your form, making it ideal for sharing reference information, tracking progress, or showing submission summaries in real time.

There’s a helpful video at the end of this guide that walks you through the process.

Embedding a Spreadsheet Using the Iframe Embed Widget

Whether you’re creating a new form or updating an existing one, embedding a spreadsheet into your form using the Iframe Embed widget only takes a second—here’s how to get going:

1. In Form Builder, click on Add Element on the left side of the page.

2. Now, in the Form Elements menu, under the Widgets tab, search for the Iframe Embed widget and click on it. Or, just drag and then drop it to where you want the spreadsheet displayed on your form.

3. Next, in the Widget Settings window that opens on the right side of the page, under the General tab, complete these fields:
   • Frame URL – Paste your public spreadsheet link here. Scroll down for the steps to get your spreadsheet’s public URL.
   • Transparent Frame – Choose whether to keep the frame transparent or stick with the default look.
4. Once you’re done, click on Update.

Getting the Public URL of the Spreadsheet

To embed your spreadsheet using the Iframe Embed widget, you’ll need to make it public first. Setting it up is quick—here’s how:

1. In your Google Spreadsheet file, at the top left of the page, click on File.
2. In the Dropdown menu that opens, click on Share.
3. Next, in the Sub-dropdown menu that opens on the left, click on Publish to Web.

4. Then, in the Publish to the Web window that comes up, under the Link tab, set things up like this:
   • Document to Share – Select whether to show the entire spreadsheet or just one worksheet.
   • Document Type – Select Web Page from the list of options.
5. Once you’re done, click on Publish.

6. Finally, in the URL box, copy the given URL and paste it into the Iframe Widget’s settings.

Want a quick preview? This Demo Form shows how it works.

Watch on youtube

How to embed a spreadsheet to a Jotform