Analyze large-scale .csv files in Google Sheets with a new direct-to-BigQuery import
WorkspaceNovember 12, 2025
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.
Getting started
- Admins: This feature will only be available to users who have been granted permissions to write to BigQuery tables. Visit the Help Center to learn more about using Connected Sheets in your organization.
- End users: This feature will be available by default for users with permissions to write to BigQuery. Visit the Help Center to learn more about uploading to BigQuery and analyzing via Connected Sheets.
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, Workspace Individual Subscribers, and users with personal Google accounts
