Do you have a Google sheet that you would like to to publish on your club website? The easiest way to embed a Google Sheet on a website is using the Publish to the web feature inside Google Spreadsheets. This tutorial will go over the following:
How to make your Google Sheets public & get embed code
- Open a file in Google Docs, Sheets, or Slides.
- Once your sheet is formatted appropriately, select File from the menu – Share – Select Publish to the web.
- In the window that appears, click Embed & Choose a publishing option:
- Entire Document: Choose to publish the entire Documents, all tabs.
- Specific Tab: Only choose to publish one tab of the document
- Click Publish.
- Copy the HTML in the text box. You will need this to paste into your website.
How to add a Google Sheet’s Embed code to your site
- If you have not yet opened the page/news post you would like to add the Google Sheet to, go ahead and Edit the page by clicking on “Edit with Elementor”
- On the next page, scroll down the widget panel until you see the category ‘General‘ – click the arrow to expand
- Drag either the HTML** widget or Shortcode widget into the section and release.
**HTML widget is preferred - Paste the Embed code you copied from your Google Sheets. You should now see the google sheets on your website.
See Pro Tip below to adjust size of Google Sheets
Don’t forget to click Update / Publish when you are finished.
Pro Tip: As you may have noticed, the Google Sheets may not have the correct dimensions. Here is some code to add to your HTML Widget / iFrame to correct this.
- Please copy entire code below
style="height:500px;width:1100px"
2. Go back to your HTML Widget and click on the handle to edit the iframe code.
3. At the very end of the last quotation marks, paste in the code you copied above.
- You can adjust the height by increasing / decreasing the height pixels
- Width can also be adjusted. Please note that the width might automatically adjust for phones/tablets.
