Gemini is bringing a killer, dynamic table feature to Google Sheets

For years, one of the key areas where Google Sheets has lagged behind Microsoft Excel has been its native table functionality. While you can, of course, make your data look like a table, the underlying structure and formula intelligence just wasn’t the same. Today, that’s changing in a big way.

In a new update, Google is using Gemini to make tables in Sheets far more intelligent, dynamic, and useful. This is a true “power user” feature, and it’s a fantastic addition.

More than just formatting

Building on the existing “Convert to table” suggestions, Gemini will now automatically do two key things when you create a table from a range of data. First, it will apply the proper formatting, but more importantly, it will also create a meaningful, human-readable name for your table, like “Project_Status” or “2025_Office_Expenses.” This might seem like a small change, but it unlocks the real magic of this update.

The magic of dynamic, self-updating formulas

Because your tables now have a proper name, you can use table references in your formulas instead of cryptic cell ranges. This means a formula that used to look like =SUM(E2:E15) can now be written as the far more descriptive =SUM(2025_Office_Expenses[Amount]). Not only is this easier to read and understand, but these new table names will also appear in formula autocomplete suggestions as you type. But here’s the crucial part: these table references are dynamic.

This means when you add a new row of data to your “2025_Office_Expenses” table, the SUM formula automatically expands to include it. When you remove a row, the formula automatically contracts. Your calculations will always be up to date and accurate, without you ever needing to manually edit cell ranges again. For anyone who has ever made a mistake in a spreadsheet because they forgot to update a formula after adding new data, you know this is an absolute game-changer.

How to get it

This new feature is on by default for eligible users and will appear as an intelligent “Convert to table” suggestion when you’re working with data. The rollout is currently underway for some users and will begin a wider rollout for most on September 12, 2025. It’s available to most paid Workspace subscribers, Gemini for Education add-on users, and Google AI Pro and Ultra subscribers. This is a fantastic update that brings some much-needed sophistication to Google Sheets, making it an even more powerful tool for data organization and analysis.