Table templates for Google Forms data and Google Sheets

Google recently added table templates to Google Sheets that makes it easier to view your Google Form data. In Google Forms when you click to view Responses and View in sheets, now it will automatically open the data in a table that is nicely formatted. 

This will only work on new sheets so if you open a pre-existing sheet connected to a form, you will need to convert the data to a table by selecting the data range and going to Format > Convert to table.

*image source: Google Workspace Updates

 

The Google Help center has more information about using tables in Google Sheets.

Article by Karen Matthes, Extension Learning Technologies, klm@umn.edu.