How to Make a Table in Google Sheets and Use It

To make a table in Google Sheets, select your range including the header row, then choose Format, then Convert to table. What that does is more interesting than how it looks, because a Google Sheets table is not a formatting style.

It converts a plain range into a defined object with a name, typed columns, and a boundary Sheets understands, which changes how formulas refer to it and what happens when you add rows. 

The formatting is the visible part and the least important. This covers how to convert a range, how to set column types properly, how table references work, and how to get back to a plain range if you decide you do not want it.

How to convert a range into a table

1. Select the range you want, including the header row.
2. On the menu bar, select Format, then Convert to table.

Sheets applies formatting immediately: header styling, alternating row shading, alignment based on the content, and a filter control on each column header.

One thing to check before you convert: the top row should contain your column headers rather than data, because Sheets uses that row for the column names you will reference later. The range you select is the range that becomes the table, whether it already holds data or not.

How to set column types

This is the part that does the real work and the part most people skip.

Each column can be assigned a type: text, number, date, currency, percent, dropdown, and others. Once a column has a type, Sheets validates what goes into it and warns you when an entry does not fit.

To set or change one, select the dropdown next to a column header, then choose Edit column type.

Why it matters: a column typed as Date will flag a text entry that looks like a date but is not one, which is the single most common way a spreadsheet quietly breaks. On a sheet several people update, this catches the problem at entry rather than three weeks later in a formula.

For some types, Sheets adds placeholder chips in empty cells to make entry easier. If you find those intrusive, they can be turned off from the same column menu.

How to name a table, and why the name matters

Every table gets a name, and you should replace the default with something meaningful, because you will be typing it into formulas.

Select the arrow next to the table name at the top left of the table to open the table menu, where you can rename it.

Google publishes specific rules for these names. A table name cannot be TRUE or FALSE, cannot use cell-reference syntax such as A1 or R1C1, cannot begin with a number, cannot run past 255 characters, and cannot contain special characters other than underscores. It also cannot duplicate an existing table name. Spaces are allowed in the name itself but become underscores when you use it in a formula, so Sales Tracker is written Sales_Tracker in a reference.

How table references work

This is the practical payoff. Instead of referring to a fixed range like B2:B40, you refer to the table and column by name.

A reference looks like this:

=SUM(Sales_Tracker[Amount])

That sums the Amount column of the Sales_Tracker table. The advantage is that the reference is defined by the table rather than by row numbers, so when you add rows to the table, the formula covers them without being edited.

This is the main reason to convert a range that grows over time. A running total built on B2:B40 silently stops including new data at row 41. A table reference does not.

Turning on formula suggestions helps here, since Sheets will complete table and column names as you type. That setting sits under Tools, then the suggestion controls.

Group and filter without disturbing anyone else

Tables come with view controls that solve a specific annoyance on shared sheets.

From the table menu you can create a group by view, which aggregates rows by the values in a column, and filter views that show a subset. These can be saved and switched between, so you can look at the data the way you need to without changing what a colleague sees.

That is the difference from applying an ordinary filter to a range, which changes the view for everyone with the sheet open.

How to convert a table back to a plain range

Worth knowing before you convert anything, because the wrong menu option here is destructive.

Open the table menu using the arrow next to the table name and choose the option to revert to unformatted data. That removes the table structure and returns your data to an ordinary range.

Do not use the delete option in that menu if you want to keep your data. Deleting the table deletes the underlying rows with it. The revert option is the one that keeps the content and removes only the structure.

When a table is not worth it

Tables suit data that is genuinely tabular and grows: a list of transactions, a project tracker, an inventory. They are a poor fit in two cases.

A calculation layout rather than a list. A model with labels down the left and figures across the top is not a table, and forcing it into one fights the structure.

Data with merged cells or multi-row headers. Tables assume one header row and one record per row. If your layout does not match that, clean it up first or leave it as a range.

A note on features that arrive quietly

Tables appeared in Sheets without most people noticing, which is normal now: Google and Microsoft both ship features continuously, and the guide you find online was often written before the thing you are looking at existed. Guidy reads the window on your screen and points at the actual menu item in front of you, rather than describing an interface from an earlier version. Our AI assistant for work page covers how that applies across Sheets, Outlook, and the rest of a working day.

Key takeaways

• Select the range including headers, then Format > Convert to table. Formatting is applied automatically.
• Set a column type on every column. Typed columns validate entries and warn on mismatches, which is the main practical benefit.
• Give the table a meaningful, unique name, and follow Google's naming rules: no TRUE or FALSE, no cell-reference syntax, no leading number, and underscores as the only special character.
• Table references such as =SUM(Sales_Tracker[Amount]) expand automatically as rows are added, unlike fixed ranges.
• To undo a table, use the revert to unformatted data option. The delete option removes the data as well as the structure, so knowing how to make a table in Google Sheets is worth less than knowing how to unmake one safely.

FAQs

What is the difference between a table and a formatted range in Google Sheets?

Formatting changes appearance only. A table changes structure: it has a name, defined boundaries, typed columns that validate entries, and references that expand as data is added. A range styled to look like a table has none of those properties, which is why formulas over it break when the data grows.

Do table references work in every formula?

They work in ordinary formulas the same way a range does, so SUM, COUNTIF, FILTER, and the rest accept them. The syntax is the table name followed by the column name in square brackets, and spaces in names become underscores. If a reference is not recognized, check the table name against the one in the table menu, since the default name is easy to leave unchanged.

Can I have more than one table on the same sheet?

Yes, and it is common to. Each table needs its own name, and the names have to be unique within the document, so rename them to something meaningful rather than leaving the defaults. Give each one its own selected range when you convert, and keep them visually separated so the sheet stays readable.

Do I need data in the range before I make it a table?

No. Sheets accepts either an empty selection or one that already holds data, so you can build the structure first and set your column types before anything is entered. On a sheet several people will fill in, that is often the better order, because the column types then catch bad entries from the first row onward.

Do tables slow down a large Google Sheet?

Not meaningfully in normal use. What does slow a sheet down is volume of data and heavy volatile formulas, and those are the same whether or not the range is a table. If a sheet is already struggling, converting to a table will not fix it and will not make it noticeably worse.