قالب وردپرس درنا توس
Home / Tips and Tricks / How to insert a Google Spreadsheet in Google Docs

How to insert a Google Spreadsheet in Google Docs



  Google Docs, Sheets, and Slides logos

Sometimes you want to paste data from a Google Sheet into a Google Doc or slide. While you can not insert cells and rows directly from sheets, you can create a table, chart, or slide and then paste them into your document or slide.

Note: We'll use Google Docs in these documents for examples, but inserting a diagram into Slides works the same way.

First, you'll need to create a chart in your Google Sheets spreadsheet. You can do this by launching the Google Sheets home page and opening a new or existing spreadsheet.

After you have entered some data and saved it in a table, select all cells and click Insert> Diagram. Select a chart type, make adjustments, and make the final adjustments. Then close the leaves. Do not worry, Google saves after every step. We have an article on creating charts in Sheets for more information.

 Open a spreadsheet

After you create a chart in Google Sheets, launch Google Docs and open it. A new or existing document to insert your chart. Click "Paste," point to "Chart," and then click "From Sheets."

 Insert a chart from Google Sheets

Select the table you want from the list of available tables Click Select.

 Select a spreadsheet

The next window lists all the charts on this worksheet that are available for import. Click on one and then on "Import".

 Select a chart to insert

You also have another option here. See the "Link to Table" checkbox in the screenshot above? If you enable it, the chart in your document or slide will be linked to the original chart in your sheet. Make changes to your worksheet. The chart in your document or slide is automatically updated to reflect these changes. Uncheck this box if you do not want this. In this case, the chart will be frozen on your slide or sheet. If you want to update it, you must reinsert it.

If you leave the Link option turned on, you can click Refresh at any time to synchronize the data in the chart or spreadsheet with your Sheets document

 Refresh the chart [19659005] Since these diagrams are saved as images, the use of the paste function is a funny feature: if the original is not scaled or resized, all data and some data will be displayed. Points could be truncated when refreshing.

 Example of a cut-off text

Voila! Your Google Sheets data will now be included in your Google Doc.

 Pasting the Chart Completed

If, for some reason, you no longer like updating your chart and linking it to your sheet-based document, click a chart, then click the chain icon and then again on "Unlink" to remove the link function.

RELATED: Offline use of Google Docs

 Unlink a Chart from Sheets

This disables the ability to make changes to sheets automatically in your Document without having to reinsert it. If you want an updated chart or want to reconnect, repeat the steps from the top.


Source link