How to Insert a Google Sheets Spreadsheet into a Google Docs Document



Watching this Video will take Approximately: 

Reading this lesson will take approximately: 

The Original Source of this content may include additional useful information or context, and will likely contain links to any content, templates or resources mentioned by the narrator. You can find visit the source below:

Lesson Content:

You can't crunch numbers or easily sort columns of data inside a Google Docs document. Those tasks are better left to spreadsheets such as the companion Google Sheets app. And once you have your data organized and formatted in your spreadsheet, you can bring it back into your document easily.

Here's how.

Copy Your Google Sheets Table into Google Docs

copy data from Google Sheets

Lay out your table in Google Sheets then copy it

Spreadsheets are a great way to lay out your data and crunch numbers, far easier to use than the default table tools in Google Docs. So, when you want to add a detailed table to Google Docs, just create it in Google Sheets first. Then, select the data you want to add to your document, and copy it.

Paste Google Sheets spreadsheet into Google Docs

Then open your Google Docs document and paste in the table by pressing CMD+V on a Mac or Ctrl+V on a PC. Google Docs will then ask if you'd like to link the table to the original spreadsheet, or paste the plain data from the spreadsheet. The former is typically the better option, as it will let you re-calculate and re-sort data inside Google Sheets and have those changes show up in your Google Docs document in a click.

Paste Google Sheets table into Google Docs

Paste your table into Google Docs then tweak its formatting

Either way, you'll get the final values from your spreadsheets, along with much of their formatting. Images and formulas won't copy over, though you will get the results from the formula (for instance, =sum(A1:A3) won't copy to Google Docs, but its value of 13 will).

Your pasted values are now a standard Google Docs table. You can add any text formatting, add or remove columns and rows, and add the cell borders you want.

Update Google Sheets table inside Google Docs

If you selected the Link to spreadsheet option, then anytime you update your original Google Sheets spreadsheet, open your Google Docs document as well and click the Update button in the top right corner of your table. That will fetch the latest data and formatting from Google Sheets and update your table in the Google Docs document. Google won't update the document automatically, but with just a click you can get the new data in your document.

Insert a Chart into Google Docs from Google Sheets

Insert chart from Google Sheets

You can embed a chart into Google Docs directly from Google Sheets

Another option is to insert a chart from Google Sheets. First, make the chart from your data in your Google Sheets spreadsheet. Then, in Google Docs, select Insert -> Chart -> From Sheets… to add that chart to your Google Docs document.

Select chart from Google Sheets

Choose your spreadsheet...

You can then select the spreadsheet that contains your chart (with the most recently updated file at the top—which is likely the one you'll want).

Google Sheets chart in Google Docs

You can resize the chart in Google Docs, or update it from Google Sheets

Finally, select the chart you want from your spreadsheet. That'll insert an image of the chart into your Google Docs document, which you can resize or move around as needed. If you want to tweak the chart, open the original Google Sheets spreadsheet and make the changes there, then in Google Docs select your chart and click Update just as with your table.

And that's how you can get your Google Sheets data into Google Docs.

Have another question about Google Sheets or another app? Ask the Zapier team!

Published April 7, 2017; updated April 3, 2019 with new Google Docs features

Written by Zapier writer Matthew Guay

Tools used in this Tutorial