Introduction to data export

This document describes the different ways of exporting data fromBigQuery.

For more information about data integrations, seeIntroduction 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, seeExport query results to a file.

Export tables

You can export your BigQuery tables in the following data formats:

You can alsoexport your BigQuery tables as Protobuf columnswhen working with nested data structures that require objecttype safety, or if you need a wider language support.

Export BigQuery code assets

You can downloadBigQuery Studiocode assets, such assaved queries ornotebooksto maintain a local copy of your assets. For more information on downloading your BigQuery code assets, see thefollowing:

• Download saved queries
• Download notebooks

Export using reverse ETL

You can set up reverse ETL (RETL) workflows (preview) to move data fromBigQuery to the following databases:

• Export to Bigtable
• Export to Spanner
• Export to Pub/Sub

What's next

• Learn aboutquotas for extract jobs.
• Learn aboutBigQuery storage pricing.