View and structure Google Form data as a table in Google Sheets

Google is introducing a new feature that enables users to view and structure their Google Form data in Sheets more easily.

From August 15, 2024, when a user initiates the creation of a new sheet using their Forms data, Sheets will automatically open the data as a table, bringing format and structure to your data.

If a user opens a pre-existing sheet connected to a Form, there will be no change and the user will need to convert the data to a table by going to Format > Convert to table.

For pre-existing spreadsheets connected to Form data, you can convert the data to a table manually by selecting the data range and going to Format > Convert to table.

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