Slide with table embedded into it

Embed a Live Google Spreadsheet into Google Slides

If you are using Google Slides to create a presentation with data from a Google Sheet, you may want to show that data as a linked table. If you create the table in Google Slides with no linking, it will not update if the data in the Google Sheet changes. Also, this is double work as the data is already in the Sheet, so re-typing it is a waste of time. Below are instructions on how to embed a live Google Sheet directly into your Google Slide. The table that is created will update with one-click and can be styled however you like. Live links to the Slide and Sheet shown in this tutorial are at the end of this article.

Delete the existing text box

Slides wants a blank area for the table. If you have a text box in your slide, delete it to make a nice, big open space.

Text box to be deleted
Text box to be deleted
Watch the video

Create the Sheet

You need a spreadsheet created in Google Sheets with the table of data that you want to display in your Google Slide. In your spreadsheet, highlight the range that you want, right-click, and select Copy.

Table to Copy
Table to be copied

Paste it into your Slide

Then, go to the location in your Google Slides where you would like the table to be inserted. Right-click with your mouse and choose Paste. After clikcing, a window will pop-up asking you if you want to Link to spreadsheet or Paste unlinked. Choose Link to spreadsheet and click Paste.

Table to Link
Choose Link to spreadsheet

Oh yes, that’s a live, linked table that you’re seeing.

Slide with table embedded into it
Google Slide with embedded Sheet

Working with your embedded table

Updating the embedded table

After linking the table, if you want to change the data within the table, you can go back to the Google Sheet to make the changes. When you come back to the Google Slide after making the changes, there will be a new option available to update the table when you right click on the table as shown in the picture below.

No update option showing
Update option showing

Adding rows

If you add rows to your table in Sheets, you may notice that the added rows don’t show up in the linked table in Slides. You will need to go back to the table in Slides after making the change, left click the more button (three vertical dots), and choose Change range.

Change range option
Option to change the range


Following the steps above should provide you with an easy way to insert a live, linked spreadsheet into your Google Slides. Enjoy!

Live Google Slide with an embedded Sheet

Live Google Sheet that is being embedded

0 thoughts on “Embed a Live Google Spreadsheet into Google Slides

  • Caroline Rice says:

    Any idea why I do not get the “link to spreadsheet” option? I am in Chrome and selecting multiple cells but less than 20 rows like other common issues mentioned. I simply don’t get any option to link to a spreadsheet when pasting into google slides.

    • It should, but I haven’t tried it. I saw something recently that the refresh of these tables could become automatic in Google Docs and Slides too. However, you’d need to make sure you had the range correct. If you got enough responses from your form, they would run off of the area that you copy and pasted.

  • I have range of data that I have copied from Google Sheets and linked in Slides. When I click on “Update” it now shows my hidden rows. Is there anyway to prevent this from happening?

  • This is awesome and so helpful! Another question–is there a way to have the google slide automatically update without having to click “update”? I would like to have someone be able to EDIT the text in a spreadsheet, but I would only like them to be able to VIEW the slide. Thanks!

    • I think there an update announced by Google automatic updating will be coming soon but I don’t remember the details. Lots of people have asked this.

  • Once I paste the spreadsheet is very large and I can resize the width but not the height. How can I adjust size to fit on the slide? Tried the Format options but it is locking the width/length aspect ratio not allowing me to reduce height without equal reduction to width.

    • Prolific Oaktree says:

      Try modifying the size in shape in Sheets instead of Docs. I would think you could change the width and height independently in Sheets.

  • I have linked a live Sheets range to my Slides but there are check boxes on the Sheets that I need but they do not display in Slides. Do you have any thoughts on how to correct that?

    • Prolific Oaktree says:

      I’m not surprised they don’t come through right. They’re a relatively new addition to Sheets and the linking is a little basic. If they’re not going to change, you could use images of checkmarks and see if those come through. Kind of a hacky solution though.

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>