How to use Search Console Export Analyzer
- Export matching Performance dimensions, property, search type and filters for comparable periods. Keep the period/filter details with each file.
- Choose One export or Compare two periods. Use pasted CSV or one file per period, clearing the alternative input; current means the newer period.
- For one export, select the review view and minimum impressions. These identify supplied candidates, not predicted gains. Comparison uses its own exact-label change table.
- Analyze the export, read skipped/total-row and presence notes, then download the report. Open previous-period inputs in More options when comparison is selected.
Example: Search Console Export Analyzer
Sum two supplied query rows to 15 clicks and 390 impressions, giving 15/390 = 3.85% CTR.
Options
- CSV rows
- Pasting is useful when you copied a few lines out of a spreadsheet. The same reading applies, so the first row naming Clicks and Impressions becomes the header wherever it falls.
- Search Console CSV (optional)
- The file you get from the Export button in the Performance report, saved as CSV. It stays on your device; the page never signs in to Search Console or calls its API.
- Compare two periods
- Current inputs hold the newer period; previous inputs are in More options. Rows join on exact labels. Absolute count deltas, relative percentages, CTR points and position improvement use current minus previous, except position improvement which is previous minus current.
- Current export view
- Review candidates in this export only. These views do not predict ranking gains or establish causes. Comparison keeps its own change table.
- Report
- For comparison, use matching dimensions and filters. Enter the newer period in the current inputs.
- Current period CSV rows
- Paste the exported rows, or leave this empty and choose the file. The first row naming Clicks and Impressions is treated as the header.
- Current period CSV file (optional)
- One UTF-8 file up to 8 MiB and 50,000 rows. Export it from Performance in Search Console. Use either this or the pasted rows, not both.
- Previous period CSV rows
- Required for comparison if you do not choose a previous file. Use the same dimension, property and filters.
- Previous period CSV file (optional)
- Comparison only. One UTF-8 CSV up to 8 MiB. Use either this file or the previous pasted rows.
Supported inputs and limits
- English metric headers; up to 8 MiB per UTF-8 file or 8,388,608 pasted characters, 50,000 data rows, twelve columns and 512-character labels.
- Candidate views use entered minimum impressions, no-click rows, CTR below this export’s mean or average position 8–20.
- Comparison joins exact labels; absent rows are not proof of zero real traffic.
- Export limits, anonymization, filters and aggregation affect the evidence.
- No Search Console login/API, query-volume estimate, causal diagnosis or ranking forecast.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
What an export can and cannot answer
An export contains selected report evidence, not a complete account history or an explanation of why traffic changed. Keep comparable dates, dimensions and filters, and review omitted/skipped rows before interpreting a delta. A below-average CTR or position 8–20 row may merit reading, but it does not identify a fix or establish potential traffic. Compare the actual page, query intent and available reporting evidence before deciding what to change.
Questions about Search Console Export Analyzer
Why can the totals differ from Search Console?
An export can omit rows, including anonymized queries. Filters and dimensions can also affect totals. This report adds the valid rows you supply and holds any Totals row aside. Check both exports use matching filters and comparable date ranges before interpreting a change.
Where is the export button?
Open Performance from the left menu, set the date range and the tabs you want, then use the Export button above the table and choose CSV. The export follows whatever filters and comparison you have set, so check those before you save the file.
Why does the average position differ from what I see in the report?
This tool weights supplied row positions by their impressions. Search Console’s chart uses the topmost result from the property, while a table row describes its URL or grouping dimension. Aggregation, omitted rows, filters and rounding can therefore prevent the exported-row calculation from matching the chart.
Is my export uploaded?
No. The file is read in this browser and the report is built from it locally. Nothing is sent to a server, and the download is created from the same text, so a property's data never leaves the device.
Does an item in only one export mean it is new or gone?
It means the item appears in only one of the supplied files. Export limits or filters can leave out traffic. The report labels that presence and treats missing exported counts as zero for arithmetic, while leaving unavailable CTR and position changes undefined.