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

Wait 5 sec.

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(2025_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* *As of January 15, 2025, we’re no longer offering the Gemini Business and Gemini Enterprise add-ons for sale. Please refer to this announcement for more details. Resources Google Help: Collaborate with Gemini in Google Sheets Google Help: Use tables in Google Sheets Google Help: Use table references in Google Sheets Google Workspace Updates Blog: New ways to quickly format and organize data with Tables in Google Sheets