Google Sheets and Docs are popular tools for recording and storing data in various formats. While Google Docs maintains data in text, Google Sheets uses tables, charts, and spreadsheets for the purpose. People often find incorporating Google Sheets into Google Docs challenging, but it is possible through simple steps.
The section below details how to embed Google Sheets in Google Docs for better data storage and presentation.
How to Embed Google Sheets in Google Docs?
Step 1
Go to Google Sheets and find the spreadsheet to be inserted.
Step 2
Select the range you need to insert into the Google Docs. Click Ctrl+C to copy the data. You can also right-click on the selected range to reveal the copy option.
Step 3
Open the required Google Doc.
Step 4
Right-click or click Ctrl+V on the required space to insert the required spreadsheet information. On copying, a dialog box appears asking permission to link the Doc to the original spreadsheet.
Step 5
The selected Google Sheet will appear on the Google Doc when clicking the Paste option.
The embedded Google Sheet in the Google Doc is now linked to the original sheet, and you can make any changes in the original sheet and reflect them here in the Docs. But the changes won’t be created automatically when the original sheet is updated. You have to click on the Update option that only appears in Google Docs when you change the original spreadsheet.