Analyze large-scale .csv files in Google Sheets with a new direct-to-BigQuery import

What’s changing

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 > 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 Connected Sheets. 

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.

Part of the upload dialog when users choose to import a file to BigQuery via the Google Sheets interface

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

Getting started

• Admins: This feature will only be available to users who have been granted permissions to write to BigQuery tables.
• End users: This feature will be available by default for users with permissions to write to BigQuery. 

Rollout pace

• Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on November 3, 2025
• Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on November 18, 2025

Availability

• Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts