How to Insert a Google Sheet Into a Google Doc [Easy Guide]

While Google Sheets are great when you have to maintain a record or work with data, but in many cases, your final work may involve presenting this data in Google Docs or Google Slides.

You can always insert Google Sheet into Google Doc as a static table, but then you have to update it manually whenever the data changes.

Thankfully, there is a way to insert sheets into docs in such a way that it automatically updates when you change the data in Google Sheets (a linked data set).

In this tutorial, I will show you how to embed a Google Sheet in a Google Doc file and how you can keep these linked.

Insert a Google Sheet Into a Google Doc With a Live Link

Its simple to import data from Google Sheets to Google Docs. But if you need to use and .xls file you may need to convert it to a Google Sheets file first.  let’s take a look at an example.

Suppose you have a dataset as shown below in the Google Sheets and you want to insert the table in this sheet in Google Docs. And of course, we want this to be linked so if I change anything in the table, it automatically changes in the Google Docs.

Data from Google Sheets to insert into Google Docs

Below are the steps of how to put a Google spreadsheet into a Google Doc:

  1. Select the range in Google Sheets that you want to insert in Google Docs
  2. Copy it (use Control + C or right-click and then click on Copy)Copy the data in Google Sheets
  3. Open the Google Docs document in which you want to insert the table
  4. Place the cursor where you want to get the data (table)
  5. Paste the data (Control + V or right-click and then click on Paste). This would open the ‘Paste Table’ dialog boxClick on Paste in Google Docs
  6. In the Paste Table dialog box, make sure the ‘Link to Spreadsheet’ option is checked.Click on Link to Spreadsheet
  7. Click on Paste

The above steps would insert the Google Sheets table in the Google Docs document.

Since this table is connected to the original data in Google Sheets, when you make any changes in the source data in Google Sheets, you will be able to update this table and reflect the changes in the copied table as well.

And remember that the data doesn’t get updated is not real-time. You will have to manually update the table by clicking the update button (covered in the next section).

There are two things you need to know when using this technique:

  1. The copied data in Google Docs is connected/linked to the original data but it doesn’t get updated in real-time. It, however, gives you an option to update the data with a single click
  2. This works only when both the Google Sheets and Google Docs document are in the same account (or have been shared with full-access). If you try to copy data from Google Sheets from one account into Google Docs from some other account, it will not show you the Paste Table dialog box. It will simply paste it as regular unlinked data.

Updating the Data (with a Single Click)

When you change any data in the original range in Google Sheets (that has been copied and inserted in the Google Docs), you will see an option to update the table in Google Docs (only appears when you select any cell in the table).

Update button in the table

The Update button appears only when there has been a change in the Google Sheets data. And to apply that change and make it visible in the Google Docs, you need to click on the ‘Update’ button.

Apart from the change in the value in the cells, you can also bring the formatting from Google Sheets into Google Docs.

For example, if I manually change the color of a few cells in the original data in the Google Sheets, I will see the Update button in Google Docs. And when I click on it, it will bring the formatting the spreadsheet data into Google Docs.

Update to show formatting in the table

Note that while you can update the data to reflect the color of the cell, the border of the table is not linked. Also, you can also use conditional formatting on the Google Sheets data and it will be reflected in the data in Google Docs (I find this super cool!).

Updating Data When More Rows Are Added After You Insert a Spreadsheet Into Google Doc

Now you know how to convert Google Sheets to Google Doc, but it is only linked to that specific range.

For instance, in our example, we have inserted the range A1:E7 from Google Sheets into the Google Docs.

But what if I add a new row to the dataset (at the end of the dataset or somewhere in the middle).

Unfortunately, you will not be able to update the data when you add new rows in the dataset (deleting rows is fine and will be accounted for).

So if you add new rows, you need to update the range so that it now refers to the new range that has the added rows.

Below are the steps to change the linked range in Google Docs:

  1. Click anywhere in the table in Google Docs
  2. Click on the ‘Linked Table Option’ (the icon at the top-right part of the table)
  3. Click on Change RangeClick on Change range to expand the table range in Google Docs
  4. Specify the new range hereSpecify the new range here

While this works great, if you’re working with dynamic data that is likely to change, it’s best to first create a named range and then use this named range to insert the table from Google Sheets into Google Docs.

This way, when you add rows/columns in the dataset, the named range expands to account for these newly added rows/columns.

For this to work, you need to create a named range in Google Sheets, and then copy the data from there to Google Docs. This way, your table will be linked to the named range and update when you update the named range even after you convert Google Sheets to a Google Doc.

You can also change the range and select a named range in the ‘Linked cell range’ dialog box. It lists all the named ranges that you have in the linked Google Sheets.

Select from Named Range in Google Sheets

In case you create a named range later (after you have added Google Sheets data in the Goole Docs document), you can always change the linked range. Simply click on the ‘Linked Table Option’ (the icon at the top-right part of the table) and click on the ‘Change Range’ option. It will show you the named range in the dialog box.

How to Insert a Spreadsheet Into Google Docs and Unlink the Data

If you want to unlink the data from Google Sheets (that is now in Google Docs), you can easily do that as well.

Just click anywhere in the table that you have inserted, click on the ‘Linked table options’ icon and then click on Unlink.

Click on Unlink to remove the link with Google Sheets

This will instantly break the link and you will have a static table on the page.

Note: In case you want to insert Google Sheet into Google Doc as an object or as a link (so that when the user clicks on it, it opens this Google Sheets, you can do that clicking on the Share (green button) at the top-right and getting a shareable link.

Insert a Chart From Google Sheets to Docs

Now that you know how to put a Google Sheet into a Google Doc, you may be wondering if you can just insert a chart. The answer is a simple yes! You can do it by following these steps:

  1. Make the chart in Google Sheets
  2. In Google Docs, navigate to Insert>Chart>From Sheets
    Insert chart from sheets example
  3. Find the spreadsheet with the desired chart and click Import chart
  4.  Click Import

The chart should then display in your doc and automatically update when you change the spreadsheet.

Insert a Google Sheet Into a Google Doc FAQ

Can You Add a Google Sheet to a Google Doc?

Yes, you can. You essentially just have to highlight the range you wish to move to Docs and copy and paste it over.

Can You Link Google Sheet Cell to Google Doc?

Yes, you just have to:

  1. Highlight the cell(s) you wish to link in Sheets
  2. Press Ctrl+C
  3. Click over to the Google Docs and press Ctrl+V
  4. Make sure Link to spreadsheet is checked in the dialog box that pops up.

How Do You Copy a Table in Google Docs?

Click and drag over the entire table, then pres Ctrl+C to copy and Ctrl+V to paste.

Learning More

So these are the ways you can Google Sheets cells/range into a Google Docs document.

Hope you found this tutorial useful!

If you found this guide on how to insert a Google Sheet into a Google Doc useful, here are some other tutorials you may like:

Most Popular Posts



Google Sheets and Microsoft Excel Expert.

4 thoughts on “How to Insert a Google Sheet Into a Google Doc [Easy Guide]”

  1. Thank you for this guide! Though it isn’t exactly ‘automatic’ if the doc creator needs to update the table with a manual click each time the data changes. Is there a way you know of to create a truly automatically updating linked table (no manual clicks required) – perhaps using a Google Script?

  2. hi there,
    i want to use zapier to automatically create a new invoice every month.
    google sheets data -> google docs -> zapier -> pdf
    is there any way to update the field automatically, by zapier or by a script?
    Thanks in advance!
    Markus Castro

  3. Is there a way to insert an unformatted cell value from a Google Sheets document to a Google Docs document that updates automatically?


Leave a Comment