How to add sheet in Google Sheets

How to Insert a Google Sheets Spreadsheet into Google Docs

• Brady Gavin

  @bradyjgavin

Sometimes, you want to add data from a Google Sheet into a Google Doc or Slide.Although you cant directly insert cells and rows from Sheets, you can create a table, chart, or slide, and then insert that into your Doc or Slide.

Note:We will be using Google Docs in these examples but inserting a chart into Slides works virtually the same way.

First, youll need to generate a chart in your Google Sheets spreadsheet. You can do this by firing up yourGoogle Sheetshomepage and opening a new or existing spreadsheet.

After inputting some data and storing it in a spreadsheet, select all the cells and click Insert > Chart. Choose a chart type, make any adjustments, and do any final customizations, then close Sheetsdont worry, Google saves after every step. Weve got an article about generating charts in Sheets if you want to learn more.

After youve created a chart in Google Sheets, fire up Google Docs and open a new or existing document to insert your chart. Click Insert, point to Chart, and then click on From Sheets.

From the list of available spreadsheets, select the one you want to use and then click Select.

The next window lists any charts on that sheet that are available for import. Click one and then click Import.

You also have another option here. See that Link to Spreadsheet checkbox in the screenshot above? If you enable it, the chart in your Doc or Slide is linked to the original chart in your Sheet. Make changes on your sheet, and youll see the chart in your Doc or Slide automatically updated to reflect those changes. Disable that checkbox if you dont want that to happen; in that case, the chart is sort of frozen in time in your slide or sheet. If you want to update it, youll need to reinsert it.

If you do leave the link option enabled, at any time, you can click Update to sync the data in the chart or table with your Sheets document.

Becausethese charts saveas images, one funny quirk when using the insert feature is that if the original isnt scaled or appropriately sized to see all data, some data points could become cut-off when updating it.

Voila! Your Google Sheets data is now inserted into your Google Doc.

If for some reason you dont like your chart updating and linking to your Sheets document anymore, click a chart, then click on the chain icon, then again on Unlink to remove the linking feature.

RELATED: How to Use Google Docs Offline

This disables the ability to make changes on Sheets and have them automatically appear inside your document without re-inserting it. If you want an updated chart or want to establish the link again, you have to repeat the steps from above all over again.