Google Sheets gains smarter table conversion with Gemini

With the latest Gemini update, Sheets formats data as tables and generates descriptive names, improving readability and keeping formulas automatically in sync.
Google Sheets, Gemini integration, intelligent table conversion, dynamic formulas, Convert to table suggestion, named table references, Workspace upgrade, AI-powered tables

Last year, Google introduced ‘Convert to table’ suggestions in Sheets, allowing users to turn a selected data range into a formatted table with one click.

Now, Google has enhanced that feature with Gemini integration. When users accept a table suggestion, Gemini applies proper formatting and creates sensible names, such as ‘Project_Status’ or ‘Office_Expenses’, making formula references more precise and meaningful.

For example, users can write =SUM(Office_Expenses[Amount]) instead of cryptic cell ranges like =SUM(E2:E15).

These newly named tables offer dynamic formula ranges that automatically expand or shrink as rows are added or removed, helping spreadsheets stay accurate without manual edits. The feature can be turned off under Tools > Suggestion controls if users prefer their original workflow.

Rollout is underway for Google Workspace Business Standard/Plus and Enterprise plans and Google AI Pro, Ultra, and specific education add-ons.

Rapid Release domains are receiving it now. Scheduled Release domains will see it from 12 September. Admins must enable innovative features and personalisation for users to access them.

Would you like to learn more about AI, tech and digital diplomacy? If so, ask our Diplo chatbot!