In this tutorial, you will learn how to insert google sheets into google slides.
Google Sheets is a great tool for aggregating data and performing calculations, but it’s not designed for use in giving presentations. However, that doesn’t mean you can’t use live Google Sheets data in a presentation. By inserting a link to Google Sheets data into a Google Slides presentation, you can create a presentation with data that can be easily updated with a single click whenever the source data updates. Read on to learn more.
Quick Navigation
Inserting the Data
When setting up your data in Google Sheets to be inserted into Google Slides, note that not only the data will come through, but also the formatting, so be sure to consider fill and text colors, borders, fonts, etc. Don’t worry if you’re not sure what you need now, you can always update it later.
Step 1
Open the Google Sheets file you want to insert into Slides and select the range to insert. Keep in mind that Slides don’t scroll, so you may need to pare down your data to ensure it is legible
Step 2
Hit CTRL+C on Windows or CMD+C on Mac to copy the spreadsheet data
Step 3
Open the Slides file you want to insert into and find the slide to insert on, then hit CTRL+V on Windows or CMD+V on Mac to paste the spreadsheet data
Step 4
A popup will appear asking if you want to paste the data linked or unlinked. If you paste it linked, changes in the spreadsheet will carry over to the Slides file. This is the option we’ll use for this tutorial, so check Link to Spreadsheet and click Paste
Step 5
The table will be inserted. Drag and drop to reposition it as needed. You can also resize it using the small drag handles in the corners of the table
Updating the Data
The data in the Slides presentation is linked, but won’t update automatically. Here’s how to make it update
Step 1
The option to update is only available if you make changes in Google Sheets. These changes can be data changes or formatting changes
Step 2
After editing the spreadsheet, click on the table in Slides and an Update button will appear at the top of it
Step 3
Click on Update to update the Google Sheets data
Summary
Example Spreadsheet: Make a copy of the example spreadsheet, and example presentation
In this tutorial, I covered how to insert google sheets into google slides. Want more? Check out all the Google Sheets Tutorials.