Create Courses

How to insert a Google Sheet into a Google Doc?

Pinterest LinkedIn Tumblr

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.

Launch an online course

GOT YOUR CONTENT READY? GRAPHY IS ALL YOU NEED TO GET STARTED!

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

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:

 insert a Google Sheet into a Google Doc

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. 

insert a Google Sheet into a Google Doc

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. 

Launch an online course

GOT YOUR CONTENT READY? GRAPHY IS ALL YOU NEED TO GET STARTED!

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. 

insert a Google Sheet into a Google Doc

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. 

Launch an online course

GOT YOUR CONTENT READY? GRAPHY IS ALL YOU NEED TO GET STARTED!

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. 

insert a Google Sheet into a 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.

insert a Google Sheet into a Google Doc

Step #2 Go to your Google Doc and click on the “Linked Table Options” icon. 

insert a Google Sheet into a Google Doc

Step #3 Here, you will find an option to “Change rows.” Click on it and select the new range you want to consider. 

insert a Google Sheet into a Google Doc

Step #4 Save changes by clicking on the “Ok” button. 

insert a Google Sheet into a Google Doc

Now, you will find the updated range on your Google Doc. 

Launch an online course

GOT YOUR CONTENT READY? GRAPHY IS ALL YOU NEED TO GET STARTED!

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. 

insert a Google Sheet into a Google Doc

Once done, your data will get unlinked, and you won’t be able to make automatic changes from Google Sheets to your Google Doc. 

Launch an online course

GOT YOUR CONTENT READY? GRAPHY IS ALL YOU NEED TO GET STARTED!

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.

Launch an online course

GOT YOUR CONTENT READY? GRAPHY IS ALL YOU NEED TO GET STARTED!

Graphy offers a load of features that will definitely add stars to your success, features like:

  • White-labeled 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.

Do you have a skill that you want to monetize?If yes, Graphy is the perfect solution for you!

Create, sell, and market your knowledge using an all-in-one platform that offers you entire authority over your brand and business.