There are a number of reasons you may want to embed a Excel Online 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 Excel Online spreadsheet.
In this short tutorial we'll cover how to embed a Excel Online spreadsheet in any web page using sheet2api, no coding required.
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 |
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.
Create your Spreadsheet API using the link to your spreadsheet.
After clicking "Create", your new Spreadsheet API will be listed on the next page.
Great, that's the hard work done, on to the final step.
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!
It's as easy as that 🎉.
If you need help, please feel free to send a message via the contact page.