How to Insert Google Sheet into Google Doc? 3 Easy Ways

If you're creating a professional report in Google Docs, chances are you've already sorted a large amount of data in a spreadsheet. Now, if only you could insert all that data in your report without spending hours recreating tables and charts again.

Fortunately, it's possible! You can embed all your spreadsheet data directly in Docs, as interactive tables, charts, and even static images. In this guide, I will show you exactly how. You will learn how to insert Google Sheet into Google Doc in three easy ways. By the end, you will be able to handle your data and create polished documents more easily.

Part 1. How to Copy and Paste Google Sheets into Google Docs

If you want to insert tables from your spreadsheet into Google Docs, you can use the copy and paste method. This also gives you the flexibility to link the table with the original spreadsheet data. So, if you ever modify or expand the data in the spreadsheet, you can refresh the table in Docs to include the latest values and cell range.

Here’s how to embed Google Sheet into Google Doc.

Steps to Copy and Paste Google Sheets into Google Docs

Step 1. Open the Google Sheet you want to copy from. Select the desired data. Then, click “CTRL + C” on Windows or “CMD + C” on Mac to copy it. Alternatively, go to “Edit” and select “Copy.”

Step 2. Go to the Google Docs website and open the file where you need to add the data. Then, click “Edit” from the top left and choose “Paste.” Otherwise, click “CTRL + V” on Windows or “CMD + V” on Mac.

Step 3. A pop-up will appear on your screen. From here, you will see two options:

• Select the “Link to Spreadsheet” option. This will connect data to the original sheet. As a result, changes to the sheet will also update the data in Docs.
• Choose “Paste Unlinked” if you simply want to keep the data without linking it. This way, you cannot update it if the original data in the sheet is ever modified.

Step 4. Once you've selected an option, click “Paste” to add data to Google Docs.

If you choose to link the table to the spreadsheet, you can use the following steps to update data or cell range.

Also Read: How to Make Google Docs Dark Mode? (Beginners Guide)

Steps to Update the Data Table in Google Docs

Step 1. With your Docs file open, click on any cell in the table. A floating toolbar will appear. From here, click the “Update” option.

Step 2. Your table will be highlighted in blue and updated automatically.

Steps to Change the Data Range in Your Table

Step 1. Click any cell of the table in your Docs file. Click the three vertical dots labeled “Linked table options” in the floating toolbar. Then, select “Change range.”

Step 3. Click the box with the cell range. Type the new range manually and click “OK.” For example, if the range was A1:E5 before, after adding four new rows, it will be A1:E9.

Step 4. Google Docs will automatically add the new rows with updated data into the table.

Also Read: How to Copy an Image from a Google Doc?

Part 2. How to Insert a Google Sheet into a Google Doc?

Copy-pasting is perfect for tabular data. But what if you need to insert a visual representation of your data into Docs? Google Docs has a dedicated feature that lets you insert data charts directly from Google Sheets.

This method is excellent for reports and presentations, which usually require visual data. Also, just like tables, you can link the charts directly to the source spreadsheet. This makes it easy to update its content and data range if needed.

Here’s how to insert a Google Sheet into a Google Doc using this method.

Step 1. Open your Google Docs file. Click “Insert” from the top left and select “Chart > From Sheets.”

Step 2. Select the spreadsheet with the data chart. Then, click “Insert.”

Step 3. A pop-up will appear. From here, select the chart you need. If you want to update it later, make sure to select “Link to spreadsheet.” Then, click “Import.”

Step 4. Your chart will be added to your Google Docs file, ready for updates when needed.

Steps to Update the Google Sheets Chart in Google Docs

Step 1. Open the Docs file and click on your chart. Click “Update” from the floating toolbar.

Step 2. Google Docs will automatically update the chart's data or style as needed.

Steps to Change the Chart’s Data Range in Google Docs

Step 1. If you’ve changed the chart's data range, you can update it in Docs as well. To do this, click on the chart in Docs.

Step 2. Click the “Update” option in the floating toolbar.

Step 3. Google Docs will automatically update the chart range to include additional data.

Part 3. How to Insert a Google Sheet Image into Google Doc?

If you only need to display data visually without keeping it editable or linked, the easiest way is to insert Google Sheet into Google Doc as an image. To do this, you can take a snapshot of your spreadsheet and add it to Google Docs.

Here's how it's done.

Step 1. Open the desired spreadsheet. Then, access your computer’s built-in screenshot tool:

• Press "Shift + Windows + S" to open the Snipping Tool on Windows.
• For Mac, press “Command + Shift + 4” to capture a specific area.

Step 2. Drag your cursor over the area you want to capture. Once you release the cursor, the screenshot will be copied to your clipboard. For Mac, it will be saved on the Desktop.

Step 3. Open the Docs file. Click “CTRL+V” to paste the screenshot into your desired area. On Mac, go to "Insert > Image > Upload from Computer." Then select the screenshot to add to Docs.

Part 4. Bonus Tip: The Best PDF Editor or Reader - UPDF

Google Sheets and Docs are great tools for online work. However, there are times when you need to download your files as PDFs or insert spreadsheets into a PDF document. In these situations, a reliable PDF editor makes handling these files much easier.

UPDF is one of the best tools for this. It is an advanced PDF reader and editor that helps you handle all elements of your documents effortlessly. You can even attach spreadsheets directly within your PDFs for seamless access and sharing. So, go ahead. Download and try it now!

Why Should You Choose UPDF?

1. A Complete PDF Solution: It packs all the PDF tools to edit, annotate, and manage your documents.
2. Effortless to Use: It has a neat and minimal interface. You don’t need any technical steps to navigate or use its tools..
3. Available on All Platforms: It supports Windows, Mac, iOS, and Android. So, you can access it anytime on any device.
4. Easy to Access: You can try UPDF for free. If you want to upgrade, it offers affordable price plans. Plus, you can use a single license on all platforms. If you’re ready to get started, click here to purchase UPDF Pro.

Key Features that Make UPDF Stand Out

1. Convert Word, Excel, PowerPoint, images, and other formats to/from PDF.
2. Insert Google Sheets, Docs, and other file types within PDF.
3. Edit PDF text, images, links, pages, watermarks, backgrounds, and more.
4. Annotate with text boxes, callouts, stickers, stamps, highlights, and more.
5. Use OCR to make scanned and image-based PDFs editable and searchable.
6. Built-in AI assistant to summarize, translate, explain text, create mindmaps, etc.
7. Batch-process files for OCR, compression, encryption, printing, and more.

These features are just a glance at what UPDF can do. There’s a whole package of PDF tools you can use to work smarter and handle documents more professionally. If you’re ready to get more familiar with it, read this UPDF review by Apple Insider. Or, watch the video below to learn more about it.

Final Words

That’s all about how to insert Google Sheet into Google Doc. You can add both tables and charts directly from Sheets. You can also update the data or adjust the cell range to keep your content up to date. You can even add a spreadsheet as a static image.

And if you also manage PDFs alongside Docs, UPDF can help you manage your documents more productively. Plus, you can test all its features for free. Download it now to get started.