Sort & filter BigQuery data in Google Sheets

1. On your computer, open a spreadsheet in Google Sheets that is connected to BigQuery data. Learn how to connect to BigQuery data.
2. At the top of a column, click Filter .
3. Choose whether you would like that column sorted in ascending or descending order. This sorts both text and numbers.
4. Click Ok.
5. At the bottom left of the sheet, click Apply.

1. On your computer, open a spreadsheet in Google Sheets that's connected to BigQuery data.
2. At the top of a column, click Filter .
3. Under “Filter by condition,” click the Drop-down  and choose your condition. 
4. Click Ok.
5. At the bottom left of the sheet, click Apply.

1. On your computer, open a spreadsheet in Google Sheets that’s connected to BigQuery data.
2. At the top of a column, click Filter .
3. Under “Filter by value,” click Add filter.
   • Tip: BigQuery grabs the top 500 values, which may take a few seconds.
4. When the values and their frequencies load in the sidebar, check the values that you want to use.
5. Click OK.
6. At the bottom left of the sheet, click Apply.

You can also filter by selected cell value:

1. On your computer, open a spreadsheet in Google Sheets that’s connected to BigQuery data.
2. Right-click on a cell value that you want to filter.
3. Click Filter by cell value.
4. At the bottom left of the sheet, click Apply.

Tip: You can also filter by selected cell value on an extract.

Next: Analyze & refresh BigQuery data in Google Sheets using Connected Sheets