In this article:

Embed Google Sheets in Website (Easiest Way in 2024)

May 8, 2024

How to Embed Google Sheets in a Website 

Follow the steps below to display Google Sheets data on a website. 

1. Access and Open the Google Sheet You Want to Embed

First, you need to have the Google Sheet you want to embed. Open it in your browser. Ensure it contains the data you want to show on your website.

embed google sheets in website

2. Change Google Sheet Visibility to Public for Embedding

To view your Google Sheet on your website, it must be public. Click on "Share" in the top right corner.

Then, choose "Change to anyone with the link." This step is essential for embedding.

display google sheets data on website

3. Get the Embed Code from Google Sheets via Publish to Web

Now, get the embed code. Click "File" and "Share", then "Publish to the web."

Select the sheet and the "Embed" option. Click "Publish," and tick the box next to "Automatically republish when changes are made".

Copy the provided HTML code.

4. Open Your Website's HTML Editor and Insert Embed Code to Website

Go to your website where you want to embed the sheet. This might be a blog or a custom website. Open the HTML editor for the page or section for the embed. Paste the embed code you copied earlier. 

We hope that you now have a better understanding of how to embed Google Sheets in a website. If you enjoyed this article, you might also like our article on how to fix Google Sheets not syncing or our article on how to set up Google Sheets getDataRange.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->