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:

Data format Supported compression types Supported export methods
CSV GZIP Export to Cloud Storage
JSON GZIP Export to Cloud Storage
Read from BigQuery using Dataflow
Avro DEFLATE, SNAPPY Export to Cloud Storage
Read from BigQuery using Dataflow
Parquet GZIP, SNAPPY, ZSTD Export to Cloud Storage

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