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
- Go to Import Export by RockStarLab > Export and choose Pages.
- Skip the filters to include every page, including drafts, private and scheduled ones.
- 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”.
- 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.

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:

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

Other useful checks:
- Status · Not Equals ·
publishlists 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.
Related Guides
- How to Export WordPress Content to JSON for AI and LLMs
- WordPress Tools > Export limitations: what the built-in exporter doesn’t move
- How to migrate only posts and pages to a new WordPress site
- Images still point to the old domain after migration? How to fix them
- CSV import shows broken characters? Fix UTF-8, Excel and accents
- Content Production Report: Export WordPress Posts per Author and per Month
Import Export by RockStarLab is free on WordPress.org.

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