How To Insert Google Sheets Into Google Docs

Last Updated on October 31, 2023 by Jake Sheridan

In this tutorial, you will learn how to insert Google Sheets into google docs.

If you use tables in Google Docs to display data, you may have found yourself wishing you could take advantage of formulas to perform calculations on data in these tables. For example, say you’re preparing an estimate with a calculated total and want the total to update. Fortunately, it’s easy to insert portions of a Google Sheet into a Google Doc and take advantage of all the power of Google Sheets inside your document. Data inserted this way is linked to the Google Sheet and can be updated when changes are made in the linked file

Inserting Google Sheets into Google Docs

Step 1

In the Google Sheet, select the desired range of cells

Step 2

Copy the range. This can be done using hotkeys Ctrl + C on Windows or Command + C on Mac

Step 3

In Google Docs, click the location you want to insert at to move the cursor to that location

Step 4

Hit Ctrl + V on Windows or Command + V on Mac to paste the copied content

Step 5

A prompt will appear asking how you want to paste the data. Make sure the Link to Spreadsheet option is selected and click Paste

Step 6

The selected range from the Google Sheet will appear in the Google Doc as a table. The table will contain not only data from the spreadsheet, but formatting such as cell color and borders, font size, etc

Updating Sheets Data in Google Docs

When you make changes to the Google Sheet’s data or formatting, you’ll want to see those changes reflected in the Google Doc. The linked table in the Google Doc will not automatically update, but anyone with edit access to the linked spreadsheet can easily update the table by following these steps:

Step 1

In the Google Doc, locate the table you want to update and look at the upper right corner of the table. You should see an option that says UPDATE.

If it’s not there, this is probably because the Google Sheet has not changed so the table is up to date. It may also be that you don’t have edit access to the linked spreadsheet, or that the spreadsheet was inserted unlinked

Step 2

Click on the UPDATE button if it is present and the table will automatically update to reflect changes made in the Google Sheet

Updating All Linked Objects in Google Docs

If there are multiple linked objects in the Google Doc, you can update them all at once in the linked objects sidebar

Step 1

Open the Tools menu and choose the Linked Objects option

Step 2

The Linked Objects sidebar will appear with a list of all linked objects in the Google Doc. Click on the blue Update All button at the bottom of the sidebar to update all out of date objects

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

Link to Google Doc document

In this tutorial, I covered how to insert Google Sheets into google docs. Want more? Check out all the Google Sheets Tutorials.