How to Add Google Sheets to Google Slides
The steps to link Google Sheets and Google Slides are easy to follow.
Link to a Range of Data
Follow these steps if you need specific rows and columns to show up in Slides as a table.
Link to a Chart
You can link to a chart the same way you can cells of data, by copying and pasting. But there’s another method that lets you do all of it from within Google Slides. Use the edges of the table to move it wherever you need it to be. You can even cut/paste the table to another slide if necessary, and it’ll still be linked to the same spreadsheet.
Editing a Linked Spreadsheet in Google Slides
If you make changes to the data, the table’s menu in Slides changes to an UPDATE button that you need to click to make changes show up in the slide (refresh Slides if you don’t see that button). The spreadsheet data in Google Slides might look editable (and some of it technically is), but instead of changing the data right there in the slideshow, revisit the spreadsheet and make your edits there. It’s easy to do this: just click the table or chart once to reveal a small menu at the top. Select that, and then choose Open source to open Google Sheets. If it’s a table you’re dealing with, also in that menu is the self-explanatory option to Change range. This is where you can edit how much of the spreadsheet shows up in Slides, without needing to erase the import and start over from scratch.
Benefits of Putting a Google Spreadsheet in Google Slides
Importing spreadsheet data into a slideshow eliminates the need for you to copy all that information over manually. Also, since Slides does a great job at formatting it, you don’t even have to make the table or chart yourself; it’s all done automatically in seconds, and looks just like it does in Sheets. Since spreadsheets created in Google Sheets live online, updating what you see in the slideshow is as easy as updating the spreadsheet. When you link this kind of document, any changes you make are reflected everywhere else it’s accessed from, including your Slides files. This means you can still benefit from the structured format, the helpful formulas, etc., that’s provided by Sheets, even though it’s being accessed in your slideshow. This integration is useful even if you don’t want to share the Sheets file. For example, you can share the slideshow with someone without sharing the spreadsheet; only the portion of the file that you copied (e.g., the chart) is visible by whoever views the presentation.
