How To Insert Google Sheets Into Google Slides

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.

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.