Export SERP Features: How to Download CSV or Excel Data

Quick Answer
To export SERP features, open a keyword or organic rankings report in an SEO tool such as Semrush, filter the results by SERP feature, and download the available data as CSV or Excel. Semrush supports feature-specific filtering and report exports. Ahrefs also offers CSV exports from supported reports. Google Search Console can export Search appearance performance for your own verified website, but it does not provide a complete inventory of competitors' SERP features.
The important part is knowing what you have downloaded. A feature appearing in search results does not necessarily mean your website owns it. Check the export's columns, filters, country, device, and observation date before drawing conclusions.
Key Takeaways
- Semrush is a practical starting point for exporting keyword rankings with SERP feature filters and domain participation information.
- Ahrefs supports report exports, including SERP Overview CSV downloads, but available fields depend on the report.
- Google Search Console serves a different purpose: it reports supported search appearances and performance for websites you control.
- Feature presence is not feature ownership. A featured snippet appearing for a keyword does not prove your domain occupies it.
- Keep the original export. Analyze a copy so you can trace your conclusions back to the source data.
- Check export limits and context. Missing rows, different markets, or mismatched dates can change your interpretation.
Where Can You Export SERP Feature Data?
SERP stands for *search engine results page*. A SERP feature is an element of the results page beyond a conventional organic listing, such as a featured snippet, image pack, or other enhanced result.
If you want to see which keywords produce these features, an SEO research platform can be useful. If you want to measure how your own website performed in certain search appearances, Google Search Console may answer a different, equally useful question.
Here is how the main export routes compare.
| Data source | What you can export | Best use | Important limitation |
|---|---|---|---|
| Semrush Organic Positions | Organic keyword and ranking report data, with SERP feature filtering and CSV or Excel export | Finding keywords associated with selected SERP features and checking domain participation | Presence and ownership must be interpreted separately; limits depend on the account |
| Ahrefs supported reports | Exportable tables, charts, and SERP Overview data in supported formats | Working with keyword, ranking, or SERP data already available in Ahrefs | Different reports contain different information; not every export supplies complete feature ownership fields |
| Google Search Console | Performance data with supported Search appearance filters | Understanding search performance for your verified property | Not a complete competitive SERP feature database |
| IndexNowFast Google Index Checker | URL index-status results as CSV | Auditing whether submitted URLs appear indexed | Does not report keyword SERP features or their ownership |
The Semrush Organic Positions guide documents feature-aware filters and spreadsheet exports. Ahrefs' export documentation confirms that eligible reports can be downloaded, while Google's export documentation explains the separate Search Console workflow.
For most readers who specifically want a downloadable keyword list filtered by SERP feature, start with the Semrush process below.
How to Export SERP Features From Semrush
Semrush's Organic Research Positions report provides a way to examine a domain's organic keyword rankings and filter results according to SERP feature information.
This is especially useful when you have a domain in mind and want to investigate which of its ranking keywords have enhanced search results.
Step 1: Open the Organic Positions report
Sign in to Semrush and navigate to Organic Research. Enter the domain you want to analyze and open the Positions report.
Choose the relevant geographic database before reviewing the keywords. For example, if you are preparing a report about visibility in the United States, select the appropriate US database rather than assuming worldwide and US results are interchangeable.
Semrush may change navigation labels or interface placement over time. Its Organic Positions documentation is the best reference for the current controls.
Step 2: Narrow the keyword results
A large domain may rank for many unrelated queries. Before exporting, decide which part of its keyword portfolio matters.
You could focus on a product category, a group of informational searches, or keywords containing a relevant phrase.
For instance, an analyst reviewing a home improvement website might examine queries about kitchen renovation costs rather than exporting every ranking keyword across the entire site.
Apply suitable keyword filters first. This makes the resulting file easier to understand and can reduce unnecessary export volume.
Step 3: Filter by SERP feature
Find the SERP Features filtering controls in the Positions report.
Semrush documents distinctions that include On SERP, Not on SERP, Domain ranks, and Domain doesn't rank.
These are not interchangeable conditions.
A feature can appear for a keyword without the analyzed domain occupying that feature. Conversely, when Semrush identifies domain participation in a supported feature, that is more specific than simply detecting its presence.
Suppose a query returns a featured snippet belonging to a competing website. Your domain may rank organically for the query, but it does not follow that your domain owns the snippet.
That is why the filter matters. If your goal is to investigate potentially relevant unoccupied features, you need a different view from someone preparing a report about features already associated with their website.
Use only the ownership distinctions that the selected tool and feature type actually support.
Step 4: Export the filtered report
Once the results match your intended scope, use the report's Export control.
Semrush documents Excel, CSV, and semicolon-separated CSV export options, subject to the report and subscription limits.
Choose the format that best suits your workflow:
- CSV: Useful for moving tabular data between spreadsheet applications and analysis tools.
- Excel: Convenient when your workflow primarily uses Microsoft Excel.
- Semicolon-separated CSV: Useful when your regional spreadsheet settings expect semicolons rather than commas.
If you have a choice of row quantities, select an amount that covers the filtered results you genuinely need and fits your account allowance.
Do not assume that the total number of displayed or estimated keywords equals the number of rows in the downloaded file.
Step 5: Check the downloaded data
Open the file and inspect its first few rows before using it in a report.
Confirm four things: the exported keyword set matches your filters; the market and device context are known; the file includes the feature information needed for your question; and the row count makes sense given the report's limits.
Also record the export date and the reporting period or database observation context. A file downloaded today may contain observations collected at different times, so the download timestamp alone is not always the measurement timestamp.
If a required feature ownership column is absent, do not invent it or assume that an empty field means the domain does not own the feature.
What about Semrush Keyword Magic Tool?
The Keyword Magic Tool offers another way to export keyword lists. Its official guide describes export options including CSV and XLSX, with choices for selected or grouped keywords.
This can be useful when your investigation begins with a topic rather than a particular domain.
However, an exported keyword discovery list is not automatically equivalent to an Organic Positions report. In particular, do not assume it contains identical domain ownership information. Choose the report according to the question you need answered.
How to Export SERP Data From Ahrefs
Ahrefs also supports downloadable research data, although its export workflow depends on which report you are using.
According to the Ahrefs report export guide, eligible graphs and tables have an Export control. In some reports, including parts of Keywords Explorer, the option may appear inside a three-dot menu.
Export a supported report
- Open the relevant Ahrefs report containing the keyword or SERP data you want to analyze.
- Apply the available keyword, country, or other relevant filters.
- Locate Export or the report's three-dot menu.
- Select the available export format and permitted row quantity.
- Download the file and inspect the resulting columns.
Ahrefs documents CSV exports and Google Sheets export functionality in supported areas, including Keywords Explorer. Google Sheets export requires an appropriate Google account connection and still consumes the applicable export-row allowance.
The number of rows you may export depends on subscription and report restrictions.
Export the SERP Overview
Ahrefs has a separate SERP Overview interface for inspecting search results associated with a keyword.
Its SERP Overview documentation describes exporting the overview's 100 results to CSV.
That is useful for examining the result listings included in the overview. But it is not necessarily the same as exporting a broad keyword portfolio with individual SERP feature ownership classifications.
Think of the distinction this way:
- A keyword report helps you examine many keywords, depending on its available fields.
- A SERP Overview helps you inspect the results returned for a particular keyword.
Neither export should be assumed to include information that the actual report does not display or document.
Ahrefs' SERP features guide also explains that feature types differ in how their source URLs or ranking participation can be identified. That matters when you want to compare feature ownership across keywords.
Which Ahrefs export should you choose?
Start with the decision you want to make, not the file format.
If you want to review the results for a particular query, investigate SERP Overview. If you want a broader set of keywords for analysis, use an appropriate keyword or ranking report and verify which feature-related fields it provides.
For ongoing comparisons, retain the report name, selected filters, country, and date alongside the exported rows.
A CSV file is only a container. It does not tell you whether the observations are complete, directly comparable, or suitable for a particular SEO conclusion.
Can Google Search Console Export SERP Features?
Google Search Console can export performance information about supported search appearances for a website you control. But it should not be treated as a direct replacement for a competitive SERP feature report.
The distinction is important because the sources measure different things.
A third-party SEO platform may observe that a search results page contains a particular feature. Search Console instead reports Google's performance data for your verified property under its supported reporting dimensions.
How to export Search appearance data
Open Google Search Console and select the relevant verified property.
Navigate to the Search results Performance report. Where Search appearance filtering is available, select the appropriate reported appearance type. Review the applied search type, dates, country, device, and any other filters.
Then use the Export control and choose one of the supported output formats: Google Sheets, Microsoft Excel, or CSV.
Google's Search Console export instructions confirm those formats and explain that the downloaded data generally reflects the report's applied filtering and grouping.
Understand the 1,000-row interface limit
Google states that directly exported report tables are limited to 1,000 representative rows.
This is especially important for large websites. The totals displayed in a report may include observations beyond the rows available in a direct export.
For example, a report showing a substantial number of impressions does not mean its exported query table must contain every search query contributing to those impressions.
Google also applies privacy protections and query reporting limitations. Its Performance report documentation explains that anonymized queries and data truncation can affect which rows are visible.
Do not use the exported row count as a complete count of every relevant search query.
Search appearance is not universal feature tracking
Another limitation is that Search Console only exposes supported appearance types associated with the property's reported data.
The absence of a particular Search appearance filter does not prove that the corresponding kind of feature never appears in Google results for your keywords.
Likewise, a click recorded under a search appearance filter is not necessarily a click directly on the visual feature element itself. Google's reporting definitions and aggregation rules matter.
The Search appearance dimension documentation provides the relevant distinctions.
Use Search Console for questions such as: How did my website's reported search performance change during a selected period? Which supported search appearances are represented in the data? Which pages or queries deserve further investigation?
Use competitive SERP research tools when the task is to investigate feature presence across keywords, including features your site does not occupy.
How to Turn Your Export Into a Useful SERP Feature Spreadsheet
Downloading the file is the easy part. The value comes from preserving what the data actually measures.
A useful spreadsheet should make it possible to answer three questions:
- Which keywords have a reported SERP feature?
- For which of those keywords is the analyzed domain actually identified as participating in that feature?
- Which observations need further investigation because the available information is incomplete?
The following structure helps answer those questions without assuming every vendor exports identical columns.
Keep a raw copy and a separate analysis sheet
Save the original export without changing its values. Then create a working worksheet for your analysis.
This simple separation matters. If you rename columns, combine reports, or add your own classifications, you should still be able to return to the unmodified source file.
A useful normalized worksheet could contain these fields:
| Field | What it records | Why it matters |
|---|---|---|
| keyword | The search query being examined | Identifies the search intent and unit of analysis |
| country | The selected geographic market | Prevents comparisons between different markets |
| device | Desktop, mobile, or other supported context | Search results can differ by device |
| observed_date | Date or period associated with the observation | Helps prevent misleading time comparisons |
| source_tool | Semrush, Ahrefs, or another source | Preserves the origin of the information |
| feature_type | The reported SERP feature | Allows feature-specific analysis |
| feature_present | Whether the feature was observed | Distinguishes presence from absence |
| domain_owns_feature | Whether the analyzed domain was identified in the feature | Separates ownership from presence |
| ranking_url | URL associated with a relevant result, if available | Helps identify the page involved |
| notes | Filter details, missing fields, and limitations | Keeps assumptions visible |
These are recommended analysis fields, not a claim that every platform provides each field in its native export.
For missing information, use a consistent value such as UNKNOWN. Do not automatically replace unavailable observations with NO or zero.
A blank ownership field may mean the platform did not provide that measurement, not that the website failed to occupy the feature.
Classify the rows correctly
Use the following decision framework when the exported data supports the necessary distinctions.
| Observed feature | Verified domain participation | Recommended interpretation |
|---|---|---|
| Yes | Yes | The tool reports the domain participating in the selected feature; review the associated URL and observation context |
| Yes | No | The feature appears without identified domain participation; investigate whether the keyword matters to your site |
| Yes | Unknown | The feature is present, but ownership cannot be determined from the available export |
| No | Not applicable | The selected feature was not observed within the recorded report scope |
| Unknown | Unknown | Insufficient evidence; do not classify as a confirmed opportunity or absence |
This classification is a reusable analysis method, not a vendor-provided scoring formula.
It deliberately avoids treating every feature as an immediate SEO opportunity. A feature may exist for a query that is irrelevant to your business, or the feature may not be realistically available to the kind of page you operate.
A worked example
Consider a hypothetical export with 200 keyword records.
Suppose 80 records show a selected SERP feature. Among those 80, suppose 20 identify the analyzed domain as participating in that feature, while the remaining 60 explicitly identify no domain participation.
The basic classification is:
- 200 total keyword records examined.
- 80 records with the selected feature observed.
- 20 feature-bearing records with identified domain participation.
- 60 feature-bearing records without identified participation.
The feature presence rate within this hypothetical exported set is 80 divided by 200, or 40%.
The observed participation rate among those 80 feature-bearing records is 20 divided by 80, or 25%.
These percentages describe only the invented example dataset. They are not industry benchmarks, measured study results, or predictions of what any real website should achieve.
Most importantly, the 60 records without identified ownership are not automatically 60 achievable wins.
Before treating any one of them as a useful opportunity, ask whether the keyword is relevant, whether the website has an appropriate page, what the existing results satisfy, and whether the feature is meaningfully attributable to a domain.
If ownership data is missing rather than explicitly negative, place those records in the UNKNOWN category instead of the 60-record group.
That one distinction prevents a significant analytical error: confusing unmeasured feature ownership with confirmed lack of ownership.
Avoid false comparisons between exports
Two files can both contain SERP feature information and still be unsuitable for a direct comparison.
Imagine one export uses US mobile search data and another uses desktop results from a different market. A difference in observed features may reflect the selected search environment rather than a genuine change in the domain's visibility.
The same problem arises when tools use different feature definitions, different collection dates, or different rules for attributing features to URLs.
When comparing files, verify the keyword set, geographic scope, device, feature definition, observation period, and data provider.
If those conditions cannot be aligned, report the limitation rather than claiming a precise improvement or decline.
Why Your SERP Feature Export May Be Missing Data
An incomplete-looking file does not necessarily mean the export failed. Often the issue is the report's scope or account restrictions.
Here are the checks worth making before repeating the download.
Your filters may exclude relevant keywords
Review active keyword, feature, country, and ranking filters.
A report restricted to a particular feature will naturally exclude other feature types. Similarly, a filter requiring domain participation may exclude searches where the feature is present but the domain does not occupy it.
If your goal is broad discovery, start with a wider relevant keyword set, then narrow the analysis. If your goal is an ownership report, keep the ownership filter explicit.
Your plan may limit export rows
Semrush documents report and subscription restrictions. Ahrefs also counts exported rows against applicable subscription allowances.
If the requested export exceeds an account's limits, reduce the scope or check the current plan's available allowance. Do not assume that selecting a higher row quantity is available to every account.
The Ahrefs export troubleshooting guide explains several restrictions that can prevent a download or make an export option unavailable.
Your report may not contain the desired feature field
Not every keyword report contains identical SERP feature information.
A general rankings export might not include the same ownership distinctions as a feature-specific report. Likewise, an individual SERP Overview export should not be assumed to include a full historical keyword portfolio.
Before switching tools, inspect the available report columns and confirm whether the information you want is supported there.
If the source cannot establish ownership, record that limitation explicitly.
Your spreadsheet may import CSV incorrectly
Sometimes the downloaded data is present but appears misaligned in a spreadsheet.
For example, software configured for semicolon-separated files may not automatically divide a comma-separated CSV into the intended columns.
Use the spreadsheet application's import function, confirm the delimiter, and inspect several rows. Also check character encoding if international keywords appear incorrectly.
Avoid manually replacing commas throughout the file; that can damage legitimate keyword text or other field values.
Your dates may not match
A report export, an observation snapshot, and a Google Search Console performance range can represent different measurement periods.
A file's creation date tells you when you downloaded it, not necessarily when the underlying search result was observed.
Keep the applicable reporting period or observation date with the data. If the provider does not expose enough timing information, do not make a precise before-and-after claim.
Search Console may omit query rows
Google's direct export limit and privacy filtering can leave some queries out of the downloaded table. Those omissions are part of the reporting system, not proof that the missing searches had no impressions.
For deeper Search Console analysis, consult Google's official documentation about Performance report dimensions and data limits. The right reporting method depends on the question and the amount of data involved.
SERP Feature Exports and Index-Status Exports Are Different
SEO workflows often use CSV files for several kinds of search data. That can make the terminology confusing.
A SERP feature export describes selected aspects of search results associated with keywords. An index-status export describes whether particular URLs appear indexed according to the checking system and its observation method.
These are different questions.
For example, the IndexNowFast Google Index Checker supports bulk URL checks and exporting index-status observations to CSV. Its documented workflow helps users review URL indexing and investigate potential technical issues.
It does not establish which SERP features appear for a keyword or whether a specific website owns a featured snippet.
Likewise, an indexed page does not automatically rank for a target keyword or appear in a special search result.
Keep indexing checks, rankings, feature presence, and feature participation as separate measurements. Combining them in a wider SEO report can be helpful, but only when the labels and source methods remain clear.
For broader reading about URL indexing and related search workflows, the IndexNowFast SEO guides provide additional context.
What Should You Do After Exporting?
Start with a small set of keywords that matters to your website or client. You do not need thousands of rows to get useful answers.
First, identify which exported keywords show the feature you are investigating. Next, separate verified domain participation from feature presence alone. Then review the pages and search intent behind the keywords that remain relevant.
For a content-focused website, the next step might be checking whether an existing article gives a clear answer to the query. For an ecommerce website, it could involve identifying whether the current results favor product pages, category pages, or informational content.
Those are editorial and SEO judgments, not conclusions a CSV file can make automatically.
When presenting your findings to someone else, describe both the observation and its limit. For example, saying that a tool reported a selected SERP feature for certain keywords is more defensible than claiming the website lost those features without historical ownership evidence.
Save the original file, document the conditions of the export, and revisit the analysis when meaningful new observations are available.
The best SERP feature export is not necessarily the largest spreadsheet. It is the one that lets you answer a specific question while preserving enough evidence to explain your answer.
Frequently Asked Questions
Can I export SERP features to CSV?
Yes. Semrush supports feature-aware Organic Positions reports with CSV and Excel export options. Ahrefs also supports CSV exports in eligible reports. The actual feature information available depends on the source report and account permissions.
Does Ahrefs export the same SERP feature data as Semrush?
Not necessarily. The platforms use different reports, feature definitions, and export structures. Compare the documented fields and actual downloaded columns before combining their data.
Can I export SERP features directly from Google Search Console?
You can export supported Search appearance performance for a verified property. However, Search Console does not provide a complete list of every SERP feature appearing for every keyword or every competing domain.
Does a SERP feature appearing in an export mean my website owns it?
No. Feature presence means the reporting tool observed the feature within its measurement scope. Ownership or participation is a separate question that requires additional information about whether the analyzed domain occupies that feature.
Why does my CSV contain fewer rows than expected?
Possible reasons include active filters, subscription export limits, the selected report's coverage, and source-specific reporting restrictions. Google Search Console also limits direct report table exports to 1,000 representative rows.
Can I combine SERP feature exports from different tools?
Yes, but preserve the original files and normalize fields carefully. Confirm that keyword, country, device, feature definitions, dates, and ownership classifications are compatible. Where they are not, retain separate values or mark the comparison as uncertain.
Is an index-checker CSV the same as a SERP feature export?
No. An index-checker CSV concerns observed URL index status. A SERP feature export concerns keyword search results and selected special features. Neither measurement proves the other.
Will exporting SERP features improve my rankings?
Exporting data does not directly improve rankings. It can help you identify relevant questions, inspect existing results, and prioritize further work. Search engines ultimately determine which pages rank and which features appear.
---