In this blog, we will discuss the step-wise way to insert a Google Sheet into a Google Doc .
Google Sheets and Google Docs are two of the most used apps in the Google ecosystem. Google Docs lets you create, edit, and collaborate on online documents, whereas Google Sheets lets you create excellent spreadsheets. So it is imperative to learn how you can insert a Google Sheet into a Google Doc.
When working in Google Docs, you might want to insert a table from Google Sheets into your document. Thankfully, there is a way to do so where you can insert tables from Google Sheets and update them automatically.
- Insert a Google Sheet into a Google Doc using a live link
Insert a Google Sheet into a Google Doc using a live link
To insert a Google Sheet into a Google Doc using a live link is simple. Let’s say you want to paste this table into a Google Doc. Here are the steps you need to follow:
Step #1Choose the range from the Google Sheet that you want to insert into the Google Doc.
Step # 2 Use Ctrl+C or go to Edit > Copy to copy the range.
Step #3 Open Google Docs, and place the cursor where you want to insert the table.
Step #4 Paste the table using Ctrl+Paste or Edit>Paste.
Step #5 You will find a paste dialog box that appears. Here, you can choose between linked or unliked tables.
If you link the data, any changes made to the Google Sheet can be automatically updated in the Google Doc. On unlinked, there will be no change if you edit the table in Google Sheets.
Step #5 Select Paste.
You must remember that changes made to the original data in Google Sheets don’t get updated in real-time. You will surely get an option to update the Google docs, which we will discuss in the next section.
Also, you must have access to Google Docs and Google Sheets to link the data and paste the linkable table into the document.
See how simple it is to insert a Google Sheet into a Google Doc.
Now, let’s find out how you can automatically update your selected spreadsheet data directly in Google Docs.
Update the spreadsheet data in the Google Doc with a single click
When you change data in the original table on your Google Sheets that is now pasted on Google Docs, you will see an “update” option in the document.
This only happens when you change the Google Sheets and not vice-versa.
As you can see, there is an update option above the table. This means any changes are made to the original document when you click on the “update” button.
This not only works on values but also on different formatting options like coloring a few cells, re-adjusting the fonts or size, and more.
For instance, when coloring cells in the original document of Google Sheets, you will also see the update option in the Google Doc. When clicked on the Update option, the color would also appear in the Google Doc.
Updating spreadsheet data in Google Docs when more rows are added to Google Sheets
You now know how to insert a Google Sheet into a Google Doc, but it’s limited to certain ranges. For instance, here, we have linked C5:F10. Anything beyond that doesn’t get updated with the “update” button.
But, you change the range and make it work for you. Let’s see how
Step #1 Add rows to your Google Sheet table to make this process work.
Step #2 Go to your Google Doc and click on the “Linked Table Options” icon.
Step #3 Here, you will find an option to “Change rows.” Click on it and select the new range you want to consider.
Step #4 Save changes by clicking on the “Ok” button.
Now, you will find the updated range on your Google Doc.
Unlink spreadsheet data from Google Sheets in Google Docs
It’s quite simple to unlink data from the Google Sheet, which is now on Google Docs.
Click on the “unlink” option from the “Linked table options” above your table.
Once done, your data will get unlinked, and you won’t be able to make automatic changes from Google Sheets to your Google Doc.
Related Blog: How to create google form into a Google Docs
Graphy, the online course creation, and selling platform
If you are looking to create your online course and sell it with minimum effort and easy-to-use features, then Graphy is the best place for you. Graphy has thousands of active content creators who have created their own online courses and monetized their skills. You can also do the same, and the best thing is that you can start for free.
Graphy offers a load of features that will definitely add stars to your success, features like:
- Branded website and mobile app
- Advanced-level marketing and sales tools and features
- Multi-layer content security
- Rich multimedia
- 24*7 customer support
- Customizable landing/sales pages
- Personalized course completion certificates for your learners
- Integrated payment gateways and country-specific pricing
Isn’t it amazing?
So join Graphy, just like 40,000+ creators.