How do I export a filtered Search Console Performance report?

The Citead team, updated

In short. Apply report filters and grouping, then use the export button to download chart and table data, subject to the 1,000-row limit.

Definition: A filtered Search Console Performance export downloads the report's chart and table data with the report filters and grouping applied. As of October 2026, Google documents Google Sheets, Microsoft Excel, and CSV formats, with report data limited to 1,000 representative rows.

Key facts

  • Google's report export documentation says downloads include paginated data and preserve report filters and special grouping.
  • Google's filtering instructions place + Add filter above the report; clicking a table row also applies a filter for that row.
  • Google's Performance overview explains that the tab above the table selects the grouping dimension, such as Queries or Pages.
  • Google's data discrepancy documentation says the table displays at most 1,000 rows, while chart totals can include omitted rows.

How is the filtered report prepared?

Google's Performance overview identifies the date range and search type controls at the top of the report. A metric is a reported measurement, such as clicks or impressions; a dimension groups the table's data, for example by query or page. Metric headings above the chart toggle the displayed measurements, and tabs above the table select the dimension.

The advanced filtering instructions describe + Add filter for adding report filters. Multiple dimensions can be filtered simultaneously. Existing filters are changed by clicking them, and the x removes a filter; the search type and date controls remain present.

For a query filter matching alternative text strings, the documented procedure uses Queries, then Custom (regex). A regular expression is a text-matching pattern. Google's example uses the vertical bar as an OR operator:

New York|San Francisco

The pattern matches a query containing either place name. The default Matches regex option uses partial matching and ignores case. Apply activates the filter.

Which formats and rows does the export contain?

Google's export instructions direct the operator to the report's export button, then a choice of Google Sheets, Microsoft Excel, or CSV. The download includes both chart and table data, and its row count includes the report's paginated rows.

The export is capped at 1,000 representative rows. Paging through the table does not extend that limit. Google specifies that exported totals retain the actual totals, without applying the row limit to them. Values displayed as ~ or -, meaning unavailable or not a number, become zeros in the downloaded data.

Why can totals differ from the exported rows?

Google's discrepancy guide explains that anonymized queries are rare queries omitted from the query table. Their data remains in chart totals unless a query filter is applied. The table limit also leaves some long-tail rows outside the table while their data remains in the chart total.

Filtering by page or query can produce matching and non-matching totals that fail to add up to the unfiltered total, because of anonymized queries and data truncation.

FAQ

Does the export include rows beyond the visible table page?

Yes. Google's export documentation includes paginated rows, subject to the 1,000-row limit.

Can I use a comparison before exporting?

Google's comparison instructions allow one comparison at a time. Adding another comparison replaces the existing one.

Why does my query-filtered total change?

Google's discrepancy guide says anonymized queries are included in chart totals unless a query filter is applied. Query filtering also encounters data truncation.

Sources

  1. Google Search Console Help, "Export data directly from a Search Console report", undated
  2. Google Search Console Help, "Performance report (Search results): Overview and basic setup", undated
  3. Google Search Console Help, "Performance report (Search results): Advanced filtering and comparison", undated
  4. Google Search Console Help, "Performance report (Search results): Troubleshooting data discrepancies", undated

Check how a page reads to answer engines. Open the GEO score analyzer

Test a page and see what to fix first

The analysis usually takes less than 10 seconds and needs no account.

400,000+ pages scored in the public benchmark