{"id":6277,"date":"2025-09-24T18:00:51","date_gmt":"2025-09-24T12:30:51","guid":{"rendered":"https:\/\/www.navohosting.com\/blog\/?p=6277"},"modified":"2025-09-24T17:59:33","modified_gmt":"2025-09-24T12:29:33","slug":"quickly-create-looker-studio-report-in-sheets","status":"publish","type":"post","link":"https:\/\/www.navohosting.com\/blog\/quickly-create-looker-studio-report-in-sheets\/","title":{"rendered":"Quickly Create Looker Studio Report in Sheets"},"content":{"rendered":"<h2>Create Looker Studio Report in Sheets with 9 Steps<\/h2>\n<h3><strong>What is Looker Studio Report?<\/strong><\/h3>\n<p><strong>C<\/strong><strong>reate a <\/strong><strong>Looker Studio R<\/strong><strong>eport: <\/strong>Google workspace released latest updates where you can create a looker studio report in sheets. Want to convert your data into customizable reports? The <strong>Looker Studio (formerly Google Data Studio) turns your data into informative, easy-to-read, easy-to-share, and fully customizable dashboards and reports<\/strong>. \u00a0Google Sheets is part of the Google Docs suite of productivity apps. Google Sheets lets you create and format online spreadsheets and work on them simultaneously with others. Looker Studio extension is now available with all Google Workspace users. After the latest update, you can create a Looker Studio report directly from Google Sheets. Looker Studio enables users to build interactive reports and dashboards quickly.<\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/mdek7Xy03Ww?si=iiMFsCCfeEFhl8ro\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<h3><\/h3>\n<h3><strong>Steps to create a new report from Google Sheets using Looker Studio<\/strong><\/h3>\n<ol>\n<li>Go to Google Sheets<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-6289 size-large\" src=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/01-10-1024x534.jpg\" alt=\"\" width=\"800\" height=\"417\" srcset=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/01-10-1024x534.jpg 1024w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/01-10-300x157.jpg 300w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/01-10-768x401.jpg 768w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/01-10-1536x802.jpg 1536w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/01-10.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Navigate to the Google Sheet from which you want to create a report.<\/li>\n<li>In the Google Sheets toolbar, click\u00a0Extensions.<\/li>\n<li>Click the Looker Studio section of the Extensions menu<\/li>\n<li>Select\u00a0create a new report.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-6290 size-large\" src=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/02-12-1024x534.jpg\" alt=\"\" width=\"800\" height=\"417\" srcset=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/02-12-1024x534.jpg 1024w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/02-12-300x157.jpg 300w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/02-12-768x401.jpg 768w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/02-12-1536x802.jpg 1536w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/02-12.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Google Sheets displays the\u00a0Looker Studio report creation\u00a0panel.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-6292 size-large\" src=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/04-11-1024x534.jpg\" alt=\"Looker Studio Report\" width=\"800\" height=\"417\" srcset=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/04-11-1024x534.jpg 1024w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/04-11-300x157.jpg 300w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/04-11-768x401.jpg 768w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/04-11-1536x802.jpg 1536w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/04-11.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Configure report options in Google Sheets.<\/p>\n<p>Click\u00a0Create.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6293 size-large\" src=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/05-11-1024x531.jpg\" alt=\"\" width=\"800\" height=\"415\" srcset=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/05-11-1024x531.jpg 1024w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/05-11-300x156.jpg 300w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/05-11-768x398.jpg 768w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/05-11-1536x797.jpg 1536w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/05-11.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>To save the report, click\u00a0Save and Share.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6294 size-large\" src=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/06-9-1024x533.jpg\" alt=\"\" width=\"800\" height=\"416\" srcset=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/06-9-1024x533.jpg 1024w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/06-9-300x156.jpg 300w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/06-9-768x400.jpg 768w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/06-9-1536x799.jpg 1536w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/06-9.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>(If you don&#8217;t click\u00a0Save and Share, the report will be deleted after 24 hours)<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Select Country and company name.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6295 size-large\" src=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/07-9-1024x533.jpg\" alt=\"\" width=\"800\" height=\"416\" srcset=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/07-9-1024x533.jpg 1024w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/07-9-300x156.jpg 300w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/07-9-768x400.jpg 768w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/07-9-1536x799.jpg 1536w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/07-9.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Click the edit button if you need any correction.<\/li>\n<li>Hit the Share button.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6296 size-large\" src=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/09-7-1024x530.jpg\" alt=\"\" width=\"800\" height=\"414\" srcset=\"https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/09-7-1024x530.jpg 1024w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/09-7-300x155.jpg 300w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/09-7-768x397.jpg 768w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/09-7-1536x794.jpg 1536w, https:\/\/www.navohosting.com\/blog\/wp-content\/uploads\/2024\/05\/09-7.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<h3><strong>Options in Looker studio <\/strong><\/h3>\n<h4><strong>Using the first row as headers\u00a0<\/strong><\/h4>\n<p>Selecting this option makes the data source use the contents of the first row in your worksheet as the field names in the data source. If this option is not selected, the field names will use the column index (A, B, C, etc.).<\/p>\n<h4><strong>Include hidden and filtered cells\u00a0<\/strong><\/h4>\n<p>This option includes or excludes this data from the data source. The default value is to include them. This option\u00a0applies only to filters, not to filtered views.<\/p>\n<h4><strong>Include selected range\u00a0<\/strong><\/h4>\n<p>Using this option, you can define a range of cells in the selected worksheet. Use standard column-row syntax to define the range: for example, A1:Z26.<\/p>\n<p>To <a href=\"https:\/\/cloud.google.com\/looker\/docs\/intro\" target=\"_blank\" rel=\"noopener\">know more about looker studio check here<\/a><\/p>\n<p>After the new Google Workspace update, now users can do the following<\/p>\n<ul>\n<li>You can Pick which sheet or cell range to use in the generated report on Looker Studio.<\/li>\n<li>Transform the data in Google Sheets to an automatically generated Looker Studio report in a single click, and save and share the report with an individual or a team.<\/li>\n<li>The Looker Studio report generated remains connected to the Sheet and can be refreshed to reflect data updates.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>Now this new Google Workspace update is Available to all<\/p>\n<ul>\n<li>Google Workspace customers,<\/li>\n<li>Google Workspace Individual subscribers, and<\/li>\n<li>Users with personal Google accounts.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3>What are the things to consider while creating Looker Studio Report?<\/h3>\n<p>The default name of the report of Looker Studio is\u00a0Looker Studio Reporting &#8211; &lt;timestamp&gt;, where &lt;timestamp&gt; is the date and time that the Looker Studio report was created.<\/p>\n<ul>\n<li>Your data must be in a tabular format.<\/li>\n<li>Merged cells are not supported. Unmerge all cells before creating a report.<\/li>\n<li>The header row must be a single row.<\/li>\n<li>All cells within a column should be of the same type.<\/li>\n<\/ul>\n<p>Make sure that your date fields are formatted using the Date data type so that Looker Studio can correctly interpret them as dates for the report. To further<\/p>\n<p>&nbsp;<\/p>\n<p>Navo hosting is one of the authorized google workspace reseller \/ provider in India.\u00a0 Navohosting offers\u00a0 services to clients all over India.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Our services<\/strong><\/p>\n<ul>\n<li>Web Hosting\n<ul>\n<li><strong><a href=\"https:\/\/www.navohosting.com\/linux-shared-web-hosting\">Shared Hosting<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/www.navohosting.com\/cloud-vps-server-hosting\">Cloud \/ VPS Hosting<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/www.navohosting.com\/dedicated-server-hosting\">Dedicated Serves<\/a><\/strong><\/li>\n<\/ul>\n<\/li>\n<li>Email Services\n<ul>\n<li><strong><a href=\"https:\/\/www.navohosting.com\/google-workspace-email-hosting\">Google Workspace<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/www.navohosting.com\/microsoft-365-email-solutions\">Microsoft365<\/a><\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><strong><a href=\"https:\/\/www.navohosting.com\/blog\/features-enhance-google-sheet-visibility\/\">Features enhance google sheets tips and tricks<\/a><\/strong><\/p>\n<p style=\"text-align: center;\"><strong><a href=\"https:\/\/www.navohosting.com\/blog\/google-sites-business\/\">How Google Sites help for Business Growth?<\/a><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>To check about out services contact us here.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Create Looker Studio Report in Sheets with 9 Steps What is Looker Studio Report? Create a Looker Studio Report: Google workspace released latest updates where you can create a looker studio report in sheets. Want to convert your data into customizable reports? The Looker Studio (formerly Google Data Studio) turns your data into informative, easy-to-read, [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":6300,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[307,178,39],"class_list":["post-6277","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-g-suite","tag-google-looker-studio","tag-google-sheets","tag-google-workspace"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/posts\/6277","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/comments?post=6277"}],"version-history":[{"count":4,"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/posts\/6277\/revisions"}],"predecessor-version":[{"id":13113,"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/posts\/6277\/revisions\/13113"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/media\/6300"}],"wp:attachment":[{"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/media?parent=6277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/categories?post=6277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.navohosting.com\/blog\/wp-json\/wp\/v2\/tags?post=6277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}