Embed Spreadsheet Data and Charts

Tutorial for Embedding a spreadsheet Data Table or Chart into a Blog Post
  • Open your Google Sheet
  • SHARE -> Publish as Web Page -> Select the sheet you wish to publish (like just the final data sheet)
  • Select the Auto Republish button

  • Get Link to Published data: change From web page to HTML to Embed in a Page 
  • Select the appropriate sheet (should default to the sheet you previously selected)
  • High-light and Copy the resulting code

  • Return to your Blog Post
    • Select the HTML tab -> Paste in the appropriate place (where you wish it to appear).

  • Options (Edit the HTML)
    • For a better fit in your Blog, consider altering the WIDTH=450 and a HEIGHT=1000 (experiment with this, depending on how tall you wish it).
Comments