Copy it from Google Sheets or Excel with the header row. A comparison export works too: we use the newer period.

Runs in your browser. Your export is not uploaded.

Settings

Separate spellings with commas. Brand searches get their own totals and are left out of the opportunity lists.

Our measure. Lower it for a small or new site, raise it for a big one.

Getting the export

  1. 1 In Search Console, open Performance › Search results and pick a date range, such as the last 3 months.
  2. 2 Below the chart, keep the Queries tab (or open Pages), then select Export and choose CSV, Excel or Google Sheets.
  3. 3 Upload the CSV here, or copy the table with its header row and paste it. If the download is a zip file, open it and use the Queries file.

Your opportunity lists appear here

Upload or paste a Search Console Performance export, or try the example: a dental clinic in Kothrud, Pune.

Free Search Console Opportunity Finder. Runs in your browser, no sign-up. Open the full tool on DigitalSnot →