igforum.bio / how-to-put-a-spreadsheet-in-google-slides - 100682
I
% How to Put a Spreadsheet in Google Slides GA
S
REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps &gt; Google Apps <h1>
How to Put a Spreadsheet in Google Slides</h1>
<h2>
Link to cells or charts in Google Sheets so your Google Slides are up to date</h2> By Tim Fisher Tim Fisher Senior Vice President & Group General Manager, Tech & Sustainability Emporia State University Tim Fisher has more than 30 years&#39; of professional technology experience.
% How to Put a Spreadsheet in Google Slides GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > Google Apps

How to Put a Spreadsheet in Google Slides

Link to cells or charts in Google Sheets so your Google Slides are up to date

By Tim Fisher Tim Fisher Senior Vice President & Group General Manager, Tech & Sustainability Emporia State University Tim Fisher has more than 30 years' of professional technology experience.
thumb_up Like (7)
comment Reply (3)
share Share
visibility 705 views
thumb_up 7 likes
comment 3 replies
D
Dylan Patel 1 minutes ago
He's been writing about tech for more than two decades and serves as the VP and General Manager ...
J
Julia Zhang 1 minutes ago
This article explains how to link to a Google Sheets document from Google Slides so that the data is...
S
He&#39;s been writing about tech for more than two decades and serves as the VP and General Manager of Lifewire. lifewire's editorial guidelines Updated on July 5, 2022 Reviewed by Ryan Perian Reviewed by
Ryan Perian Western Governors University Ryan Perian is a certified IT specialist who holds numerous IT certifications and has 12&#43; years&#39; experience working in the IT industry support and management positions. lifewire's editorial guidelines Tweet Share Email Tweet Share Email <h3>
In This Article</h3> Expand Jump to a Section Link Spreadsheets to Slides Edit Linked Spreadsheets in Slides Benefits of Linking Frequently Asked Questions <h3>
What to Know</h3> Copy the cells or chart from Sheets that you want to import.Paste it into Slides, and choose Link to spreadsheet.Edit the spreadsheet to change the data in the slide.
He's been writing about tech for more than two decades and serves as the VP and General Manager of Lifewire. lifewire's editorial guidelines Updated on July 5, 2022 Reviewed by Ryan Perian Reviewed by Ryan Perian Western Governors University Ryan Perian is a certified IT specialist who holds numerous IT certifications and has 12+ years' experience working in the IT industry support and management positions. lifewire's editorial guidelines Tweet Share Email Tweet Share Email

In This Article

Expand Jump to a Section Link Spreadsheets to Slides Edit Linked Spreadsheets in Slides Benefits of Linking Frequently Asked Questions

What to Know

Copy the cells or chart from Sheets that you want to import.Paste it into Slides, and choose Link to spreadsheet.Edit the spreadsheet to change the data in the slide.
thumb_up Like (44)
comment Reply (1)
thumb_up 44 likes
comment 1 replies
A
Andrew Wilson 2 minutes ago
This article explains how to link to a Google Sheets document from Google Slides so that the data is...
D
This article explains how to link to a Google Sheets document from Google Slides so that the data is always current and only the information you want to present will show up on the slide. It also describes the benefits of integrating worksheet data in a Slides presentation. <h2> How to Add Google Sheets to Google Slides </h2> The steps to link Google Sheets and Google Slides are easy to follow.
This article explains how to link to a Google Sheets document from Google Slides so that the data is always current and only the information you want to present will show up on the slide. It also describes the benefits of integrating worksheet data in a Slides presentation.

How to Add Google Sheets to Google Slides

The steps to link Google Sheets and Google Slides are easy to follow.
thumb_up Like (16)
comment Reply (0)
thumb_up 16 likes
A
<h3> Link to a Range of Data </h3> Follow these steps if you need specific rows and columns to show up in Slides as a table. Select and copy the range from the spreadsheet that you want to be displayed in the slideshow.

Link to a Range of Data

Follow these steps if you need specific rows and columns to show up in Slides as a table. Select and copy the range from the spreadsheet that you want to be displayed in the slideshow.
thumb_up Like (29)
comment Reply (1)
thumb_up 29 likes
comment 1 replies
R
Ryan Garcia 16 minutes ago
Do this by highlighting the selection, and then right-click it and select Copy. Visit the Google She...
E
Do this by highlighting the selection, and then right-click it and select Copy. Visit the Google Sheets home page and use the folder icon to upload your spreadsheet if it's on your computer.
Do this by highlighting the selection, and then right-click it and select Copy. Visit the Google Sheets home page and use the folder icon to upload your spreadsheet if it's on your computer.
thumb_up Like (26)
comment Reply (0)
thumb_up 26 likes
A
Open the Slides document to the slide you want to paste the data into, and go to Edit &gt; Paste. If this is a fresh slideshow that you haven&#39;t made any changes to yet, it&#39;ll most likely have a few templated items that you might not want on the same slide as your spreadsheet data. Spend a few minutes before completing this step, clearing out the slide so it&#39;s not cluttered.
Open the Slides document to the slide you want to paste the data into, and go to Edit > Paste. If this is a fresh slideshow that you haven't made any changes to yet, it'll most likely have a few templated items that you might not want on the same slide as your spreadsheet data. Spend a few minutes before completing this step, clearing out the slide so it's not cluttered.
thumb_up Like (27)
comment Reply (2)
thumb_up 27 likes
comment 2 replies
O
Oliver Taylor 10 minutes ago
Choose Link to spreadsheet and then PASTE on the prompt. The exact columns and rows you copied from ...
A
Amelia Singh 1 minutes ago
But there's another method that lets you do all of it from within Google Slides. Go to Insert &g...
A
Choose Link to spreadsheet and then PASTE on the prompt. The exact columns and rows you copied from Google Sheets now appear in Google Slides.<br/> 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&#39;ll still be linked to the same spreadsheet.<br/> 
 <h3> Link to a Chart </h3> You can link to a chart the same way you can cells of data, by copying and pasting.
