Back to blog
5 min read Export Guides

Export WordPress Pages to CSV: Titles, URLs, Parent and Template

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

  1. Go to Import Export → Export and choose Pages.
  2. In step 3, add ID, Title, Permalink, Parent ID, Parent Title, Menu Order, Template and Status.
  3. 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:

Export step 3 with the columns ID, Title, Permalink, Parent ID, Parent Title, Menu Order, Template and Status, and Parent Title in Available Fields
Page columns: address, parent, order, template and status.
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=3 because 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.

Get the free plugin 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