A list of all pages with their addresses, parents and templates answers many questions: which pages a redesign has to cover, which ones still use an old template, where a page sits in the menu structure, or which drafts were never published. WordPress shows pages only one screen at a time. With Import Export by RockStarLab you can export them to a CSV or Excel file in a minute. The test site has 33 pages, some nested three levels deep, which shows which columns to choose and how to read them.
Free: export of pages and posts to CSV, XLSX, ODS, JSON and XML with all the columns below. PRO: custom post types, WooCommerce data, and transformations of values during export.
Short Answer
- Go to Import Export → Export and choose Pages.
- In step 3, add ID, Title, Permalink, Parent ID, Parent Title, Menu Order, Template and Status.
- In step 4, choose CSV or XLSX, click Start Export and download the file.
Exports only read your content, so you don’t need a backup for them.
Step 1: Choose Pages and, if needed, filter them
Open Import Export → Export, select Pages and click Next Step. Without filters the export includes pages of every status except trashed ones: published pages, drafts, private and scheduled pages. To list only live pages, add a filter Status equals Published. A Modified Date filter finds pages nobody has touched for a year.
Step 2: Add the page columns
In step 3, drag the fields from Available Fields into the export structure, or click them:

| Column | What it contains |
|---|---|
| Permalink | The full public address, including parent pages: /level-1/level-2/level-3/ |
| Parent ID | The ID of the parent page, or 0 for a top-level page |
| Parent Title | The title of the parent page, empty for a top-level page |
| Menu Order | The Order number from the page settings, used by themes and page lists to sort pages |
| Template | The template file chosen for the page, such as template-landing.php. Empty or default both mean the default template |
| Status | publish, draft, private, future or pending |
Add Slug, Date, Author or Word Count if you need them; Word Count helps to find thin pages.
Step 3: Export and read the file
In step 4, choose CSV (or XLSX for Excel), name the file and click Start Export. Part of our file:
| ID | Title | Permalink | Parent ID | Parent Title | Order | Template | Status |
|---|---|---|---|---|---|---|---|
| 174 | Level 1 | /level-1/ | 0 | 5 | publish | ||
| 173 | Level 2 | /level-1/level-2/ | 174 | Level 1 | 0 | publish | |
| 172 | Level 3 | /level-1/level-2/level-3/ | 173 | Level 2 | 0 | publish | |
| 12 | About Us | /about-us/ | 0 | 0 | template-landing.php | publish | |
| 10 | Services | /services/ | 0 | 0 | template-landing.php | publish | |
| 3 | Privacy Policy | /?page_id=3 | 0 | 0 | default | draft |
Some things to notice:
- Drafts have no pretty address. The Privacy Policy draft shows
?page_id=3because WordPress assigns the final address only when a page is published. - Addresses with non-Latin characters are encoded. A page with a Greek slug appears as
%ce%b5%cf%80…, exactly as WordPress stores the link. Browsers show it in readable form. - Sorting by the Permalink column groups each section: every child page follows its parent, because its address starts with the parent’s address.
If the file opens in one column or with broken characters in Excel, see CSV opens in one column and UTF-8 and BOM for Excel.
What to do with the list
- Redesign or theme change: filter the Template column to see which pages use a template the new theme doesn’t have.
- Redirect map before a migration: the Permalink column is the list of old addresses; see exporting all site URLs.
- Content audit: add Word Count and Modified Date and sort to find short or outdated pages.
- Bulk changes: edit titles or menu order in the file and import it back with matching by ID; see updating posts without duplicates. That import changes your pages, so create a backup first.
With an AI agent
An AI agent connected through the WordPress MCP Adapter (see connecting Claude Code to WordPress) can make the same list:
Export all published pages to CSV with ID, title, address, parent ID,
parent title, template and status, and tell me which pages don't use
the default template.
In our run, the agent called rsl-ie/export-start with export_type: page, post_status: ["publish"] and the fields ID, post_title, permalink, post_parent, parent_title, _wp_page_template, post_status. The file had 31 published pages with a header row; the agent reported “About Us” and “Services” as the two pages with template-landing.php.
FAQ
How do I export a list of all WordPress pages?
Choose Pages in Import Export → Export, add the columns you need in step 3 and export to CSV or XLSX. Without a status filter, drafts and private pages are included.
Can I see the parent page’s title, not just its ID?
Yes. Add the Parent Title column next to Parent ID. It’s empty for top-level pages.
Why is the Template column empty for some pages and “default” for others?
Both mean the default template. “default” is stored when someone chose the default template explicitly; empty means no template was ever chosen.
Why does a page’s address look like ?page_id=3?
The page is a draft or scheduled. WordPress assigns the final address when the page is published.
Are trashed pages exported?
No. The export includes published, draft, pending, private and scheduled pages, or only the statuses you filter for.
Related Guides
- How to Export All Site URLs to CSV or Excel in WordPress
- WordPress CSV Posts Export: Export Blog Posts to CSV, Excel, JSON, XML, and ODS
- Excel Shows #### or Wrong Dates, Lost Leading Zeros and Scientific Notation
- How to Bulk Update Existing WordPress Posts Without Creating Duplicates
- Build a 301 Redirect Map from Before and After URL Exports
Get the free plugin on WordPress.org.

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