sheet2api logo Sign in

How to Embed Google Sheet Spreadsheet on a Website

Embed Google Sheet IFrame into a web page. No coding required.

There are a number of reasons you may want to embed a Google Sheet spreadsheet onto a webpage. For example, if you wish to share some statistics on your personal or company blog so that people outside your organisation can view your data without directly going to the Google Sheet spreadsheet.

In this short tutorial we'll cover how to embed a Google Sheet spreadsheet in any web page using sheet2api, no coding required.

1. Prepare your Spreadsheet

For the Spreadsheet you're going to connect to sheet2api, the first row (1) must only contain column names.
All the other rows may contain data, in whatever format you'd like (symbols, numbers, dates, words, etc).

For example:

A B C D E
1 Name Favourite Thing Image
2 Bugs Bunny Carrots Bugs.png
3 Elmer Fudd Chasing Rabbits Elmer.png
4
Looney Tunes
The Simpsons
Sheet3

You may add multiple worksheets such as 'Looney Tunes', 'The Simpsons' to seperate different categories of data.
sheet2api will create an API endpoint for each of these automatically.

2. Create Spreadsheet API

Head over to sheet2api and Create your Spreadsheet API by pasting your Share Link from the previous step into the form.

Create REST API from a Google or Excel Sheet

Click Create 🚀. Your new Spreadsheet API should be listed on the next page.

Your Spreadsheet APIs list in account

Great, that's the hard work done, on to the final step.

3. Copy the HTML snippet into your webpage

Click the "Embeddable Table" button on your Spreadsheet API. This will display a HTML snippet for embedding your spreadsheet.

Simply copy that HTML into your web page and you will see the live spreadsheet displayed. When your spreadsheet is updated, so will the spreadsheet embedded on your web page!

Snippet to embed Google Sheet onto a web page


It's as easy as that 🎉.

If you need help, please feel free to send a message via the contact page.

Start using sheet2api now

Be up & running in seconds.