Choose Link to spreadsheet and then PASTE on the prompt. The exact columns and rows you copied from Google Sheets now appear in 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.

Link to a Chart

You can link to a chart the same way you can cells of data, by copying and pasting.
thumb_up Like (30)
comment Reply (1)
thumb_up 30 likes
comment 1 replies
M
Madison Singh 4 minutes ago
But there's another method that lets you do all of it from within Google Slides. Go to Insert &g...
H
But there&#39;s another method that lets you do all of it from within Google Slides. Go to Insert &gt; Chart &gt; From Sheets.
But there's another method that lets you do all of it from within Google Slides. Go to Insert > Chart > From Sheets.
thumb_up Like (15)
comment Reply (0)
thumb_up 15 likes
A
Select the spreadsheet that contains the chart you want to import, and then choose Select. Pick the chart you want to use in Google Slides and ensure the check next to Link to spreadsheet is selected.
Select the spreadsheet that contains the chart you want to import, and then choose Select. Pick the chart you want to use in Google Slides and ensure the check next to Link to spreadsheet is selected.
thumb_up Like (42)
comment Reply (0)
thumb_up 42 likes
S
Select Import. <h2> Editing a Linked Spreadsheet in Google Slides </h2> If you make changes to the data, the table&#39;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&#39;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.
Select Import.

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.
thumb_up Like (41)
comment Reply (3)
thumb_up 41 likes
comment 3 replies
C
Christopher Lee 17 minutes ago
It's easy to do this: just click the table or chart once to reveal a small menu at the top. Sele...
J
James Smith 14 minutes ago
If you make a change in Slides and then make a difference change in the spreadsheet, that edit will ...
S
It&#39;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. You can make changes to the table in Slides without visiting Sheets, but those changes don&#39;t apply back to the spreadsheet.
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. You can make changes to the table in Slides without visiting Sheets, but those changes don't apply back to the spreadsheet.
thumb_up Like (27)
comment Reply (1)
thumb_up 27 likes
comment 1 replies
L
Lucas Martinez 43 minutes ago
If you make a change in Slides and then make a difference change in the spreadsheet, that edit will ...
Z
If you make a change in Slides and then make a difference change in the spreadsheet, that edit will override everything you edited from the slideshow. If it&#39;s a table you&#39;re dealing with, also in that menu is the self-explanatory option to Change range.
If you make a change in Slides and then make a difference change in the spreadsheet, that edit will override everything you edited from the slideshow. If it's a table you're dealing with, also in that menu is the self-explanatory option to Change range.
thumb_up Like (0)
comment Reply (2)
thumb_up 0 likes
comment 2 replies
C
Christopher Lee 32 minutes ago
This is where you can edit how much of the spreadsheet shows up in Slides, without needing to erase ...
R
Ryan Garcia 16 minutes ago
Since spreadsheets created in Google Sheets live online, updating what you see in the slideshow is a...
O
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. A beginner&#39;s guide to Google&#39;s spreadsheet tool 
 <h2> Benefits of Putting a Google Spreadsheet in Google Slides </h2> 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&#39;t even have to make the table or chart yourself; it&#39;s all done automatically in seconds, and looks just like it does in Sheets.
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. A beginner's guide to Google's spreadsheet tool

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.
thumb_up Like (37)
comment Reply (1)
thumb_up 37 likes
comment 1 replies
O
Oliver Taylor 54 minutes ago
Since spreadsheets created in Google Sheets live online, updating what you see in the slideshow is a...
D
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&#39;s accessed from, including your Slides files.
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.
thumb_up Like (47)
comment Reply (2)
thumb_up 47 likes
comment 2 replies
J
James Smith 17 minutes ago
This means you can still benefit from the structured format, the helpful formulas, etc., that's ...
H
Hannah Kim 41 minutes ago
For example, you can share the slideshow with someone without sharing the spreadsheet; only the port...
K
This means you can still benefit from the structured format, the helpful formulas, etc., that&#39;s provided by Sheets, even though it&#39;s being accessed in your slideshow. This integration is useful even if you don't want to share the Sheets file.
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.
thumb_up Like (37)
comment Reply (2)
thumb_up 37 likes
comment 2 replies
M
Mia Anderson 43 minutes ago
For example, you can share the slideshow with someone without sharing the spreadsheet; only the port...
I
Isaac Schmidt 23 minutes ago
You can also insert video in Google Slides FAQ How do I insert an Excel spreadsheet into Google Slid...
T
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. Anyone viewing the slideshow will also have access to the Sheets link, but if you haven&#39;t shared the spreadsheet itself with those people, then they won&#39;t have any access (i.e., the link won&#39;t show them the full spreadsheet). If you don&#39;t need the data to be current with what&#39;s in the spreadsheet, you can avoid even the link from being visible by selecting Paste unlinked when asked.
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. Anyone viewing the slideshow will also have access to the Sheets link, but if you haven't shared the spreadsheet itself with those people, then they won't have any access (i.e., the link won't show them the full spreadsheet). If you don't need the data to be current with what's in the spreadsheet, you can avoid even the link from being visible by selecting Paste unlinked when asked.
thumb_up Like (35)
comment Reply (3)
thumb_up 35 likes
comment 3 replies
J
Joseph Kim 27 minutes ago
You can also insert video in Google Slides FAQ How do I insert an Excel spreadsheet into Google Slid...
J
James Smith 43 minutes ago
Some third-party services will let you link an Excel spreadsheet into Slides. However, it's easi...
R
You can also insert video in Google Slides FAQ How do I insert an Excel spreadsheet into Google Slides? Copying and pasting an Excel spreadsheet may not work as well as a Google Sheet; for one thing, you won&#39;t be able to instantly update the copied version.
You can also insert video in Google Slides FAQ How do I insert an Excel spreadsheet into Google Slides? Copying and pasting an Excel spreadsheet may not work as well as a Google Sheet; for one thing, you won't be able to instantly update the copied version.
thumb_up Like (8)
comment Reply (2)
thumb_up 8 likes
comment 2 replies
O
Oliver Taylor 73 minutes ago
Some third-party services will let you link an Excel spreadsheet into Slides. However, it's easi...
A
Audrey Mueller 20 minutes ago
How do I fit a spreadsheet on one slide in Google Slides? Once you've pasted the spreadsheet ove...
A
Some third-party services will let you link an Excel spreadsheet into Slides. However, it&#39;s easier (and probably more secure) to first paste the Excel sheet&#39;s data into a Google Sheet and link from there.
Some third-party services will let you link an Excel spreadsheet into Slides. However, it's easier (and probably more secure) to first paste the Excel sheet's data into a Google Sheet and link from there.
thumb_up Like (1)
comment Reply (0)
thumb_up 1 likes
H
How do I fit a spreadsheet on one slide in Google Slides? Once you&#39;ve pasted the spreadsheet over to Slides, you can resize it using the handles on the corners.
How do I fit a spreadsheet on one slide in Google Slides? Once you've pasted the spreadsheet over to Slides, you can resize it using the handles on the corners.
thumb_up Like (9)
comment Reply (0)
thumb_up 9 likes
E
Make sure the text is still legible after you make it small enough to fit on the slide. Was this page helpful? Thanks for letting us know!
Make sure the text is still legible after you make it small enough to fit on the slide. Was this page helpful? Thanks for letting us know!
thumb_up Like (20)
comment Reply (1)
thumb_up 20 likes
comment 1 replies
E
Elijah Patel 1 minutes ago
Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to...
G
Get the Latest Tech News Delivered Every Day
Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Use Google Sheets How to Remove Duplicates in Google Sheets How to Link Slides in Google Slides How to Save a Google Spreadsheet to Desktop How to Highlight and Find Duplicates in Google Sheets How to Share and Collaborate With Google Drive How to Create a Report in Excel How to Use the Google Spreadsheets AVERAGE Function How to Alphabetize in Google Docs How to Sum Columns or Rows in Google Sheets How to Wrap Text in Google Slides How to Add, Hide, Freeze, or Remove Columns in Sheets How to Share Google Sheets CSV File (What It Is & How to Open One) How to Make a Timeline on Google Slides The 12 Best Tips for Using Excel for Android in 2022 Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies
Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Use Google Sheets How to Remove Duplicates in Google Sheets How to Link Slides in Google Slides How to Save a Google Spreadsheet to Desktop How to Highlight and Find Duplicates in Google Sheets How to Share and Collaborate With Google Drive How to Create a Report in Excel How to Use the Google Spreadsheets AVERAGE Function How to Alphabetize in Google Docs How to Sum Columns or Rows in Google Sheets How to Wrap Text in Google Slides How to Add, Hide, Freeze, or Remove Columns in Sheets How to Share Google Sheets CSV File (What It Is & How to Open One) How to Make a Timeline on Google Slides The 12 Best Tips for Using Excel for Android in 2022 Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies
thumb_up Like (38)
comment Reply (1)
thumb_up 38 likes
comment 1 replies
W
William Brown 70 minutes ago
How to Put a Spreadsheet in Google Slides GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Sea...

Write a Reply