In this tutorial, you will learn how to make a spreadsheet on Google Docs.
How To Make A Spreadsheet On Google Docs
Google Docs is a powerful online document editor but you may not realize it has the ability to display tabular data like Google Sheets. This can be useful for anyone who needs to integrate a table into their document.
Users who want to copy data over from Google Sheets have the option to create linked objects, these are tables that can pull data from a specific spreadsheet. Using linked objects, you’ll be able to create a Google Docs table with updated data from a specified spreadsheet.
In this guide, we will show you how to make a spreadsheet on Google Docs. We will explain how to create a simple table as well as linked tables that actually connect to an existing Google Sheets spreadsheet.
How to Add a Spreadsheet from Google Docs
Here’s our step-by-step guide on how to add a spreadsheet from Google Docs.
Step 1
First, open the document you want to add a spreadsheet to.
One way to add a spreadsheet to a Google Docs document is through inserting a table. We can add a table by selecting the options Insert > Table and using the provided grid to create a table with our desired number of rows and columns.
In this example, we’ve added a table in our document with three rows and four columns.
Step 2
We can also add a spreadsheet to Google Docs from Google Sheets.
To do this, open a spreadsheet and select the range of cells you want to add to your document. In our example above, we want to add the range A1:D3.
Step 3
Open a Google Docs document and place your cursor where you want to add your table.
Paste the data in your clipboard using the Ctrl+V keyboard shortcut. You will be asked whether you want the pasted data to be linked to the original spreadsheet. If you want the data in Google Docs to stay updated, select this option and click Paste.
Step 4
We can manually update the spreadsheet data by selecting the table and clicking the Linked objects option from the dropdown menu accessible from the Link icon.
In the Linked objects panel, find your data and click the Update option.
Step 5
If you’ve clicked the Paste unlinked option, your data will not be able to update when changes are made in the spreadsheet.
Summary
This guide should be everything you need to learn how to make a spreadsheet in Google Docs.
Click this link to make a copy of this sample document to try doing it yourself!