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

26/09/2024

Table of contents

What’s changing

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

Starting today, 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.

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

Getting started

Admins: There is no admin control for this feature.
End users:
- 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.
- Visit the Help Center to learn more about using tables in Google Sheets.

Rollout pace

Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on May 10, 2024
Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on April 1, 2024