Introduction to data export
This document describes the different ways of exporting data from
BigQuery.
For more information about data integrations, see
Introduction to loading, transforming, and exporting data.
Export query results
You can export query results to a local file (either as a CSV or JSON file),
Google Drive, or Google Sheets. For more information, see
Export query results to a file.
Export tables
You can export your BigQuery tables in the following data formats:
You can also export your BigQuery tables as Protobuf columns
when working with nested data structures that require object
type safety, or if you need a wider language support.
Export BigQuery code assets
You can download BigQuery Studio
code assets, such as saved queries or notebooks
to maintain a local copy of your assets. For more information on downloading your BigQuery code assets, see the
following:
Export using reverse ETL
You can set up reverse ETL (RETL) workflows (preview) to move data from
BigQuery to the following databases:
What's next
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-08-25 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-25 UTC."],[[["\u003cp\u003eBigQuery allows you to export data in various ways, including exporting query results to local files, Google Drive, or Google Sheets.\u003c/p\u003e\n"],["\u003cp\u003eYou can export BigQuery tables to Cloud Storage in CSV, JSON, Avro, or Parquet formats, each supporting different compression types.\u003c/p\u003e\n"],["\u003cp\u003eBigQuery tables can also be exported as Protobuf columns for nested data structures or when wider language support is required.\u003c/p\u003e\n"],["\u003cp\u003eBigQuery Studio code assets, such as saved queries and notebooks, can be downloaded to maintain local copies.\u003c/p\u003e\n"],["\u003cp\u003eReverse ETL (RETL) workflows can move data from BigQuery to databases like Bigtable, Spanner, and Pub/Sub.\u003c/p\u003e\n"]]],[],null,["# Introduction to data export\n===========================\n\nThis document describes the different ways of exporting data from\nBigQuery.\n\nFor more information about data integrations, see\n[Introduction to loading, transforming, and exporting data](/bigquery/docs/load-transform-export-intro).\n\nExport query results\n--------------------\n\nYou can export query results to a local file (either as a CSV or JSON file),\nGoogle Drive, or Google Sheets. For more information, see\n[Export query results to a file](/bigquery/docs/export-file).\n\nExport tables\n-------------\n\nYou can export your BigQuery tables in the following data formats:\n\nYou can also [export your BigQuery tables as Protobuf columns](/bigquery/docs/protobuf-export)\nwhen working with nested data structures that require object\ntype safety, or if you need a wider language support.\n\nExport BigQuery code assets\n---------------------------\n\nYou can download [BigQuery Studio](/bigquery/docs/query-overview#bigquery-studio)\ncode assets, such as [saved queries](/bigquery/docs/saved-queries-introduction) or [notebooks](/bigquery/docs/notebooks-introduction)\nto maintain a local copy of your assets. For more information on downloading your BigQuery code assets, see the\nfollowing:\n\n- [Download saved queries](/bigquery/docs/manage-saved-queries#download_saved_queries)\n- [Download notebooks](/bigquery/docs/manage-notebooks#download_a_notebook)\n\nExport using reverse ETL\n------------------------\n\nYou can set up reverse ETL (RETL) workflows ([preview](https://cloud.google.com/products#product-launch-stages)) to move data from\nBigQuery to the following databases:\n\n- [Export to Bigtable](/bigquery/docs/export-to-bigtable)\n- [Export to Spanner](/bigquery/docs/export-to-spanner)\n- [Export to Pub/Sub](/bigquery/docs/export-to-pubsub)\n\nWhat's next\n-----------\n\n- Learn about [quotas for export jobs](/bigquery/quotas#export_jobs).\n- Learn about [BigQuery storage pricing](/bigquery/pricing#storage)."]]
