How-To

How to Insert Google Sheets into Google Docs

By Ben Stockton

Published April 13, 2023

Want to include data from your Google Sheets spreadsheet in your Google Docs document? Follow this guide to get started.

You’ve got Google Sheets data you want to share in a Google Docs document. This isn’t an unusual issue—you might want to present some of your data in a report, for instance.

But how do you go about doing it? It’s not a straightforward process, but sharing your Sheets data in a Docs document is possible, either by linking or inserting the data directly.

Looking to insert Google Sheets in Google Docs? Here’s what you need to do.

How to Copy and Paste Google Sheets Data into Google Docs

The simplest way to insert Google Sheets into Google Docs is to copy and paste the data. This method lets you quickly transfer your data as a table that you can move, edit, and format accordingly.

Depending on how you want your document to work, you can maintain the link between your Sheets and Docs documents, too. However, you can also choose to paste the data as a one-time-only copy so that the link between the two apps is broken.

To copy and paste data from Google Sheets into Google Docs:

1. Open your Google Sheets spreadsheet and select the range of cells you want to insert.
2. Press Ctrl + C (or Command + C on Mac). Alternatively, right-click and choose Copy.
   
3. Next, open your Google Docs document and place the cursor where you want to insert the data.
4. Press Ctrl + V (or Command + V on Mac). Alternatively, right-click and select Paste.
   
5. You’ll be asked to choose how you want to paste the data. Choose between:
   1. Link to spreadsheet. This will maintain a data link with the original spreadsheet so that any changes to the data will be reflected in both the Google Sheets spreadsheet and the document.
   2. Paste unlinked. This will paste the data as it is now into your Google Docs document. Any changes in Google Sheets won’t be reflected afterward, however.
      

The data will appear as a table immediately in your document.

How to Link a Chart from Google Sheets into Google Docs

Another way to insert Google Sheets into Google Docs is to link the data as a chart. This method allows you to display your data visually using different charts, such as pie charts, bar charts, line charts, etc.

It also has some advantages. The chart will update automatically if you make changes in Google Sheets, and you can customize its appearance using various options.

To link a chart from Google Sheets into Google Docs:

1. Open your Google Sheets spreadsheet and create a chart using your data. You can do this by selecting your data range and going to Insert > Chart.
   
2. Adjust your chart settings according to your preferences. You can change the chart type, add titles and labels, modify colors and fonts, and more.
3. Next, open your Google Docs document and place the cursor where you want to insert the chart.
4. Go to Insert > Chart > From Sheets.
   
5. Select the spreadsheet that contains your chart and click Select.
6. Choose the chart that you want to import and click Import.
   

You can also edit or delete the chart after inserting it by clicking on it and using the toolbar options that pop up.

Writing Up Your Data With Google Docs

You can quickly insert your Google Sheets data into a Google Docs document using the steps above. This can help you present your data across different applications more efficiently.

Want to combine your data? You can merge tables in Google Docs to bring your datasets together. You could also think about other types of content, such as inserting videos into Google Docs.

Finished with your document? If you want to hand it over to a colleague or client, you can easily transfer ownership of a Google Docs document. Finally, you might want to consider how to format your Google Slides data further, such as changing number formats for your values to reflect your data better.