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:
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.
Copy Your Google Sheets Table into Google Docs
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.
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 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.
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
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.
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).
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