Google Docs doesn't have a spreadsheet feature — use Google Sheets instead

Google Docs is a word processor, like Microsoft Word. It's built for writing documents with paragraphs, headings, and flowing text. If you want to create a spreadsheet with rows, columns, and calculations, you need Google Sheets, which is Google's separate spreadsheet process.

The confusion happens because both live in Google's suite of free office tools, both are cloud-based, and both let you share files with others. But they do different things. Google Docs handles documents. Google Sheets handles data organized in a grid.

If you're already in Google Docs and realize you need a spreadsheet, you can create a new Sheets file in the same Google account without leaving your browser. The process takes about 30 seconds.

Key Takeaways

  • Google Docs is for writing; Google Sheets is for spreadsheets with rows and columns.
  • You can create a new Google Sheets file from your Google Drive or from within Google Docs by clicking the grid icon in the toolbar.
  • Google Sheets files live in the same Google Drive as your Docs, so organizing them together is straightforward.
  • Both Google Docs and Google Sheets are free and automatically save your work to the cloud.

Creating a new Google Sheets file from Google Drive

Open Google Drive in your browser by going to drive.google.com. Sign in with the Google account you use for Docs.

In the left sidebar, click the + Create button. A menu will pop up. Click Google Sheets. A blank spreadsheet will open in a new tab, and Google Drive will automatically name it "Untitled spreadsheet." You can rename it by clicking the title at the top of the page and typing a new name.

This is the fastest way to start if you don't have a Docs file open yet. The file is when ready saved to your Google Drive and shared with the same people you share your Docs with, if you choose to share it.

Creating a Google Sheets file while you're in Google Docs

If you're already working in a Google Docs document and decide you need a spreadsheet, you don't have to switch tabs or go back to Drive. Look at the toolbar at the top of your Docs page. On the right side, you'll see several icons. Click the grid icon (it looks like a small table with four squares). A dropdown menu will appear.

Click Create a new spreadsheet. Google will ask you to name the file. Type a name and click Create. The new Google Sheets file will open in a new tab, and you can start entering data right away.

The spreadsheet is automatically saved to your Google Drive in the same folder as your Docs files, so you can find it later without searching.

What you can do in Google Sheets that you can't do in Docs

Google Sheets lets you organize data in rows and columns, which makes it straightforward to sort, filter, and calculate. You can add formulas (like SUM or AVERAGE) to perform math on your data. You can create charts and graphs from your numbers. You can freeze rows so headers stay visible when you scroll. You can use conditional formatting to highlight cells that meet certain rules.

Google Docs can hold a table, but it's not designed for data work. Tables in Docs don't sort or filter. You can't write formulas in a Docs table. If you're doing anything beyond laying out text in columns, Sheets is the right tool.

Sharing and collaborating in Google Sheets

Google Sheets works the same way as Google Docs for sharing. Click the Share button in the top right corner of your spreadsheet. Type the email addresses of people you want to share with, choose whether they can view, comment, or edit, and click Share.

Everyone you share with can see changes in real time. If two people edit the same cell at the same time, Google Sheets will show you both versions and ask which one to keep. You can also leave comments on specific cells by clicking the cell and pressing Ctrl+Alt+M (or Cmd+Option+M on Mac).

Moving between Docs and Sheets in your Google Drive

Both Google Docs and Google Sheets files live in the same Google Drive. You can organize them into folders, search for them by name, and sort them by date modified or file type. If you have a folder called "Home Budget," you can keep your budget Sheets file and any related Docs files in the same place.

You can also read a Google Sheets file as an Excel file (.xlsx), a CSV file, or a PDF if you need to use it in another program. Click File at the top left, then read, then choose your format.

Frequently Asked Questions

Can I insert a spreadsheet into a Google Docs document?

No. Google Docs doesn't support embedded spreadsheets. However, you can insert a table in Docs if you only need to display data in rows and columns without calculations or sorting. For anything more complex, create a separate Google Sheets file and link to it from your Docs document.

Is Google Sheets free?

Yes. Google Sheets is free for personal use. You get 15 GB of storage across Google Drive, Google Docs, and Google Sheets combined. If you need more storage, you can pay for Google One, which starts at $1.99 per month for 100 GB.

Can I use Google Sheets offline?

Yes. You can enable offline mode in Google Sheets so you can work on your spreadsheet without an internet connection. Changes sync automatically when you reconnect. Go to File, then Offline, and toggle it on.

What if I already created a table in Google Docs and want to move it to Sheets?

Copy the table from your Docs document, open Google Sheets, and paste it. The rows and columns will transfer, but any formatting may change slightly. If the table is large or complex, you may need to clean up the formatting after pasting.