---
title: "Export WordPress Pages to CSV: Titles, URLs, Parent and Template"
url: "https://wpimportexport.com/export-wordpress-pages-csv/"
description: "Export all WordPress pages to CSV or Excel with title, address, parent ID and parent title, menu order, template and status, and how to read each column."
type: post
published: 2026-11-09T08:03:21+00:00
modified: 2026-11-18T13:09:45+00:00
categories: ["Export Guides", "Tutorials"]
tags: ["Import Export by RockStarLab", "WordPress export"]
docs_topics: ["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](https://wordpress.org/plugins/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](https://wpimportexport.com/wp-content/uploads/2026/11/01-page-columns.webp)

_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](https://wpimportexport.com/csv-opens-in-one-column-excel-delimiter/) and [UTF-8 and BOM for Excel](https://wpimportexport.com/csv-utf-8-bom-excel-broken-characters/).

## 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](https://wpimportexport.com/how-to-export-all-site-urls-to-csv-or-excel-in-wordpress/).
- **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](https://wpimportexport.com/how-to-bulk-update-existing-wordpress-posts-without-creating-duplicates/). That import changes your pages, so [create a backup](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) first.

## With an AI agent

An AI agent connected through the WordPress MCP Adapter (see [connecting Claude Code to WordPress](https://wpimportexport.com/connect-claude-code-to-wordpress-mcp/)) 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](https://wpimportexport.com/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](https://wpimportexport.com/wordpress-csv-posts-export/)
- [Excel Shows #### or Wrong Dates, Lost Leading Zeros and Scientific Notation](https://wpimportexport.com/excel-leading-zeros-dates-scientific-notation-csv/)
- [How to Bulk Update Existing WordPress Posts Without Creating Duplicates](https://wpimportexport.com/how-to-bulk-update-existing-wordpress-posts-without-creating-duplicates/)
- [Build a 301 Redirect Map from Before and After URL Exports](https://wpimportexport.com/build-301-redirect-map-wordpress-url-export/)

Get the free plugin on [WordPress.org](https://wordpress.org/plugins/import-export-by-rockstarlab/).
