Google Sheets' new feature turns messy data into tables with one click

by

url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url url

summary

  • The new “Convert to Table” feature in Google Sheets streamlines your workflow for working with large data sets with just one click.
  • This update is part of our ongoing efforts to improve features across Google Workspace and make Sheets even more powerful.
  • Users in rapid release domains already have access to the convert to tables feature, while the feature will be available to all other users by September 4, 2024.



Google Sheets is getting smarter. It started with the Google Gemini integration, and now Google is introducing a new feature that lets you turn messy rows into clean tables with the click of a button. This update is part of Google's ongoing efforts to improve features across Google Workspace.

A computer monitor with a Google Spreadsheet displayed sits on a white desk.

Related

8 ways to use Gemini with Google Sheets

Using Google Sheets with Gemini is sure to make your life easier

Convert to Table is a new feature that leverages Google's powerful automation to help customers create structured tables from chaotic spreadsheets. Users simply select a meaningful range of cells in a spreadsheet, and Sheets will show a suggestion to convert that range to a table. Users can also hover their mouse cursor over the suggestion to preview how it will look. All in a single click.



What users can expect from Convert to Table

This new feature is expected to help streamline the workflow for users who frequently work with large data sets. By converting to a table, you no longer need to enter and format individual cells, saving busy people time.

According to Google, the Convert to Table feature will be rolled out in two stages. Users in rapid release domains should already have access to the feature and may have noticed it appearing in Sheets over the past week. Everyone else, including users in scheduled release domains, will have to wait a little longer, as the rollout is scheduled to begin on September 4, 2024. Personal Google Workspace subscribers and personal Google Account users will also have access to the new tool around this time.


Convert to Table is an exciting update for Google Sheets, which has long been considered the less robust cousin of Microsoft Excel. Google differentiates its Workspace service with powerful tools like AI-assisted formula and template generation, exporting Gemini responses to Google Sheets, and now quick table creation. Sheets will continue to get more powerful as Google comes up with new ways to use AI to improve its service.

The update is part of Google's broader strategy to transform itself into an AI company — Gemini is showing up everywhere from Gmail to Chromebooks to the new Pixel 9 — so it makes sense to see AI popping up throughout Workspace, too.



Leave a Comment