Skip to content

Content Inventory Generator

Before you rewrite, rebuild or audit a website, it helps to know exactly what you already have.

This free content inventory generator turns an easily generated Screaming Frog HTML crawl, and optional Google Search Console data, into an Excel workbook so you can see your pages and posts, spot old or orphaned URLs, and give yourself a better starting point for deciding what needs attention.

The tool runs in your browser. Your CSV files are not uploaded to this website, sent to me or stored by the plugin. Detailed instructions on getting the right Screaming Frog and Search Console exports are provided below the tool.

Free browser-based tool

Content inventory generator

Upload your Screaming Frog CSV and, if you have it, a Google Search Console Pages CSV. The tool creates a branded Excel workbook you can use as a practical content inventory.

Your data stays in your browser. The CSV files are processed locally. They are not uploaded to Ben Locker, WordPress or any third-party service by this tool.
How to get the CSV files

Screaming Frog

  1. Open Screaming Frog SEO Spider.
  2. Enter the HTTPS version of your homepage.
  3. Run the crawl.
  4. Go to Internal, filter to HTML, then export.

Open Screaming Frog SEO Spider

Google Search Console

  1. Open Search Console.
  2. Select Performance or Performance → Search Results in the left-hand menu.
  3. Set the date range. For an inventory, 16 months is often useful.
  4. Choose the Pages tab below the chart.
  5. Click Export and choose CSV.

Open Google Search Console

What you need

You can use the generator with just a Screaming Frog export.

For a better inventory, add a Google Search Console Pages export as well. This helps the workbook show pages Google has seen, including old or orphaned URLs that may not appear in a normal crawl.

How to get your Screaming Frog export

  1. Download and open Screaming Frog SEO Spider.
  2. Make sure it is in Spider mode.
  3. Enter your website homepage URL, using the correct https:// version.
  4. Click Start.
  5. Wait for the crawl to finish.
  6. Click the Internal tab.
  7. Use the filter dropdown and choose HTML.
  8. Click Export.
  9. Save the file as a CSV.

Upload that file into the Screaming Frog Internal HTML CSV field above.

The free version of Screaming Frog is usually enough for smaller sites, because it can crawl and export up to 500 URLs.

How to get your Google Search Console export

This step is optional, but extremely useful.

  1. Open Google Search Console.
  2. Choose the correct property for your site.
  3. Find the main performance report. Depending on your account, this may appear as:
    • Performance in the left-hand menu, or
    • Performance → Search results.
  4. Set the date range. For most content review work, 3 months is useful for recent activity. For a fuller inventory or audit, 16 months is best.
  5. Click the Pages tab below the chart.
  6. Click Export in the top-right corner.
  7. Choose CSV.
  8. If Google gives you a ZIP file, unzip it.
  9. Upload the Pages CSV into the Search Console field in this tool.

The Search Console export can help identify pages that Google has seen, including old URLs, orphaned URLs or pages that may not appear in a normal Screaming Frog crawl.

What the workbook gives you

The exported workbook includes:

  • A main inventory sheet
  • Screaming Frog crawl data
  • Matching Search Console data, if supplied
  • A separate sheet for Search Console URLs not found in the crawl
  • Raw source-data sheets
  • Example rows showing how to fill in the manual columns

It is an inventory, not a content audit. It helps you see what exists. The harder decisions come afterwards.

Need help interpreting the data?

If you have created your workbook and are not sure what it means, you have still done a useful part of the work.

The harder part is deciding what it means: which pages are still useful, which need work, which should be merged or redirected, and where important gaps remain.

A proper content audit can help turn the inventory into practical decisions.

A to me about a content audit

Q