How to Filter and Export the Keywords You Need: Workflows by Tool

To filter and export keywords, first determine how you will use the data, then narrow the results within the tool, select the items you need, and export them. To track your website’s search performance, consider Google Search Console’s Performance report; to collect related terms, consider Keyword Surfer’s keyword collections; for competitive analysis, refer to Semrush’s report-filtering examples. The workflows below reflect the features described when each source was published, not necessarily the current interfaces or limits of these tools.

Tracking Website Performance: Narrow the Results by Query and Page

A tutorial published by Welly in 2022 explains that Google Search Console’s Performance report lets you adjust the search type and date range and add filters for queries, pages, countries/regions, devices, and search appearance. These filters help answer questions such as “Which search keywords bring up a particular article?” or “How is a particular keyword performing?”

1. Open the Performance report and set the date range and search type you want to examine.
2. To track a specific article, filter by its page URL; to track a specific term, enter the keyword in a query filter.
3. Review the clicks and impressions in the query list below. According to the tutorial, selecting average CTR or position also displays the corresponding data in the table.
4. Use the export function at the top right of the report to export the data to Google Sheets, Excel, or CSV.

For example, to compile search performance data for a single article, first filter the data by that page and then review its query list, rather than searching through site-wide data row by row. The locations and labels above reflect the interface described in that tutorial.

Collecting Related Terms: Add the Terms You Need to a Collection, Then Export

A 2025 overview on Neil Patel’s website states that Keyword Surfer can display monthly search volume for a selected region within the Google search interface and provide related keyword suggestions and search volumes in a sidebar. This workflow focuses on collecting candidate keywords, rather than viewing a performance report for a particular article.

• Search for a topic keyword and review related suggestions and search volumes for the selected region.
• Add the terms you want to keep to a keyword collection.
• Export the collection as a CSV file.

The overview describes creating a collection and then exporting it, but does not give the full sequence of buttons to click or specify export limits. You will still need to check these details when using the tool.

Competitive Analysis: Distinguish Between Exporting Selected Items and an Entire Report

A 2016 Semrush article states that, at the time, its organic and advertising Positions and Position Changes reports allowed users to select keywords and then choose Export Selected from the Export menu at the top right of the table. The article emphasizes filtering within the report and deciding which terms to keep first, reducing the cleanup needed after export.

However, that version had an important limitation: moving to another page cleared the selections on the previous page, so selected items had to be exported one page at a time. Export All was available only for Custom Reports at the time. These are historical feature descriptions and should not be treated as current restrictions. The approach remains useful: first identify the keywords you need, then check whether you are exporting selected items, a subset of results, or all data. The actual steps still need to be checked against the version you are using.