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

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

0 thoughts on “Embed a Live Google Spreadsheet into a Google Document

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>