{"id":987517017,"date":"2024-08-15T19:09:51","date_gmt":"2024-08-15T19:09:51","guid":{"rendered":"https:\/\/workspace.trace.pt\/view-and-structure-google-form-data-as-a-table-in-google-sheets\/"},"modified":"2024-08-15T19:09:51","modified_gmt":"2024-08-15T19:09:51","slug":"view-and-structure-google-form-data-as-a-table-in-google-sheets","status":"publish","type":"post","link":"https:\/\/workspace.trace.pt\/en\/view-and-structure-google-form-data-as-a-table-in-google-sheets\/","title":{"rendered":"View and structure Google Form data as a table in Google Sheets"},"content":{"rendered":"

What's changing<\/h3>\n

We're introducing a new feature that enables users to more easily view and structure their Google Form data in Sheets.\u00a0<\/p>\n

<\/div>\n
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.\u00a0<\/p>\n
<\/div>\n
<\/a><\/div>\n

<\/p>\n

<\/div>\n

Getting started<\/h3>\n
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 Centre to learn more about using tables in Google Sheets.<\/a>\u00a0<\/p>\n

Rollout pace\u00a0<\/h3>\n<\/div>\n
Rapid Release domains:<\/a> Extended rollout (potentially longer than 15 days for feature visibility) starting on August 15, 2024\u00a0Scheduled Release domains:<\/a> Extended rollout (potentially longer than 15 days for feature visibility) starting on September 5, 2024\u00a0<\/p>\n

Availability<\/h3>\n<\/div>\n
Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts\u00a0<\/p>\n

Resources\u00a0<\/h3>\n<\/div>\n
Google Help: Use tables in Google Sheets\u00a0<\/a>Google Workspace Updates Blog: New ways to quickly format and organise data with Tables in Google Sheets<\/a><\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"

What\u2019s changing We’re introducing a new feature that enables users to more easily view and structure their Google Form data in Sheets.\u00a0 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 […]<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-987517017","post","type-post","status-publish","format-standard","hentry","category-noticias"],"acf":[],"_links":{"self":[{"href":"https:\/\/workspace.trace.pt\/en\/wp-json\/wp\/v2\/posts\/987517017","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/workspace.trace.pt\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/workspace.trace.pt\/en\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/workspace.trace.pt\/en\/wp-json\/wp\/v2\/comments?post=987517017"}],"version-history":[{"count":0,"href":"https:\/\/workspace.trace.pt\/en\/wp-json\/wp\/v2\/posts\/987517017\/revisions"}],"wp:attachment":[{"href":"https:\/\/workspace.trace.pt\/en\/wp-json\/wp\/v2\/media?parent=987517017"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/workspace.trace.pt\/en\/wp-json\/wp\/v2\/categories?post=987517017"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/workspace.trace.pt\/en\/wp-json\/wp\/v2\/tags?post=987517017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}