How to insert Google Sheets tables into Google Docs

For more convenience in editing content, on the office tools have added features to insert data, such as inserting Word files into Excel files or insert PowerPoint slides into Word. So how about Google Docs if you want to insert other content into your document?

Even Google Docs has the option to create tables, but you can completely insert Google Sheets spreadsheets into content on Google Docs or Google Slides with a very simple way. Thus viewers will follow the content more seamlessly, without having to open the Google spreadsheet file to see. The following article will guide you how to insert spreadsheet files into Google Docs.

1. How to attach Word and Excel files in PowerPoint
2. How to align spreadsheets before printing on Google Sheets
3. How to set up the right to edit spreadsheets on Google Sheets
4. How to format conditional cells in Google Sheets

Instructions for inserting spreadsheets into Google Docs

Step 1:

First of all, you need to create data tables on Googe Sheets and then edit the tables like inserting colors, changing fonts, .

How to insert Google Sheets tables into Google Docs Picture 1

Next we black out the entire data table and right-click and choose Copy , or press Ctrl + C to copy.

How to insert Google Sheets tables into Google Docs Picture 2

Step 2:

In the content on Google Docs, click at the location where you want to insert the tables and press Ctrl + V to paste the content, or right-click and choose Paste.

How to insert Google Sheets tables into Google Docs Picture 3

Then display 2 options to paste tables into the content of Google Sheet including:

1. Link to spreadsheet: allows users to update the content of a Google Docs spreadsheet, when there are any edits on Google Sheets tables.
2. Paste without content linking: tables do not have an update button to refresh content when there are changes.

Here you should choose Link to spreadsheet to change content if you want. Continue clicking the Paste button below to insert the table into the Docs content.

How to insert Google Sheets tables into Google Docs Picture 4

As a result, users will see tables displayed on Google Docs remain in the table format, font, font size or color of the text if available.

How to insert Google Sheets tables into Google Docs Picture 5

Step 3:

Clicking on the table will display the option of Unlinking the original document on Google Sheets and Open the original data.

How to insert Google Sheets tables into Google Docs Picture 6

If you click Change cell range in this option list you can change the spreadsheet data area, such as expanding or shrinking through columns and lines. We just need to enter the data area we want to change.

How to insert Google Sheets tables into Google Docs Picture 7

The result of the data table is displayed as shown below due to the operation of narrowing the data area.

How to insert Google Sheets tables into Google Docs Picture 8

Step 4:

If the Google Sheets tables are refreshed, the Google Docs panel will display an Update button as shown below.

How to insert Google Sheets tables into Google Docs Picture 9

When you click on it, the new data will be updated for the table.

How to insert Google Sheets tables into Google Docs Picture 10

Step 5:

After inserting the table into the content of Google Docs we can proceed to change the table format. Black out the table and right-click and choose Table Properties .

How to insert Google Sheets tables into Google Docs Picture 11

Here you can adjust the position of the table, adjust the background color of the table, the border color of the table, adjust the color for each cell and click OK to update.

How to insert Google Sheets tables into Google Docs Picture 12

The table will change according to the format we have set.

How to insert Google Sheets tables into Google Docs Picture 13

The same way of inserting tables from Google Sheets to Google Slides, you can copy and paste into the content on Slides.

How to insert Google Sheets tables into Google Docs Picture 14

The operation of inserting Sheets from Sheets into Google Docs or Google Slides is simple and easy. Any content will be updated when you change any content on Google Slides. The table after inserting into the document still changes the format if the user needs it.

I wish you all success!