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
2. Right-click and select Copy or press CTRL + C on your keyboard to copy
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
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
5. You should now see your spreadsheet is in your doc
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:
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.