Exporting CSV Results from BigQuery to a Local File#
Here are the steps to export query results from BigQuery to your local machine as a CSV file:
Run your query in the BigQuery console
After the query completes, look at the Query results panel below
Click the “Save results” button (or “Download” button with a down arrow icon)
Select “Local Download / CSV” from the dropdown menu
Choose your download location and the file will save to your computer