Following the introduction of tables in Google Sheets and the recently announced improvements to tables, we're excited to support a new automated way for users to transform their data into a well-formatted table, with rich data types.

If you have a meaningful range of data, Sheets will show a "Convert to table" suggestion when you click into your data range. By hovering over that indicator, you can preview the suggestion and then convert your range to a table in one click. 

End users 

This update encourages the use of tables, a feature that enables users to transform the way they organise their data, simplify data creation, and reduce the repetitive tasks needed to format, input, and update data in Sheets. 

Admins: There is no admin control for this feature. End users: This feature will be on by default and can be disabled by going to Tools > Suggestion controls > (deselect) Enable table suggestions. While the suggestion to convert to table will likely appear automatically, you can also convert data to a table manually by selecting a data range and going to Format > Convert to table. Visit the Help Centre to learn more about using tables in Google Sheets. 

Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on August 13, 2024 Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on September 4, 2024 

Available to all Google Workspace customers, Google Workspace Individual Subscribers, and users with personal Google accounts 

Resources