In this article:

Embed Google Sheets in Website (Easiest Way in 2025)

January 13, 2025

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.

Turn PDFs into spreadsheet tables with AI

Use Lido to extract data from contracts, invoices, financials, and more in seconds. Save time, reduce errors.
  • No credit card required
  • 20 free pages