---
title: "Tables in Google Sheets: create, format and reference"
canonical: "https://www.owox.com/blog/articles/tables-feature-google-sheets"
updated: "2026-10-05"
---

# Tables in Google Sheets: how to create, format and reference them

A table in Google Sheets is a range that has been given a name, a header row with menus, a type for each column and a format. It grows when rows are added, and formulas can refer to its columns by name. This guide shows how to convert data to a table, what the column types and views do, how table references work, and when a plain range is the better choice.

[Google Sheets Tips](/blog/topics/google-sheets-tips) · Updated October 2, 2026 · [Vadym Kramarenko](/team/vadym-kramarenko) · 8 min read

![Tables in Google Sheets: how to create, format and reference them](https://cdn.owox.ai/www/webflow/6a19a52a5331089a657fdf27_USE-THE-GOOGLE-SHEET-TABLE-FEATURE.png/public)

A table in Google Sheets is a range with a name, a header row that carries menus, a type for each column and its own format. To make one, select the data and choose **Format > Convert to table**. The menu shows the keyboard shortcut next to the command, ⌘+Option+T on a Mac.

![Google Sheets with a table named Table1 holding campaign, channel, start date, cost and revenue columns, and a SUMIF formula in H5 that refers to the Channel and Revenue columns of the table by name and returns 13600](https://cdn.owox.ai/www/content-marketing-article/tables-feature-google-sheets/screens/2.png/public)

Three things change compared with a plain range:

*   **Structure.** Each column gets a type, such as number, date or dropdown, and Sheets warns about values that do not fit it.
*   **A name.** Formulas can refer to `Table1[Revenue]` instead of F3:F9.
*   **Growth.** A row typed directly under the table becomes part of it, and formulas that refer to the table include it.

Google added tables to Sheets in 2024.

## How to create a table

### From existing data

1.  Select the range, with its header row.
2.  Choose **Format > Convert to table**.
3.  Check the type that Sheets picked for each column.

In our test, a range of seven rows became Table1 at once: the header row turned dark green with a menu arrow in every column, the rows got alternating colours, and the date column was recognized as a date and marked with a calendar icon.

### From a pre-built table

**Insert > Pre-built tables** opens a side panel with ready structures for common tasks: project tasks, event planning, inventory, recruitment, content tracking and others. Each one inserts an empty table with typed columns and placeholder values.

![The Insert menu of Google Sheets with the items Generate a table and Pre-built tables under the Sheet item](https://cdn.owox.ai/www/content-marketing-article/tables-feature-google-sheets/screens/3.png/public)

![Google Sheets with the Tables side panel open on the Project management group and a preview of the Project tasks table with task, priority, owner, status, start date, end date, milestone and deliverable columns](https://cdn.owox.ai/www/webflow/6786eefc7801479b2a83358a_53354.png/public)

A pre-built table is a starting layout, not a feature of its own. Columns can be renamed, retyped, added and deleted like in any table.

## Column types

Open the menu in a column header and choose **Edit column type**.

![Google Sheets with the column menu of a table open on Edit column type, listing Number, Text, Date, Dropdown, Checkbox and Smart chips, and the Smart chips submenu with People, File, Finance, Place and Rating](https://cdn.owox.ai/www/webflow/6786eefcb3a23b64e2f1d215_53376.png/public)

According to Google’s help, the types are:

*   **Number:** number, percentage or currency.
*   **Text.**
*   **Date:** date, date and time, or time.
*   **Dropdown:** a list of allowed values, shown as coloured chips.
*   **Checkbox.**
*   **Smart chips:** people, file, finance, place or rating.
*   **None:** no type, for a column that mixes kinds of values.

The type formats the column and checks it. A text typed into a date column gets a warning mark. This is the same mechanism as [data validation](/blog/articles/data-validation-google-sheets), applied to a whole column in one step.

The same menu sorts and filters the column, groups the table by it, and inserts or deletes columns.

## The Turning Point

OWOX Data Marts

See your first report built in real time. _15 minutes._

1.  Connect your data warehouse
2.  Pick your metrics
3.  Get a live Google Sheets report

In the time it takes to write a ticket. Then imagine never writing that ticket again.

[Book a Demo](/book-a-call)

We'll use your actual use case

## The table menu

The arrow next to the table name opens the settings of the table. Google’s help lists:

*   **Rename table.**
*   **Adjust table range.**
*   **Table header color.**
*   **Table formatting:** gridlines, alternating colours, a condensed view, a footer row. More options are under **Format > Table formatting**.
*   **Revert to unformatted data:** turns the table back into a plain range and keeps the data.
*   **Delete table:** removes the table together with its data.

Note the difference between the last two.

### Rules for table names

A table name cannot start with a number, cannot look like a cell reference such as A1, cannot be TRUE or FALSE, cannot be longer than 255 characters, and cannot contain special characters other than the underscore. A space in the name becomes an underscore in formulas: “Table 1” is written `Table_1`.

## Filter and group with views

The second button next to the table name creates a view: a way of looking at the table that does not change it for other people.

![Google Sheets with the views menu of a table open, offering Create group by view and Create filter view, and a temporary filter in use with a Save view button](https://cdn.owox.ai/www/webflow/6786eefcba19155fdd02848d_53370.png/public)

*   **A filter view** shows only the rows that meet the conditions set in the column menus.
*   **A group by view** puts the rows under a heading for each value of one column.

![Google Sheets with the Create group by view submenu of an inventory table, listing its columns to group by](https://cdn.owox.ai/www/webflow/6786eefd20d64aa02202576a_53392.png/public)

![Google Sheets with an inventory table grouped by supplier: the rows sit under the headings Supplier X, Supplier Y and Supplier Z](https://cdn.owox.ai/www/webflow/6786eefcd6b066280bc867c6_53394.png/public)

A new view is temporary and disappears when the spreadsheet is refreshed. With edit access, **Save view** keeps it in the table menu. In a group by view, each column can show an aggregation for every group: sum, average, count, minimum, maximum, the number of unique values and others.

## Table references in formulas

A formula can name the table and the column instead of giving a range:

> `=SUM(Table1[Revenue])`

> `=SUMIF(Table1[Channel], "Search", Table1[Revenue])`

In our test table, the first formula returned 22300. After a row was typed directly under the table, it became part of the table and the same formula returned 23300 with nothing edited. The second formula changed from 12600 to 13600 the moment the new row got the channel “Search”.

*   `Table1[Revenue]` is the data of one column, without the header.
*   `Table1` is all the data rows. `=ROWS(Table1)` returned 7 for seven rows of data under one header row.

![Google Sheets with a table named Corporate\_Budget and a formula that subtracts the Cost column from the Budget column by their names being entered next to it](https://cdn.owox.ai/www/webflow/6786eefce5a15750b5f06591_53374.png/public)

A table reference goes where a range would go; we tested SUM, SUMIF, COUNTA and ROWS. Google’s help adds that references by name update whenever data is added to or removed from the table. A [pivot table](/blog/articles/pivot-tables-google-sheets) is built on a table like on any other range:

![Google Sheets with a pivot table built on a campaign table, with channels, regions and demographics as rows and the sum of conversions as values](https://cdn.owox.ai/www/webflow/6786eefc90f8a749d2dc834b_53404.png/public)

## Table, range or named range

|  | Plain range | Named range | Table |
| --- | --- | --- | --- |
| Reference in formulas | B2:F9 | A name for the whole range | A name for the table and for each column |
| Grows with new rows | No | No, the range is edited by hand | Yes |
| Column types and checks | Set by hand with data validation | Set by hand | Built in |
| Header with sort, filter and group menus | After a filter is created | No | Built in |
| Format | Set by hand | Set by hand | Applied with the table |

## When a table is not the right choice

*   **The result of a formula.** A range filled by [QUERY](/blog/articles/query-function-google-sheets), [FILTER](/blog/articles/google-sheets-filter-function) or another formula that expands is produced by its formula; keep it a plain range.
*   **A layout that is not a list.** A table expects one header row and one record per row. Reports with subtotals between the rows, merged cells or several blocks side by side do not fit.
*   **A sheet that other tools write into.** Before converting a range that an add-on or a script fills, check that the tool still writes where you expect.
*   **Free-form notes.** Types and checks get in the way when a column holds whatever comes.

Converting back is one click, **Revert to unformatted data**, so trying a table costs little.

## Related guides

*   [Pivot tables](/blog/articles/pivot-tables-google-sheets): Summarize a table by groups.
*   [Data validation](/blog/articles/data-validation-google-sheets): Dropdowns and rules outside tables.
*   [How to sort data](/blog/articles/how-to-sort-data-google-sheets): Sorting ranges and tables.
*   [Slicers](/blog/articles/slicers-google-sheets): Filters for charts and pivot tables.
*   [QUERY](/blog/articles/query-function-google-sheets): Filter and group with a formula.
*   [Charts](/blog/articles/charts-for-visualization-google-sheets): Visualize the data of a table.

## A table organizes what people type; reporting data needs a source

Tables are built for data that lives in the sheet: tasks, plans, lists that people keep by hand. Spend, orders and revenue are a different kind of data. They live in other systems, and pasting exports of them into a table makes a tidy copy that is out of date the next day.

The [OWOX Data Marts extension for Google Sheets](https://workspace.google.com/marketplace/app/owox_data_marts/94902851409) covers that half. A data analyst publishes a data mart (a table or an SQL query in your data warehouse) and makes it available for reports. In Sheets you open the extension, pick the data mart, tick the columns you want and run it. The rows land in a tab, ready for your formulas.

![Google Sheets with the OWOX Data Marts extension open beside an ad spend table: the Unified Ad Spend data mart, nine of fourteen columns ticked and a Save & Run button – the rows in the sheet come from a governed data mart, not a pasted export](https://cdn.owox.ai/www/content-marketing-article/tables-feature-google-sheets/screens/1.png/public)

What changes for the person who maintains the sheet:

*   **Refresh replaces re-export.** _Refresh current report_ in the extension menu re-runs the same pull, and a scheduled refresh keeps the tab current without anyone touching it.
*   **The source is written on the sheet.** The header cell of an imported tab carries a note with the data mart it came from, the time of the import and a link to the report.
*   **No SQL and no warehouse access needed.** The analyst decides which data marts and columns are available. You choose from that list.

The extension does not write or change the analyst’s SQL. Tables then hold what the team maintains by hand, and the numbers next to them come from the warehouse. The extension comes with the OWOX Cloud plans of [OWOX Data Marts](https://www.owox.com/app-signup); [spreadsheet reporting](/features/spreadsheet-reporting) describes both ways data reaches a sheet.

## Your New Normal

Turn your data into decisions.

Governed data marts give you the clean foundation ML needs to actually work.

*   No AI hallucinations
*   Analyst-governed definitions
*   Every number traces to SQL

[Get started free](https://www.owox.com/app-signup)

## FAQ

## Frequently Asked Questions

How can I use the new tables feature for project management or financial analysis?

The new tables feature can streamline project management by tracking tasks and resources, and enhance financial analysis by organizing and categorizing financial data.

Are there limitations to the new tables feature in Google Sheets?

A table expects one header row and one record per row, so layouts with subtotals between rows, merged cells or several blocks side by side do not fit. Deleting a table removes its data too; to keep the data, use Revert to unformatted data. Conditional notifications on tables are available only to certain work or school accounts, according to Google's help.

What are the key benefits of the 'Group By' option in Google Sheets tables?

The 'Group By' option helps summarize data efficiently, providing insights at a glance and improving data visualization.

Can Google Sheets tables be integrated with other tools for enhanced functionality?

Yes. A table is still a range of cells: formulas, charts and pivot tables can be built on it, and table references such as =SUM(Table1\[Revenue\]) keep working as rows are added.

How does the new tables feature improve data analysis in Google Sheets?

It simplifies data management with quick formatting, column types, and integrated filtering and sorting options, making it easier to analyze large datasets.

What is the new tables feature in Google Sheets?

A table is a range that has a name, a header row with sort, filter and group menus, a type for each column and its own format. Create one with Format > Convert to table, or insert a ready structure with Insert > Pre-built tables.

## Who wrote this

![Vadym Kramarenko](https://cdn.owox.ai/www/webflow/6798e703afdf787334941cde_Vadym-Kramarenko.png/public)

[Vadym Kramarenko](/team/vadym-kramarenko) · Growth Marketing Manager

Vadym Kramarenko is a Growth Marketing Manager at OWOX, where he drives user acquisition and product-led growth strategies. He hosts the OWOX podcast, interviewing analytics professionals about data-driven marketing, attribution, and reporting best practices. Vadym specializes in turning complex analytics concepts into practical, actionable marketing frameworks.

[LinkedIn](https://www.linkedin.com/in/vadim-kramarenko/) · [All articles](/team/vadym-kramarenko)

[Google Sheets Tips](/blog/topics/google-sheets-tips)

## Related articles

[Google Sheets Tips · QUERY with CONCATENATE in Google Sheets: join two columns · October 2, 2026](/blog/articles/query-with-concatenate-google-sheets)

[Google Sheets Tips · IF with VLOOKUP in Google Sheets: formulas and examples · October 2, 2026](/blog/articles/how-to-use-vlookup-with-if-statement-in-google-sheets)

[Google Sheets Tips · VLOOKUP in Google Sheets: formula, another sheet and examples · October 2, 2026](/blog/articles/vlookup-in-google-sheets)

[See all articles →](/blog/articles)

## Book a call

You are booked. The invitation is on its way to , with the calendar invite and the meeting link.

[Reschedule](#)

[Cancel](#)

## Links

Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link.

- [Google Sheets Tips](https://www.owox.com/blog/topics/google-sheets-tips) — /blog/topics/google-sheets-tips.md
- [Vadym Kramarenko](https://www.owox.com/team/vadym-kramarenko) — /team/vadym-kramarenko.md
- [data validation](https://www.owox.com/blog/articles/data-validation-google-sheets) — /blog/articles/data-validation-google-sheets.md
- [Book a Demo](https://www.owox.com/book-a-call) — /book-a-call.md
- [pivot table](https://www.owox.com/blog/articles/pivot-tables-google-sheets) — /blog/articles/pivot-tables-google-sheets.md
- [QUERY](https://www.owox.com/blog/articles/query-function-google-sheets) — /blog/articles/query-function-google-sheets.md
- [FILTER](https://www.owox.com/blog/articles/google-sheets-filter-function) — /blog/articles/google-sheets-filter-function.md
- [How to sort data](https://www.owox.com/blog/articles/how-to-sort-data-google-sheets) — /blog/articles/how-to-sort-data-google-sheets.md
- [Slicers](https://www.owox.com/blog/articles/slicers-google-sheets) — /blog/articles/slicers-google-sheets.md
- [Charts](https://www.owox.com/blog/articles/charts-for-visualization-google-sheets) — /blog/articles/charts-for-visualization-google-sheets.md
- [OWOX Data Marts](https://www.owox.com/app-signup)
- [spreadsheet reporting](https://www.owox.com/features/spreadsheet-reporting) — /features/spreadsheet-reporting.md
- [Google Sheets Tips · QUERY with CONCATENATE in Google Sheets: join two columns · October 2, 2026](https://www.owox.com/blog/articles/query-with-concatenate-google-sheets) — /blog/articles/query-with-concatenate-google-sheets.md
- [Google Sheets Tips · IF with VLOOKUP in Google Sheets: formulas and examples · October 2, 2026](https://www.owox.com/blog/articles/how-to-use-vlookup-with-if-statement-in-google-sheets) — /blog/articles/how-to-use-vlookup-with-if-statement-in-google-sheets.md
- [Google Sheets Tips · VLOOKUP in Google Sheets: formula, another sheet and examples · October 2, 2026](https://www.owox.com/blog/articles/vlookup-in-google-sheets) — /blog/articles/vlookup-in-google-sheets.md
- [See all articles →](https://www.owox.com/blog/articles) — /blog/articles.md