Text box to be deleted

Embed a Live Google Spreadsheet into Google Slides

If you are using Google Slides to create a presentation with data from a Google Sheet, you may want to show that data as a linked table. If you create the table in Google Slides with no linking, it will not update if the data in the Google Sheet changes. Also, this is double work as the data is already in the Sheet, so re-typing it is a waste of time. Below are instructions on how to embed a live Google Sheet directly into your Google Slide. The table that is created will update with one-click and can be styled however you like.

Delete the existing text box

Slides wants a blank area for the table. If you have a text box in your slide, delete it to make a nice, big open space.

Text box to be deleted
Text box to be deleted
Watch the video

This site has a companion YouTube channel that has pretty much, well almost exactly, the same content. If you like this, you'll like that.

Create the Sheet

You need a spreadsheet created in Google Sheets with the table of data that you want to display in your Google Slide. In your spreadsheet, highlight the range that you want, right-click, and select Copy.

Table to Copy
Table to be copied

Paste it into your Slide

Then, go to the location in your Google Slides where you would like the table to be inserted. Right-click with your mouse and choose Paste. A window will pop-up asking you if you want to Link to spreadsheet or Paste unlinked. Choose Link to spreadsheet and click Paste.

Table to Link
Choose Link to spreadsheet

Oh yes, that’s a live, linked table that you’re seeing.

Slide with table embedded into it
Google Slide with embedded Sheet

Working with your embedded table

Updating the embedded table

If you want to change the data within the table, you can go back to the Google Sheet to make the changes. When you come back to the Google Slide after making the changes, there will be a new option available to update the table when you right click on the table as shown in the picture below.

No update option showing
Update option showing

Adding rows

If you add rows to your table in Sheets, you may notice that the added rows don’t show up in the linked table in Slides. You will need to go back to the table in Slides after making the change, left click the more button (three vertical dots), and choose Change range.

Change range option
Option to change the range

Conclusion

Following the steps above should provide you with an easy way to insert a live, linked spreadsheet into your Google Slides. Enjoy!

Live Google Slide with an embedded Sheet

Live Google Sheet that is being embedded

Table to Copy

Embed a Live Google Spreadsheet into a Google Document

If you are using Google Docs to write a document with data from a Google Sheet, you may want to show it as a linked table. If you create the table in Google Docs with no linking, it will not update if the data in the Google Sheet changes. Also, this is double work as the data is already in the Sheet, so re-typing it is a waste of time. Below are instructions on how to embed a live Google Sheet directly into your Google Doc. The table that is created will update with one-click and can be styled however you like.

Create the Sheet

First, you need a spreadsheet created in Google Sheets with the table of data that you want to display in your Google Doc. In your spreadsheet, highlight the range that you want, right-click, and select Copy.

Table to Copy
Table to be copied

Paste it into your Doc

Then, go to the location in your Google Doc where you would like the table to be inserted. Right-click with your mouse and choose Paste. A window will pop-up asking you if you want to Link to spreadsheet or Paste unlinked. Choose Link to spreadsheet and click Paste.

Table to Link
Choose Link to spreadsheet

Oh yes, that’s a live, linked table that you’re seeing.

Doc with table embedded into it
Google Doc with embedded Sheet
Watch the video

This site has a companion YouTube channel that has pretty much, well almost exactly, the same content. If you like this, you'll like that.

Working with your embedded table

Updating the embedded table

If you want to change the data within the table, you can go back to the Google Sheet to make the changes. When you come back to the Google Doc after making the changes, there will be a new option available to update the table when you right click on the table as shown in the picture below.

No update option showing
Update option showing

Adding rows

If you add rows to your table in Sheets, you may notice that the added rows don’t show up in the linked table in Docs. You will need to go back to the table in Docs after making the change, left click the more button (three vertical dots), and choose Change range.

Change range option
Option to change the range

Formatting the table

Formatting is probably best done in Sheets, but if you wish to format the table in Docs, you can right click on the linked table in Docs and choose Table Properties. This will bring up several options that will allow you to add bling to your table until you are satisfied.

Table properties
Table properties

Conclusion

Following the steps above should provide you with an easy way to insert a live, linked spreadsheet into your Google Document. Enjoy!

Live Google Doc with an embedded Sheet

Live Google Sheet that is being embedded

One symbol of check box, one symbol of empty box

Google Sheets | Insert a check box drop down using data validation

As of April 2018, check boxes can be inserted using Insert, Checkbox from the menus. This tutorial is still relevant however, if you would like to use drop-downs with other types of characters.

If you want a way to choose yes/no in Google Sheets, using a check mark can be a good way to do it. While it is not a built-in function, there is a way to create a check box drop down in Google Sheets. The method is a bit of a work around, but it does end up giving you a drop down with the option of a box with a check mark in it or a blank box. The steps below will get you there quickly.

One symbol of check box, one symbol of empty box
Two symbols for check boxes

Video explanation

Note that this video discusses both drop downs and check boxes.

First Step – Data Validation

Click on the Data menu option and then Data Validation.

Data validation menu option
Menu option for Data validation

Once the Data validation window pops up, choose List of items from the criteria drop-down box.

List of items option from drop down box
Choose list of items

Pick from a few different symbols

Copy and paste the two check mark symbols below. These will be the two options that show in the drop down list. If you would like other symbols, they can be found by using Insert Special Characters option in Google Docs and copy and pasting them back into Sheets. Below are two easy, intuitive symbols.

?,?

Following are more options that you can use. Note that you can have the user click a check mark for yes, and just leave the drop down empty for no if you want to just use a check mark not the empty box.

⌧☑✅✓✔???

End result

Keep the rest of the options at their defaults and choose save. You now have a check box!

Check box drop down
Check box drop down

Follow image below for the live Google Sheet with this data

docs share icon