How to Create a Table in Google Docs When You Need a Simple Spreadsheet

Google Docs tables work for basic data, but they are not spreadsheets

Google Docs does not have a spreadsheet feature. What it does have is tables — boxes that hold rows and columns of information. A table in Google Docs looks like a spreadsheet on the surface, but it cannot do math, sort data, or create charts. If you need those things, you should use Google Sheets instead. If you only need to display information in rows and columns — like a price list, a schedule, or a comparison of options — a table in Google Docs will work.

The confusion happens because both tools show data in grids. The difference matters: a spreadsheet calculates and reorganizes; a table just displays. This guide covers how to build a table in Google Docs for the cases where that is what you actually need.

Key Takeaways

Google Docs tables are for displaying information in rows and columns, not for calculations or sorting.
Insert a table by opening the Insert menu, selecting Table, and choosing how many rows and columns you need.
You can add or delete rows and columns after creating the table by right-clicking inside it.
If you need to add numbers, sort data, or create charts, use Google Sheets instead of a table in Docs.
Tables in Google Docs work well for schedules, price lists, comparison charts, and other static information displays.

Insert a table into your Google Doc

Open the Google Doc where you want the table. Click the Insert menu at the top of the page. A dropdown list appears. Click Table. A grid appears showing options from 1 to 10 columns and 1 to 10 rows. Click the square that represents the size you want — for example, clicking the square at 3 columns and 4 rows creates a table with 3 columns and 4 rows.

The table appears in your document when ready. Your cursor is in the first cell (top left). You can start typing right away. Press Tab to move to the next cell to the right. Press Enter to move down to the next row in the same column.

Add or remove rows and columns

You do not have to get the size exactly right when you create the table. Right-click anywhere inside the table. A menu appears with options to insert or delete rows and columns. Click Insert 1 above to add a row above the cell you clicked. Click Insert 1 below to add a row below. Click Insert 1 left to add a column to the left, or Insert 1 right to add a column to the right.

To remove a row or column, right-click inside it and select Delete row or Delete column. You can also select multiple rows or columns before right-clicking if you want to delete more than one at once. Click inside the first row or column you want to delete, then hold Shift and click the last one. Right-click and choose delete.

Format the table to make it readable

Select the entire table by clicking inside it and then pressing Ctrl+A (or Cmd+A on Mac). The whole table highlights. Now you can change the text size, color, or alignment for everything at once. You can also right-click inside the table and select Table properties to change the border color, background color, or cell padding (the space between text and the cell edge).

To format only certain cells, select them first. Click inside a cell and drag to select multiple cells, or click one cell, hold Shift, and click another to select a range. Then explore formatting — bold, italic, color, alignment — using the toolbar at the top of the page.

Header rows (the top row that labels each column) are easier to read if you make them bold or give them a background color. Right-click the first row, select Table properties, and change the background color. Then select the text in that row and make it bold.

Copy and paste data into a table

If you have data in another document or spreadsheet, you can copy it and paste it into a Google Docs table. Copy the data from its original location. Click inside the first cell of your table where you want the data to go. Press Ctrl+V (or Cmd+V on Mac) to paste. Google Docs will try to fit the data into the table structure you have. If the data does not fit perfectly, you may need to adjust the table size or rearrange the cells manually.

Pasting works best when the data you are copying is already organized in rows and columns. If you paste from a spreadsheet that has formulas or calculations, only the values (the numbers or text the formulas produced) will paste into the table — the formulas themselves do not transfer.

When to use Google Sheets instead

If your data needs to be sorted, filtered, or calculated, stop and use Google Sheets instead. Sheets is Google's actual spreadsheet tool. It handles math, lets you rearrange rows by clicking a column header, and creates charts automatically. A table in Google Docs cannot do any of these things.

Use a table in Google Docs when you have static information that does not change — a class schedule, a menu, a list of team members with their contact details, a price comparison. Use Google Sheets when the information is active — sales numbers that need totaling, a budget with formulas, a list you need to sort by date or name, or data you want to visualize in a chart.

Delete a table or start over

To remove an entire table from your document, click inside it and then right-click. Select Delete table. The table disappears and the text before and after it closes together. If you want to keep the data but remove the table structure, select all the text in the table (Ctrl+A while inside the table), copy it, delete the table, and paste the text as plain text into your document.

There is no undo limit in Google Docs, so if you delete something by mistake, press Ctrl+Z (or Cmd+Z on Mac) to undo. You can undo many steps back if needed.

Frequently Asked Questions

Can I do math in a Google Docs table?

No. Tables in Google Docs display information only. If you need to add numbers, calculate totals, or use formulas, use Google Sheets instead. Sheets is designed for calculations and data analysis.

How do I sort a table in Google Docs?

You cannot sort a table in Google Docs. If you need to rearrange rows by sorting a column, copy the data into Google Sheets, sort it there, and then copy it back to Docs if you want it in a document.

Can I merge cells in a Google Docs table?

Yes. Select the cells you want to merge by clicking and dragging across them. Right-click and select Merge cells. The cells combine into one larger cell. You can unmerge them later by right-clicking and selecting Unmerge.

What if I need to move a table to a different part of my document?

Click inside the table, then press Ctrl+A to select the entire table. Press Ctrl+X to cut it. Click where you want it to go and press Ctrl+V to paste. The table moves to the new location.

Can I import data from an Excel file into a Google Docs table?

You can copy data from an Excel file and paste it into a Google Docs table, but the table will not preserve Excel formulas or formatting. For complex Excel files, upload the file to Google Drive and open it with Google Sheets instead, which handles Excel data better.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.