In Search Console, open the Page indexing report, then export the table as CSV, or open it in Google Sheets and copy the rows with their header row.
One reason a line with its page count also works, for example "Soft 404 9".
Check the columns
We matched them from the header row or the values. Change any that are wrong.
Needed. The "Reason" or issue name.
The number of pages for the reason.
Optional. For example "Website".
Optional. The validation state.
Open a reason in the report and export its examples. Paste each list under a line with the reason's name, and we group the URLs by folder, parameter and pagination.
A URL column with "Last crawled" next to it is fine too. Up to 20,000 URLs.
Runs in your browser. Your export is not uploaded, and we never sign in to Search Console.
Free Search Console Page Indexing Analyzer. Runs in your browser, no sign-up. Open the full tool on DigitalSnot →