Back to blog
6 min read Export Guides

WordPress Content Inventory: Export All Pages with Dates, Authors and Status

Before a redesign, a migration or an SEO cleanup, someone always asks the same thing: what is actually on this site? How many pages, which ones are still drafts, who wrote them, when they were last touched, and which have no meta description. A content inventory answers that in one spreadsheet, with one row per page or post.

WordPress has no inventory screen, and its built-in export produces an XML file for moving content, not a list you can sort. With Import Export by RockStarLab (free) you export a complete inventory to CSV or Excel: address, status, dates, author, word count, parent page, template and Yoast SEO fields, plus an empty column for your decisions. The example is a small coffee roaster’s site with 11 pages and 6 posts, exported with version 2.1.16 of the plugin.

Short Answer

  1. Go to Import Export by RockStarLab > Export and choose Pages.
  2. Skip the filters to include every page, including drafts, private and scheduled ones.
  3. On Select Fields, add ID, Title, Permalink, Status, Date, Modified Date, Word Count, Author Name, Parent ID and Template. Add Meta Description from the Yoast SEO or Rank Math group if you use one. Then click Add Custom and name the column “Action”.
  4. Choose CSV or XLSX, export and open the file in your spreadsheet. Repeat for Blog Posts.

What to Put in a Content Inventory

Column Field in the export What it tells you
ID Standard > ID A stable key for every row, useful if you later update the pages from the same file
Title Standard > Title What the page is
Address Standard > Permalink The full public URL, including parent pages (/services/wholesale/)
Status Standard > Status publish, draft, private, future (scheduled) or pending
Published Standard > Date When it first went live
Last updated Other > Modified Date When anyone last saved it: the best signal for stale content
Length Standard > Word Count Words in the content, without HTML and shortcodes
Owner Author > Author Name Who to ask about it
Structure Other > Parent ID, Template Where the page sits in the hierarchy and which layout it uses
SEO Yoast SEO / Rank Math > SEO Title, Meta Description Which pages have no meta description or a duplicate title
Decision Add Custom > “Action” An empty column for keep, update, merge, redirect or delete

For posts, add Categories and Tags from the Taxonomies group if you need them. They are exported in a structured form (name, slug and parent) that the plugin can import again, so they are easier to read with a spreadsheet filter than by eye.

Step 1: Choose the Content Type

Open Import Export by RockStarLab > Export and choose Pages. On the Filter Data step the counter shows how many pages will be exported. On our site it found all 11, including one draft and one private page. Leave the filters empty for a full inventory. The next section shows how to use them for a quick audit.

Step 2: Choose the Columns

On Select Fields, drag the fields from the list on the right into Export File Structure. The order you drop them in is the column order in the file. Then click Add Custom, type Action and confirm. That adds an empty column where you can note what should happen to each page.

Export Select Fields step with ID, Title, Permalink, Status, Date, Modified Date, Word Count, Author Name, Parent ID, Template, Meta Description and a custom Action column
The inventory columns, including Permalink, Word Count, the Yoast meta description and an empty Action column.

Only fields that your site uses appear: the Yoast SEO group shows up when Yoast SEO is active, the Rank Math SEO group with Rank Math, and ACF Fields with ACF. Custom Fields lists the other meta keys found on the site.

Step 3: Export and Open the File

On the next step choose CSV (or XLSX for Excel), start the export and click Download Export File. This is the file opened in a spreadsheet, with the Action column filled in by hand and three simple highlights:

Content inventory spreadsheet of 11 pages with title, permalink, status, modified date, word count, author, meta description and action
The exported inventory in a spreadsheet, with the Action column filled in by hand and stale pages, short pages and missing meta descriptions highlighted.

A few things stand out at once:

  • Five published pages have not been edited since 2023 or earlier, including an old holiday gift guide.
  • Two published pages have fewer than 100 words.
  • Seven pages have no meta description.
  • A private “Careers” page and an empty draft are still waiting for a decision.

Then repeat the export for Blog Posts. On our site that file had 6 rows, including a scheduled post (future) and a draft.

Audit Faster with Filters

The Filter Data step answers single questions without opening a spreadsheet: the counter at the top updates as soon as you set a filter. These two filters find every published page that nobody has touched since the start of 2024:

  • Modified Date · Less Than · 2024-01-01
  • Status · Equals · publish
Export Filter Data step with Modified Date less than 01/01/2024 and Status equals publish, 5 items found
Five published pages have not been modified since before 2024.

Other useful checks:

  • Status · Not Equals · publish lists every draft, private, pending and scheduled item.
  • Content · Is Empty finds pages with no content at all.
  • Author Email · Contains · a former employee’s address finds the pages they own.
  • Content · Contains · an old domain or product name finds pages that still mention it.

Export the filtered list to work through it, or click Previous and change the filter for the next question.

Notes on the Columns

  • Permalink of drafts. A draft has no public address yet, so its permalink is the preview form (?page_id=1009). A private page shows its normal address, which only logged-in users with access can open.
  • Word count and page builders. The count covers the post content, without HTML tags and without shortcodes that are registered on the site. Pages built with a page builder that stores its layout outside the post content, or pages that are only a shortcode (such as a shop or account page), show a low count or 0 even if the page looks full.
  • Modified Date changes on any save, including small fixes. Treat it as “last touched”, not “last reviewed”.

Keep the Inventory Up to Date

An inventory is most useful when you compare it over time. Name the files with the date (the Custom export file name field on the format step), export again before every larger change, and compare the files to see what was added, removed or edited.

FAQ

Does the inventory include drafts and private pages?

Yes. Drafts, private, pending and scheduled items are included unless you filter them out with the Status field.

Can I export pages and posts into one file?

Each export covers one content type, so you get one file for pages and one for posts. Put them on two sheets of the same spreadsheet, or paste one below the other, because the columns are the same.

Can I export custom post types or WooCommerce products?

Custom post types, products and other types need the Pro add-on. The same columns are available there.

Can I use the inventory to change the pages?

Yes. Because the file contains the ID and the slug, you can edit columns such as the status or meta description in the spreadsheet and import the file back in update mode, matching by ID or slug. Make a backup before you do, as described in How to Create a WordPress Website Backup and Restore It.

Import Export by RockStarLab is free on WordPress.org.

Dmitriy
About author

Dmitriy

WordPress Developer with 15+ years of commercial experience. Elite Author on ThemeForest and creator of custom WordPress plugins. Passionate about clean code, performance optimization, and building useful tools for the WordPress community.

JOIN THE CONVERSATION

Comments 0

Have a question or a tip to share? Leave it below.

Leave a comment

Your email address will not be published. Required fields are marked *

We store your name, email and comment to show and moderate it; your email is never published. Spam protection is provided by Cloudflare Turnstile and profile pictures by Gravatar. See our Privacy Policy.


Try the plugin with no risks!

New users get 1 month with access to all premium features. Experience the most powerful WordPress data engine today.

Download Now
Get PRO for FREE