This tutorial will demonstrate how to embed Excel or Google Sheets tables into HTML.
Saving an Excel File as an HTML File
1. With the workbook that you wish to save as an HTML file open in Excel, in the Ribbon, select File > Save As.
2. From the dropdown list below the file name, select Web Page (*.htm, *.html) and then click Save.
3. The file will then be saved as an HTML file. Switch to the Windows Explorer to view the HTML file.
4. Double-click on the HTML file to open it in the default browser.
Embed Excel Sheet With Office Live
Excel on Office Live can be more flexible, as it creates a link.
1. Log onto Office 365 in the browser with Office Live and select the Excel Icon.
2. Select New blank workbook to create a new workbook.
3. Fill in the worksheet as required, and then, in the Ribbon, select File > Share >Embed.
4. Click Generate to generate the HTML code.
5. In the Ribbon, click once again File > Share >Embed.
How to Embed Google Sheets Tables into HTML
Once you’ve created a Google Sheets file, you can publish it to the web and share the sheet with multiple users by sending the users a link to the sheet itself.
1. In the File menu, select Publish to the web.
2. Select from either Link or Embed.
3. Select either the Entire Document, or the sheet required.
4. Click Publish.
You can now send the generated link to any users you want to open the file on the web.
5. To remove the file from the web, select Published content and settings > Stop publishing.
6. Click OK on the Google message that pops up to remove the document from the web.
NOTE: If we had selected Embed, HTML code would have been generated that we could have included in our own web site or blog, this HTML code would then embed the Google Sheets data into our website.