How to insert Google sheets into Google Docs

by
How to insert Google sheets into Google Docs

Are you looking at how to insert Google sheets into Google Docs? Here’s everything you need to know!

Inserting Google Sheets into Google Docs can offer you various benefits – You can edit, organize, and analyze different types of information in your sheets right from Google Docs; You can leverage collaborations, and multiple users can edit and format files in real-time. 

But is it possible to easily transfer all of your Google sheets data into a Google Docs document? Let’s find out. Read this article to learn how to insert Google sheets into Google Docs. 

How to insert Google sheets into Google Docs?

Below are some of the easy ways to insert Google sheets into Google Docs.

Copy your Google Sheets table into Google Docs

If you want to insert Google Sheets into Google Docs, the best way to do this is to copy your Google Sheets table into Google Docs. 

How to make a Google Docs spreadsheet?

To insert Google Sheets into Google Docs, you have to first learn how to make a Google Docs spreadsheet.

There are 3 ways you can use to create a new spreadsheet in Google Sheets.

  1. Open your Google Drive and click the red “NEW” button Google Drive dashboard and select “Google Sheets”
  2. Open Google Sheets and from the homepage, click “Blank” or select a template on the Google Sheets homepage.
  3. Open Google Sheets and from the menu from within a spreadsheet and select “File > New Spreadsheet”

How to insert Google Sheets into Google Docs – Using the “copy” option 

To start with, create a table in Google Sheets first. You can lay out your data and numbers in Google Sheet and then copy them into your Google Docs. 

To insert Google Sheets into Google Docs by just copying the table, follow the below steps.

Step 1: Open Google sheets and sign in to your account. Open a spreadsheet in Google Sheets.

Step 2: Select the cells with source data you want to insert into Google Docs. 

Step 3: At the top of the screen, click Edit > Copy or simply press Ctrl + C.

Step 4: Now, on your computer, open your Google Docs app in another tab and open a new document.

Step 5: Choose where you want to insert Google Sheets into Google Docs and then click on that place.

Step 6: To insert Google sheets into Google Docs, click Edit > Paste. From the options “Link to spreadsheet” and “Paste unlinked”, choose the option you want to. Now click “Paste”

Advantage of using the “copy” option to insert Google sheets into Google Docs

Using this simple way, you can paste any table of your Google Sheets into Google Docs easily. In both ways – “Link to spreadsheet” and “Paste unlinked”, you’ll get the final values from your spreadsheets, along with much of their formatting. 

The “Link to spreadsheet” option gives you an additional benefit of instant updates of values. Whenever you update Google Sheets, just by clicking the “Update button” in the top right corner of your table, you can update the changes in the Google Docs document also. “

The “Link to spreadsheet” option offers you the flexibility to fetch the latest data and formatting from Google Sheets and update your table in the Google Docs document. 

Disadvantages of using the “copy” option to insert Google sheets into Google Docs

But one drawback with this method is, images and formulas won’t copy over. Your pasted values from Google Sheets are now a standard Google Docs table. To these Google Sheets tables, you can add any text formatting, add or remove columns and rows, and add the cell borders you want.

Note: This method only works when both the Google Sheets and Google Docs documents are in the same Google account or have been shared with full access. You can see a “Table dialog box” if you try to copy data from Google Sheets from one account into Google Docs from some other account. This will simply paste the data from Google sheets as regular unlinked data.

How to insert Google sheets into Google Docs using “Chart”

You can insert Google sheets’ charts into Google Docs. To do this, follow the below steps.

Step 1: Open Google Sheets and create a spreadsheet.

Step 2: Select any cell or bunch of cells. Navigate to the main menu mar and click Insert > Chart.

Step 3: Select the desired chart from the different chart types.

Step 4: Click “Customization” for formatting options like switching what appears in the rows and columns or other kinds of graphs.

Step 5: Now click Insert.

Step 6: Now open Google Docs and click Insert > Chart > From Sheets. Now choose the spreadsheet that contains your chart.

In this way, you can insert Google sheets into Google Docs. You can now resize the chart in Google sheets right inside your Google Docs document. You can make the changes in the Google Sheets spreadsheet and with just one click on the button “Update”, changes can be updated in Google Docs.

How to insert Google sheets into Google Docs using the “Import” option?

To insert Google sheets into Google Docs using the “Import” option, you have to first export (download) the Google Sheets document and save it either on your computer or Google Drive and then import this document into Google Docs.

Here are the steps on how to do this.

Step 1. Open Google Sheets and sign in to your account.

Step 2. In the document, you want to export, click File > Download.

Step 3:  Google Sheets usually supports the following formats: Xls, xlsx, xlsm, xlt, xltx, xltm, ods, CSV, txt, tsv, tab, and HTML. From these options, choose the download format that is compatible with Google Docs which is a web page (.html, zipped).  

Step 4. When you download the Google Sheets document in Web page format, you get the file in the (.zip) file. 

Step 5. Unzip the file and then import the files to Google Docs. To do so, open Google Docs and click “Upload” > “Select” and choose the Google Sheets file from your device.

In this way, you can import Google Sheets into Google Docs documents.

You may also like following the below articles

Voila! You’ve just learned various ways to insert Google Sheets into Google Docs! Try it yourself and create the magic of numbers in words!