Google Docs and Google Sheets are incredibly handy for teamwork and getting things done. Docs is great for writing and editing, while Sheets is a powerhouse for managing data. Sometimes, you need to combine the two, like when you want to include a spreadsheet in a report. Linking them means updates in the sheet automatically show up in the doc. Here’s how to do it.
Inserting a Google Sheet into Google Docs
-
Open the Google Sheet with the data you want to use. Select all the data by pressing
Ctrl + A.
-
Copy the data. Go to the ‘Edit’ menu, and choose ‘Copy.’
-
Now, go to your Google Doc. Click where you want to put the table, then go to the ‘Edit’ menu and click ‘Paste.’
-
You’ll get a box asking how you want to paste. ‘Link to spreadsheet’ should be selected by default, which is what you want to keep the data synced. Then, click ‘Paste’.
The spreadsheet is now a table in your doc, and it’s linked to the original sheet.
Updating the Table in Google Docs
If you change your Google Sheet, here’s how to update your doc.
-
Make your changes in the Google Sheet. For example, add a new row of info.
-
Open the Google Doc. You will see an ‘Update’ button above the table. Click it to refresh the table with the new sheet data.
The table in your document will update. Note that new rows or columns outside of the original range might not show up right away.
Changing the Table Range
To include extra rows or columns, adjust the linked table’s range.
-
In the Google Doc, click the down arrow next to the ‘Linked table options’ button above the table, then select ‘Change range.’
-
A box will show the current range. Edit the range to include the new data. For example, if it was ‘A1:E11’ and you added row 12, change it to ‘A1:E12.’ Click ‘OK’.
-
After that, click the ‘Update’ button above the table. It will now show the new rows or columns from the sheet.
