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.