---
title: "How to insert a Google Sheet into a Google Doc"
description: "Here's how to embed a Google Sheet into a Google Doc so you can show snippets of your data. Plus, how to update a table in Google Docs with just one click."
image: "https://images.ctfassets.net/lzny33ho1g45/4Kz6cQ8kEdHei7vsUpQz6g/eda694a36a0b4e41ee5b66202e6ecbca/Google_Sheets_to_Google_Docs_hero.jpg"
---

# How to insert a Google Sheet into a Google Doc

Here's how to embed a Google Sheet into a Google Doc so you can show snippets of your data. Plus, how to update a table in Google Docs with just one click.

You can't crunch numbers or easily sort columns of data inside a [Google Docs ](https://zapier.com/blog/how-to-use-google-docs/)document. Those tasks are better left to spreadsheets. But once you have your data organized and formatted in your spreadsheet, you can easily add it to your Google Doc. 

Here, I'll show you how to embed a [Google Sheet](https://vendors.selectsoftwarereviews.com/redirect/1767831752373x549042478702919700?p=1715808885462x244895206427328500) into a Google Doc. Plus, learn how to update a table in Google Docs with just one click. 

**Table of contents**: 

- [How to insert a Google Sheet into a Google Doc](#insert-sheet)
- [How to update your table in Google Docs](#update-tables)
- [How to insert a chart from Google Sheets](#insert-chart)
- [More ways to connect Google Sheets to Google Docs](#more)
- [Inserting Google Sheets into Google Docs FAQ](#faq)

## How to insert a Google Sheet into a Google Doc 

Here's how to embed a [Google Sheet](https://zapier.com/blog/google-sheets-tutorial/) into a Google Doc, so you can show snippets of your spreadsheet data. 

1. Open the Google Sheet you want to pull data from and the Google Doc you want to copy the data into.
2. From your spreadsheet, highlight the data you want to copy, and select **Edit** > **Copy **(or use your keyboard shortcut).

3. Now in your Google Doc, click where you want to put your table, and then select **Edit** > **Paste. **You can use your keyboard shortcut here, too.
4. From the _Paste table _window that appears, select **Link to spreadsheet**, then click **Paste**.** **

5. The selected data from your spreadsheet will appear in your doc.

A few things to keep in mind: 

- Formatting will generally stay intact, but some elements, like dropdown fields, won't appear in the doc.
- If you select _Paste unlinked,_ the table in Google Docs won't include a link to the original data source (the spreadsheet). That means any updates made to the original spreadsheet won't be reflected in the Google Doc—they'll be completely separate assets.
- The connection is only one way: updates you make in the corresponding cells in your Google Sheet will be reflected in your doc, but changes made in the table of the Google Doc won't be reflected in the spreadsheet.
- [Tables in Google Docs](https://zapier.com/blog/remove-table-borders-in-google-docs) must be linked to Google Sheets spreadsheets stored in the same Google account. If you want to link your table to a spreadsheet from another account, you need to have [_Editor_ access](https://support.google.com/docs/answer/2494822?hl=en&co=GENIE.Platform%3DDesktop#zippy=%2Cchoose-if-people-can-view-comment-or-edit) to that spreadsheet.

If you haven't already tried syncing Google Sheets and Google Docs in this way, give it a go. At a minimum, you'll have a beautifully formatted table in your Google Doc. And I, for one, am always looking to [make my Google Docs just a little bit prettier](https://zapier.com/blog/google-docs-formatting-tips/).

## How to update your table in Google Docs 

It would be time-consuming (and ripe for [errors](https://zapier.com/blog/formula-parse-error-google-sheets)) if you had to manually update the table in your doc _every time_ you updated your original data source. Fortunately, Google thought ahead on this one. 

1. With your Google Doc open, select any cell in the table.
2. Click **Update** in the floating toolbar.

Your table will update and the _Update_ button will disappear, indicating that your table reflects the most recent version of your spreadsheet data (or the data range indicated for your table). 

Every time you make updates to your spreadsheet, be sure to go back into your document and select **Update**.

### How to change the range in your linked table

When you originally copied data from your spreadsheet to your document, you effectively copied a specific cell range. In the original example, only data from cells A2:D7 were copied. 

For the purposes of this section, I've added more rows of box office data to my spreadsheet. 

Now I want to update the table in my Google Doc so it matches what I've recorded in Google Sheets. Here's how to update the data range for your table in Google Docs. 

1. Select any cell in the table.
2. Click the **Linked table options** icon, which looks like three dots stacked vertically (`⋮`), in the floating toolbar above the table.
3. Click **Change range. **

4. In the _Linked cell range_ window that appears, update the range, and click **OK.**

If you don't have any data in those rows yet, empty rows will automatically appear in your table. If you've added new data, like I did, those rows will now appear in your Google Doc.

If you're not sure about what data you might add down the road, I suggest giving yourself an additional five to 10 rows as a buffer. For example, if my original data range was A1:D7, I would update this to A1:D12. If you need to add additional _columns_, your table will get compressed, so keep this in mind when formatting your document. 

### How to view your linked spreadsheet in Google Docs

You don't need to keep your spreadsheet open alongside your doc all the time. If you need to access your spreadsheet, you can do that straight from the Google Doc.

1. Select any cell in the table.
2. Click the **Linked table options** icon, which looks like three dots stacked vertically (`⋮`), in the floating toolbar above the table.
3. Click **Open source **to open the spreadsheet directly.

## How to insert a chart from Google Sheets 

If you need to add visual data to your Google Doc, here's how to insert a chart from Google Sheets. 

1. [Make a chart](https://zapier.com/blog/how-to-make-pie-chart-google-sheets/) from your data in your Google Sheets spreadsheet.
2. In your Google Doc, select **Insert** > **Chart** > **From Sheets. **

3. Select the Google Sheet containing your chart.
4. In the _Import chart_ window that appears, select the chart you want to import, and then click **Import.**

This will embed an _image_ of the chart into your Google Doc, which you can resize or move around as needed. If you need to tweak the chart, edit the original chart in Google Sheets. Then in Google Docs, select your chart, and click **Update** just as you would with your table. 

You're all set! 

## More ways to connect Google Sheets to Google Docs 

If you're tired of manually copying and pasting data from Google Sheets to Google Docs (or vice versa), automate the process instead. With [Zapier](https://zapier.com), you can [connect Google Sheets to Google Docs](https://zapier.com/apps/google-sheets/integrations/google-docs) to automatically send info between the two apps. Here are some pre-made templates to show you how it works.

Beyond sending data from Sheets to Docs, [Zapier's AI orchestration platform](https://zapier.com) makes it easy to build dynamic, intelligent workflows between your Google apps and the rest of your tech stack. Create Zaps that don't just transfer data but also analyze, summarize, and format it automatically. 

For example, you could use AI actions to generate polished reports in Docs from Sheets data, or to enrich spreadsheet entries with AI-generated insights or summaries. Zapier can trigger complex automations that move data between Sheets, Docs, and other connected tools, orchestrating workflows that adapt intelligently as your data changes.

## Inserting Google Sheets into Google Docs FAQ

Here are a few more answers if you're still trying to figure out if embedding a Google Doc in a Google Sheet is the way to go.

### Can you combine a Google Sheet and Google Docs?

You can add part of a Google Sheet into a Google Doc by copying the cells and choosing _Paste linked_. But if you're consistently combining spreadsheets and docs, you might be better off with an app like [Notion or Coda](https://zapier.com/blog/coda-vs-notion/) that has both functions built in.

### How to populate a Google Doc from a Google Sheet

You can populate a Google Doc from a Google Sheet by copying the spreadsheet cells into the Google Doc (they'll even be linked to the original data source). Or you can use Zapier to automate the process by [autopopulating a Google Doc template](https://zapier.com/blog/create-autopopulate-google-docs-template/) based on changes made to a Google Sheet.

### Can I embed a Google Sheet into a Google Doc?

You can embed a Google Sheet into a Google Doc, but you can't edit it within the Doc—all editing still needs to happen in the Google Sheet.

**Related reading:**

- [Remove page breaks in Google Docs with pageless view](https://zapier.com/blog/google-docs-pageless/)
- [Why won't Google Docs let me paste without installing an extension?](https://zapier.com/blog/why-cant-you-copy-and-paste-in-google-docs/)
- [How to create and autopopulate a Google Docs template](https://zapier.com/blog/create-autopopulate-google-docs-template/)
- [How to add a dropdown list in Google Sheets](https://zapier.com/blog/how-to-add-dropdown-list-google-sheets)
- [Free Google Sheets templates to boost productivity](https://zapier.com/blog/google-sheets-templates)
- [How to see who viewed your Google Doc](https://zapier.com/blog/how-to-see-who-viewed-your-google-doc)

_This article was originally published by Matthew Guay in May 2019. The most recent update was in October 2025._