Gemini in Google Sheets helps you create dynamic and easily referenced tables

Gemini in Google Sheets helps you create dynamic and easily referenced tables
August 27, 2025

What’s changing
Building on the introduction of intelligent suggestions for table conversion, we’re now using Gemini to make tables in Sheets even more useful. Now, when you accept a “Convert to table” suggestion, Gemini will automatically format your data as a table and create a meaningful table name (e.g., Project_Status).

Tables help organize your data, simplifying common tasks like sorting and filtering. They also enable the use of table references, which use the table's meaningful name in place of cell coordinates. For example, a formula like =SUM(E2:E15) becomes the more descriptive =SUM(Office_Expenses[Amount]). These names are not only easier to read and understand, but they are also easier to write, appearing in formula autocomplete suggestions as you type.

Crucially, table references are dynamic. The formula's range automatically expands and contracts as you add or remove rows from your table, ensuring your calculations are always up to date and accurate, without you ever needing to manually edit cell ranges again.

Getting started

• Admins: To access Gemini in Workspace apps, users need to have smart features and personalization turned on. Admins can turn on the personalization setting for their users in the Admin console.
• End users:
• This feature will be on by default and can be disabled by going to Tools > Suggestion controls > (deselect) Enable table suggestions.
• Visit the Help Center to learn more about using tables in Google Sheets.

Rollout pace

• Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) currently underway
• Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on September 12, 2025

Availability
Available for Google Workspace:

• Business Standard and Plus
• Enterprise Standard and Plus
• Customers with the Gemini Education or Gemini Education Premium add-on
• Google AI Pro and Ultra

Anyone who previously purchased these add-ons will also receive this feature:

• Gemini Business*
• Gemini Enterprise*