Skip to Content

How to Insert Google Sheets into Google Docs

When working in Google Docs, there may be times when you want to insert a table from Google Sheets into your document.

Luckily, you can do this in a way that if your spreadsheet data updates, you can update the data in your Google Doc as well.

In this tutorial, I will show you how to insert a table from Google Sheets into a Google Doc

Inserting Google Sheets into Google Docs

The process of inserting a linked sheet into Google Docs that will update when your original spreadsheet updates is a pretty simple process.

Here are the steps:

1. First open up Google Sheets and highlight the table that you want to put into Google Docs

Google Sheet to Google Doc-1

2. Right-click and select Copy or press CTRL + C on your keyboard to copy

Google Sheet to Google Doc-2

3. Open up your Google Doc and find where you want to insert the table. Right-click and select Paste or press CTRL + V on your keyboard to paste

Google Sheet to Google Doc-3

4. If you want your table to have the ability to update if the data in your original spreadsheet changes, make sure the Link to spreadsheet option is selected. If you want it unlinked so it can never be updated, select Paste unlinked. Select the Paste button when you are done

Google Sheet to Google Doc-4

5. You should now see your spreadsheet is in your doc

Google Sheet to Google Doc-5

Updating Your Sheet

If you have inserted a table that is linked to your original spreadsheet, it can be updated if the data in your spreadsheet changes.

After there is a change in your spreadsheet, the table in Google Docs will have an update button appear at the top. When you click on this button, your table will refresh and pull updated data:

Update Sheet in Doc

Closing Thoughts

Putting a table into Google Docs is a very simple process. The key is to make sure that it is linked to your original spreadsheet if you want to be able to update it.

Hopefully, you found this tutorial helpful.

More Google Sheets Tutorials:
How to Convert Google Doc to Sheets
How to Insert Google Sheets into Google Slides