Do you want to add high-level data, reports, and charts from your Google Sheets to Google Docs but don’t know how to do it? In this blog, we will share the solution and lots of tips and tricks to make your work easier. Both Google Sheets and Docs are very popular and most-used apps, and you can combine them to create compelling narratives backed by data and calculations. So what are you waiting for? Let’s get started!
Benefits of Inserting Google Sheets to Google Docs
Let us first discuss the benefits of embedding data from Google Sheets to Docs:
- Creating Compelling Reports: Creating tables and calculations can be a task on Google Docs sometimes. But if you already have them sorted on your Google Sheets, then you are pretty sorted. You just have to link the Sheets to your Google Docs and create powerful narratives backed by data and calculations.
- Save Time and Effort: No more worries about manually updating your Google Docs table. You can make changes in your Spreadsheet and automatically update it on the linked table on Docs with a single click. This will save time and manual effort, and give error-free results.
- Collaborate With Teammates: The best feature of Google Docs and Sheets is the ease of collaboration that they offer. You can easily collaborate with your team and streamline your workflow with real-time data updates.
Now that you know the different benefits of linking your spreadsheet data with Google Docs, let us dive into how to go about it.
Steps to Embed a Google Sheets to Google Docs with Live Link
Follow these simple steps to insert Google Sheets to Google Docs and streamline your workflow:
- Step 1: First, open the Google sheet that you want to insert in the Google doc. Also, keep the Google doc open.
- Step 2: On Google Sheets, select the data you want to copy to Google Docs, and click Edit > Copy (or Ctrl+C).
- Step 3: Open the Google Doc, and click on the place where you want to insert the table. Now click Edit > Paste (or Ctrl+V)
- Step 4: A Paste Table window will appear. Select Link to Spreadsheet, and then click on Paste.
This is how you can insert Google Sheets to Google Docs.
Why Should You Link Google Sheets to Google Docs?
While pasting the Google Sheets to Google Docs, you must remember to link the spreadsheet. This step ensures that your table on the Docs is linked to its original source, and any changes made on the original spreadsheet will be automatically updated on the Google Doc as well. New updates won’t reflect on Docs if the Spreadsheet is not linked.
Remember: Make sure that the table linked on Google Docs and the original spreadsheet should both belong to the same Google account. If you want to insert a Google Sheets from another person’s account, they must provide you with the Editor access.
How to Quickly Update Data on the Google Docs
Updating data on Google Docs from Google Sheets manually can be quite a time-consuming task and prone to mistakes. But did you know you can update the changes on Google Docs with just a single click? Let us tell you how:
- Step 1: Make the required changes in the original spreadsheet. Now open the Google Doc with the table linked to the spreadsheet.
- Step 2: Click on any cell on the table, and you will find an Update option on the floating bar. Click on the Update button, and you will see the changes immediately reflected on your table.
Remember:
- The change can be made only when you make changes on the Spreadsheet, and not vice versa.
- You can not only change the values but also make other edits like changing the color of the cell or highlighting a text.
How to Update Spreadsheet Data on Google Docs By Adding More Rows and Columns
While adding the data from Google Sheets to Google Docs, we have only selected a certain range of rows and columns and added them to the doc as required. However, say you have added more rows and columns to your original spreadsheet, and want to update the same changes on Docs, you can do that too! Just follow these simple steps:
- Step 1: Open your Google Doc and go to the linked table. Now click on any cell on the table.
- Step 2: On top of the table, you will find the Linked Table option, which looks like three vertical dots.
- Step 3: Select Change Range.
- Step 4: A Linked Cell Range pop-up window will appear. Here you have to update the new cell range, and then click OK.
Now you will find more cells added to the table on your Google Docs.
However, if you are planning to add more rows or columns in the future, you should always add some extra rows and columns while linking your Google Sheets to Google Docs. For example, in this case, we had originally added the cell range from A1 to E11. We could have added from A1 to E15 to make our work easier.
Remember:
Adding additional columns may compress your table on Google Docs, so bear it in mind while making the changes.
How to Insert a Chart from Google Sheets to Google Docs
Do you want to add visual data like charts from your Google Sheets to Google Docs? Here are some simple steps to do so:
- Step 1: Select the chart from your Google Sheets that you want to insert in Google Docs.
- Step 2: Open Google Docs and take the cursor where you want to enter the chart. Now Select Insert > Chart> From Sheets.
- Step 3: Click on the Sheets where you have created the chart.
- Step 4: An Import Chart window will appear. Click on the chart, and select Import.
And Done! An image of the chart from Sheets will be embedded in your Google Docs file.
You can modify the size of the chart, and move it as required. You can also make the changes on the original spreadsheet and update it on Google Docs.
How to Unlink Data from Google Sheets to Google Docs
If you want to unlink spreadsheet data and it will no longer be updated on Google Docs, follow these simple steps:
- Step 1: Click on any cell on the table on Google Docs linked to Sheets. On top of the table, you will find the floating toolbar for Linked Table Options.
- Step 2: Click on it, and select Unlink.
And done! Your table will no longer be linked to Sheets, and you cannot make automatic changes to it.
Bonus Tip: How to Add Excel Sheet to Google Docs
If you are working on MS Excel and want to insert the table into Google Docs, this process is quite easy. All you have to do is import your Excel file into Google Sheets and then follow the steps discussed above to insert the Google Sheets into Google Docs.
Final Thoughts
As we have discussed earlier, linking your data from Google Sheets to Google Docs will be very beneficial to not only create informative, data-backed articles but also streamline your workflow and boost essential team collaboration. We have discussed the steps to link, unlink, update, and modify the linked table in detail, and hope they will be helpful for you to follow and get done with your tasks. Happy Hustling!