{"id":24450,"date":"2025-12-24T10:16:27","date_gmt":"2025-12-24T03:16:27","guid":{"rendered":"https:\/\/gcloudvn.com\/?p=24450"},"modified":"2025-12-24T10:16:27","modified_gmt":"2025-12-24T03:16:27","slug":"analyze-large-scale-csv-files-in-google-sheets-with-a-new-direct-to-bigquery-import","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/google-workspace\/analyze-large-scale-csv-files-in-google-sheets-with-a-new-direct-to-bigquery-import\/","title":{"rendered":"Analyze large-scale .csv files in Google Sheets with a new direct-to-BigQuery import"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-workspace\/analyze-large-scale-csv-files-in-google-sheets-with-a-new-direct-to-bigquery-import\/#Co_gi_thay_doi\" >What\u2019s changing<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-workspace\/analyze-large-scale-csv-files-in-google-sheets-with-a-new-direct-to-bigquery-import\/#Bat_dau\" >Getting started<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-workspace\/analyze-large-scale-csv-files-in-google-sheets-with-a-new-direct-to-bigquery-import\/#Thoi_gian_trien_khai\" >Rollout pace<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-workspace\/analyze-large-scale-csv-files-in-google-sheets-with-a-new-direct-to-bigquery-import\/#Tinh_kha_dung\" >Availability<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Co_gi_thay_doi\"><\/span><b>What\u2019s changing<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">We're making it easier than ever to analyze massive datasets by more seamlessly connecting Google Sheets and BigQuery. Now, users will see a new option to import .csv files containing datasets of any size directly to BigQuery while opening large .csv files from Drive or via the Data &gt; Data Connectors menu flow in Sheets. From there, users can analyze the entire dataset using familiar Sheets features such as charts, pivot tables, and formulas via <\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/9702507\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">Connected Sheets<\/span><\/a><span style=\"font-weight: 400;\">.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Previously, preparing a large dataset for analysis in Connected Sheets was often a multi-step process that could have involved relying on separate data pipelines, processing tools or multiple upload steps, all before the user could return to Sheets to start their analysis. This new connectivity expedites the analysis workflow by allowing users to directly ingest large datasets and begin analysis seamlessly, all within a single interface. This update will help users move from raw data to insights much faster.<\/span><\/p>\n<p>&nbsp;<\/p>\n<table>\n<tbody>\n<tr>\n<td><a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-workspace\/automatically-generated-captions-for-videos-in-google-drive-now-available-in-more-languages\/attachment\/part-of-the-upload-dialog-when-users-choose-to-import-a-file-to-bigquery-via-the-google-sheets-interface\/\" rel=\"attachment wp-att-24418\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24418\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/12\/Part-of-the-upload-dialog-when-users-choose-to-import-a-file-to-BigQuery-via-the-Google-Sheets-interface-.png\" alt=\"\" width=\"640\" height=\"388\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/12\/Part-of-the-upload-dialog-when-users-choose-to-import-a-file-to-BigQuery-via-the-Google-Sheets-interface-.png 640w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/12\/Part-of-the-upload-dialog-when-users-choose-to-import-a-file-to-BigQuery-via-the-Google-Sheets-interface--18x12.png 18w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Part of the upload dialog when users choose to import a file to BigQuery via the Google Sheets interface<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<table>\n<tbody>\n<tr>\n<td><a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-workspace\/automatically-generated-captions-for-videos-in-google-drive-now-available-in-more-languages\/attachment\/users-with-appropriate-permissions-will-also-see-a-new-option-to-import-with-connected-sheets-when-a-file-is-too-large-for-native-upload-to-sheets\/\" rel=\"attachment wp-att-24417\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24417\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/12\/Users-with-appropriate-permissions-will-also-see-a-new-option-to-import-with-Connected-Sheets-when-a-file-is-too-large-for-native-upload-to-Sheets-.png\" alt=\"\" width=\"640\" height=\"400\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/12\/Users-with-appropriate-permissions-will-also-see-a-new-option-to-import-with-Connected-Sheets-when-a-file-is-too-large-for-native-upload-to-Sheets-.png 640w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/12\/Users-with-appropriate-permissions-will-also-see-a-new-option-to-import-with-Connected-Sheets-when-a-file-is-too-large-for-native-upload-to-Sheets--18x12.png 18w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Users with appropriate permissions will also see a new option to import with Connected Sheets when a file is too large for native upload to Sheets<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><span class=\"ez-toc-section\" id=\"Bat_dau\"><\/span><b>Getting started<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Admins: This feature will only be available to users who have been granted permissions to write to BigQuery tables.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">End users: This feature will be available by default for users with permissions to write to BigQuery.\u00a0<\/span><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Thoi_gian_trien_khai\"><\/span><b>Rollout pace<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on November 3, 2025<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on November 18, 2025<\/span><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Tinh_kha_dung\"><\/span><b>Availability<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts<\/span><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>C\u00f3 g\u00ec thay \u0111\u1ed5i Google \u0111ang gi\u00fap vi\u1ec7c ph\u00e2n t\u00edch c\u00e1c t\u1eadp d\u1eef li\u1ec7u kh\u1ed5ng l\u1ed3 tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n bao gi\u1edd h\u1ebft b\u1eb1ng c\u00e1ch k\u1ebft n\u1ed1i Google Sheets v\u00e0 BigQuery li\u1ec1n m\u1ea1ch h\u01a1n. Gi\u1edd \u0111\u00e2y, ng\u01b0\u1eddi d\u00f9ng s\u1ebd&hellip;<\/p>","protected":false},"author":2,"featured_media":24419,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1,134],"tags":[],"class_list":["post-24450","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","category-google-workspace","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/24450","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=24450"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/24450\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/24419"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=24450"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=24450"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=24450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}