Sort & filter BigQuery data in Google Sheets

You can sort and filter billions of rows of BigQuery data in Google Sheets, so it's easier to work with.

Important: To access BigQuery data in Google Sheets, you need access to BigQuery. Learn how to get started with BigQuery.

Sort & filter the preview tab

Sort your data

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.

Remove the sort

1. On your computer, open a spreadsheet in Google Sheets that is connected to BigQuery data.
2. At the top of a column that is sorted, click Filter .
3. Click the sort that is highlighted. 
4. Click OK.
5. At the bottom left of the sheet, click Apply.

Add a filter by condition

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.

Remove a filter by condition

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

Add a filter by value

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, tick 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 a 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 a selected cell value on an extract.

Remove a filter by value

1. On your computer, open a spreadsheet in Google Sheets that's connected to BigQuery data.
2. At the top of a column that is sorted, click Filter .
3. Under 'Filter by value', click Edit filter.
4. In the sidebar, click Select all.
5. Click OK.
6. At the bottom left of the sheet, click Refresh preview.

Sort & filter your pivot table, extract & chart

Sort your pivot table, extract & chart

Use extracts & charts

1. To open the right side panel, click the object. 
2. Under “Chart Editor,” click Setup.
3. Under “Sort,” click Add.
4. Select the value you want to sort. 
5. To change the order, next to the value you want to sort, click A  Z or Z  A.
6. At the bottom left of the sheet, click Apply or Refresh.

Tip: To remove sorted conditions, in the right side panel, click Setup. Under 'Sort', click Remove .

Use pivot tables

1. To open the right side panel, click on your pivot table. 
2. Under 'Chart Editor', click Setup.
3. Under 'Row', select the options you want under 'Order' and 'Sort by'.
4. At the bottom left of the sheet, click Apply or Refresh.

Tip: You can change the options you chose under 'Order' and 'Sort by'.

Filter your pivot table, extract & chart

Add a filter by condition

1. To open the right side panel, click on your pivot table, extract or chart. 
2. Under 'Chart Editor', click Setup.
3. Under 'Filter', click Add.
4. Next to 'Showing all items', click the drop-down . 
5. Under 'Filter by condition', select the condition.
6. Click OK. 
7. At the bottom left of the sheet, click Apply or Refresh.

Tip: To remove current filters, in the right side panel, under 'Filters', click Remove .

Add a filter by value

1. To open the right side panel, click on your pivot table, extract or chart. 
2. Under 'Chart Editor', click Setup.
3. Under 'Filter', click Add.
4. Next to 'Showing all items', click the drop-down .
5. Under 'Filter by value', click Add filter.
6. Select values to filter. 
7. Click OK or Apply.
8. At the bottom left of the sheet, click Apply or Refresh.

Tip: To remove current filters, in the right side panel, under 'Filters', click Remove .

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