Google Slides makes it easy to incorporate data from Google Sheets directly into your presentations. Embedding a live Google Sheet allows you to display up-to-date information and even let your audience interact with the data.
In this guide, you’ll learn multiple methods for integrating spreadsheets into Google Slides, including:
- Inserting a linked spreadsheet as a table
- Embedding a live editable Google Sheet
- Converting a Sheet to slides
- Exporting a Sheet as an image
Follow along with the step-by-step instructions below to seamlessly blend spreadsheets and slides.
Benefits of Embedding Google Sheets in Slides
Before we dig into the how-to, let’s look at a few reasons why you’d want to embed a Google Sheet in the first place:
- Display live data: Embedding a Sheet lets you showcase always up-to-date numbers, charts, tables, etc. No more manually updating static slides!
- Allow editing by your audience: You can choose to let viewers modify the linked Sheet as they view your Slides presentation. This makes your deck interactive.
- Refresh data on-demand: Even if you don’t permit editing, you can manually refresh the linked data in your presentation to pull in the latest from your Sheet.
- Avoid duplicate data entry: Rather than recreating info in Slides, embed your Sheet to seamlessly integrate existing data.
- Retain formatting: Charts, colors, and other formatting carry over when you embed from Sheets to Slides. Less work for you!
Now let’s look at the step-by-step process for linking Google Sheets into your presentations…
Method 1: Insert a Linked Spreadsheet as a Table
The fastest way to pull your Sheet data into a slide is by inserting it as a linked table. Just a few clicks creates a clean, well-formatted table populated with your Sheet contents.
Here’s how to insert a linked spreadsheet table into Google Slides:
- Open your Google Slides presentation and navigate to the slide where you want to embed the Sheet.
- Click Insert > Sheets Chart.
- Select the Google Sheet you want to link. If the sheet isn’t listed here, you likely don’t have edit access. Make sure the sheet is shared with your Google account.
- Choose the sheet tab within that spreadsheet that contains your desired data.
- Select Insert linked table.
- By default, the entire sheet will be inserted. To select only a portion of the data, check the Select range box and highlight the cell range to embed.
- Click Insert and your linked spreadsheet table will be added to the slide.
That’s all there is to it! As the source spreadsheet updates, the linked table in your presentation will automatically reflect those changes.
You can resize, style, and format the inserted table just like any other table in Google Slides. And if you need to edit the original sheet data, just click the table and then the Edit source sheet button.
Next let’s look at fully embedding a spreadsheet as an interactive element of your slides…
Method 2: Embed a Live Editable Google Sheet
Along with linking a static table, you can embed the actual Google Sheet itself into your presentation. This allows your audience to actively interact with the live sheet as they view your slides.
Here are the steps to embed a fully-interactive spreadsheet:
- Open your presentation and navigate to the desired slide.
- Click Insert > Google Sheets.
- Select the spreadsheet you want to embed.
- Choose the specific sheet tab to insert if the spreadsheet contains multiple tabs.
- Decide whether to Allow viewers to edit the spreadsheet by toggling the option on or off.
- Click Insert to embed the Google Sheet.
- Resize and position the embedded sheet on your slide as needed.
The sheet will now function as an interactive element that your audience can scroll, sort, filter, edit (if enabled), and more.
To refresh the embedded data once the source sheet has been updated, right-click the element and choose Refresh. Or just save and reopen your Google Slides presentation.
Up next, what if you want to fully convert an entire spreadsheet into a presentation…
Method 3: Convert a Google Sheet to Slides
Rather than just embedding a portion of your sheet data, Google Slides lets you convert an entire spreadsheet into a presentation. This automates turning your sheets into slides:
- Open the Google Sheet you want to convert.
- Click File > Convert to > Google Slides presentation.
- Edit the title for your new presentation.
- Choose whether to include sheet tabs as slide titles. Having this option checked will create a new slide for each of your source sheet tabs.
- Click Convert.
A new Google Slides presentation will open containing your converted spreadsheet. Feel free to edit, add slides, customize formatting, and more.
And finally, if you just want to visualize a snapshot of your sheet data, you can export it as a static image…
Method 4: Export a Sheet as an Image
Rather than linking live data, you may want to capture your spreadsheet at a specific point-in-time as a picture. Here’s how to export your sheet for use as an image in slides:
- Open your Google Sheet and navigate to the desired tab.
- Select the cell range to export. Or leave unset to export the entire active sheet.
- Click File > Download > Image (.png, .jpeg).
- Choose your preferred image format: PNG or JPG.
- Select image size and download options. Larger images have higher resolution.
- Click Download to save the exported sheet snapshot to your computer.
- Now open your Google Slides presentation, navigate to the desired slide, click Insert > Image, and select the downloaded sheet image file from your computer.
The sheet data is now visualized as a high-quality graphic. This method works great for pulling historical data, charts, tables, etc. into your slides as images.
Recap and Next Steps
And there you have it – four simple ways to integrate Google Sheets into your Slides presentations!
To recap, you learned how to:
- Insert a linked spreadsheet table
- Embed a live, editable Google Sheet
- Convert an entire sheet into slides
- Export and visualize a sheet as an image
As next steps, explore mixing and matching these options within your presentations. For example, embed a Sheet to allow edits then export an image to capture the data at a point-in-time.
You can also format linked data using colors, fonts, styles and more to seamlessly blend sheets into your branding. And don’t forget to check back on embedded sheets or linked tables to refresh the latest data.