Table of Contents
This tip is about the how to Insert a Google Sheet to Google Docs. So read this free guide, How to Insert a Google Sheet to Google Docs step by step. If you have query related to same article you may contact us.
How to Insert a Google Sheet to Google Docs – Guide
Google Sheets is a spreadsheet program that is part of Google’s free web-based Google Document Editors suite. The service also includes Google Docs, Google Slides, Google Drawings, Google Forms, Google Sites and Google Keep. Google Sheets is available as a web application, mobile app for Android, iOS, Windows, BlackBerry and as a desktop app for Google’s Chrome OS. The application supports Microsoft Excel file formats.
The app allows users to create and edit files online while collaborating with other users in real time. Changes are tracked by the user with a change history showing the changes. An editor’s position is highlighted with an editor-specific color and a cursor and rights system regulates what users can do. Updates introduced features that use machine learning, including Explore, which provides answers based on natural language questions in a spreadsheet.
You can’t process numbers or just sort columns of data in a Google Docs document. It’s best to leave these tasks to spreadsheets, like the Google Sheets companion app. And once you’ve organized and formatted your data in your spreadsheet, it’s easy to paste it back into your document.
Insert the Google Sheet into a Google Doc with an active link
Suppose you have a dataset as shown below in Google Sheets and want to insert the table into this sheet in Google Docs. And, of course, we want this to be linked so that if I change something in the table, it automatically changes in Google Docs.
Below are the steps to how to put a Google spreadsheet in a Google Doc:
The steps above insert the Google Sheets table into the Google Docs document.
Because this table is connected to the original data in Sheets, when you make any changes to the source data in Sheets, you can update this table to reflect the changes in the copied table as well.
And remember that data is not updated, it is not real-time. You will have to manually update the table by clicking refresh button (covered in the next section).
There are two things you need to know when using this technique:
Updating data (with a single click)
When you change any data in the original range in Google Sheets (which was copied and inserted into Google Docs), you will see an option to update the table in Google Docs (appears only when you select any cell in the table).
The update button appears only when there’s a change to your Google Sheets data. And to apply this change and make it visible in Google Docs, you need to click ‘Update’ button.
In addition to changing the value of cells, you can also bring the formatting from Google Sheets into Google Docs.
For example, if I manually change the color of some cells in the original Google Sheets data, I’ll see the update button on Google Docs. And when I click on it, it will bring the spreadsheet data formatting into Google Docs.
Note that although you can update the data to reflect the cell color, the table border is not linked. In addition, you can also use conditional formatting on your Google Sheets data and this will be reflected in your Google Docs data (I think this is really cool!).
Update data when more rows are added after inserting a spreadsheet into Google Doc
When you enter Google Sheets data into a Google Docs document, it’s only linked to that specific range.
For example, in our example, we entered the range A1:E7 from Google Sheets into Google Docs.
But what if I add a new row to the dataset (in the final dataset or somewhere in between).
Unfortunately, you won’t be able to update the data when adding new rows to the dataset (deleting rows is good and will be considered).
So if you add new rows, you will need to update the range so that it now refers to the new range that has the added rows.
Below are steps to change the linked range in Google Docs:
While this works great, if you’re working with live data that is likely to change, it’s best to first create a named range and then use that named range to insert the Google Sheets table into Google Docs.
That way, when you add rows/columns to the dataset, the named range expands to account for those 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 will be updated when you update the named range.
You can also change the range and select a named range in the Linked Cell Range dialog. It lists all the named ranges you have in linked Google spreadsheets.
In case you create a named range later (after adding data from Google Sheets to the Goole Docs document), you can always change the linked range. Simply click on the ‘Linked Table’ option (the icon at the top right of the table) and click on the ‘Change Range’ option. It will show the named range in the dialog.
Unlink data from Google Sheets
If you want to unlink data from Google Sheets (which is now in Google Docs), you can do that easily too.
Just click anywhere in the table you’ve inserted, click the ‘Linked Table Options’ icon, then click Unlink.
This will instantly break the link and you will have a static table on the page.
Insert a chart from Google Sheets to Docs
now that you know how to put a google spreadsheet into a google document, you might be wondering if you can just insert a graphic. The answer is a simple yes! You can do this by following these steps:
The chart should then appear in your document and automatically update when you change the spreadsheet.
So these are the ways you can define Google Sheets cells / range in a Google Docs document.
Final note
I hope you like the guide How to Insert a Google Sheet to Google Docs. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.