Linking Sheets with Docs in Google Sheets - Step-by-Step Guide

Introduction

Linking Sheets with Docs lets you show data from your spreadsheet inside a Google Doc. This helps keep your document updated automatically when the spreadsheet changes.

When you want to include a sales report table from Sheets into a meeting notes Doc.

When you need to show updated project timelines from Sheets inside a project plan Doc.

When you want to share budget numbers from Sheets in a proposal Doc without copying manually.

When you want to create a report Doc that always shows the latest data from your spreadsheet.

When you want to avoid errors from copying and pasting data between Sheets and Docs.

Steps

Step 1: Open

- Google Sheets file with your data

Your spreadsheet data is visible on screen

Step 2: Select

- the cells you want to link

Cells are highlighted

Step 3: Copy

- the selected cells (Ctrl+C or Command+C)

Cells copied to clipboard

Step 4: Open

- Google Docs file where you want to insert data

Your document is open and ready for editing

Step 5: Place cursor

- in the document where you want the table

Cursor blinks at the insertion point

Step 6: Paste

- the copied cells (Ctrl+V or Command+V)

A table appears in the Doc with a small link icon at top right

💡 The link icon means the table is connected to the spreadsheet

Step 7: Click

- the link icon on the table

Options to update or unlink the table appear

Before vs After

Before

Google Doc has no table or outdated data copied manually from Sheets

After

Google Doc shows a table linked to Sheets data with a link icon for updates

Settings Reference

Link to spreadsheet

📍 When pasting data into Google Docs

Keeps the table connected so updates in Sheets can be reflected in Docs

Default: Link to spreadsheet

Update linked table

📍 Link icon menu on the pasted table in Docs

Refreshes the table in Docs with the latest data from Sheets

Default: Update

Common Mistakes

Pasting data without linking to spreadsheet

The table will not update when the spreadsheet changes

Choose 'Link to spreadsheet' option when pasting to keep data connected

Not clicking 'Update' on the link icon after changing data in Sheets

The Doc still shows old data until manually refreshed

Click the link icon and select 'Update' to refresh the table with new data

Summary

Linking Sheets with Docs lets you insert live tables from spreadsheets into documents.

This keeps your Docs updated automatically when spreadsheet data changes.

Remember to choose 'Link to spreadsheet' when pasting and click 'Update' to refresh.