How To Embed Spreadsheet in Your Form?

September 3, 2022

Embedding a Google Spreadsheet file or a Jotform Tables is possible using the Iframe Embed widget. All you have to do is ensure that the file you’re going to embed is publicly available for viewing. Please watch the following video or read below for the steps.

Getting the URL of the Spreadsheet

The first thing you should do is get the URL of the spreadsheet and make sure it is public. To do that:

  1. In your Google Spreadsheet URL, click the File option.
  2. Click Share from the options.
  3. Select which share option you’d like to configure. Let’s assume you select Share with others.
google-spreadsheet-share
  1. In the General access dropdown, choose Anyone with the link.
  2. Click the Copy Link button.
google-spreadsheet-copy-link-button

You’re now ready to embed the spreadsheet.

If you want to embed your Jotform Tables, follow the steps from this guide instead: How to Share Your Jotform Tables and Collaborate. Share the Jotform Tables as public.

Embedding Spreadsheet Using Iframe Embed Widget

Now that you have the spreadsheet URL, let’s embed it using the iframe embed widget. Here are the steps:

  1. In the Form Builder, click the Add Form Element button.
  2. Click the Widgets tab.
  3. Search for Iframe Embed, and click it to add.
jotform-widgets-iframe-embed
  1. Paste your Spreadsheet URL to the Frame URL box on the Iframe Widget Settings.
  2. Finally, click the Update Widget button. You will automatically see the spreadsheet embedded in the form.
jotform-widgets-iframe-settings

Note

The widget will not display the whole width of the spreadsheet file. Consider adjusting your form width if you want to see most parts of the embedded spreadsheet. For more information, see The Importance of Form Widths.

Here’s a demo form you can check with the embedded spreadsheet: https://www.jotform.com/222438681301047.

Was this guide helpful?
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:

Support Forum: https://www.jotform.com/answers/

Contact Jotform Support: https://www.jotform.com/contact/

Send Comment:

Jotform Avatar
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Comments:

  • MistyJassey
  • AZDBAdesze