---
title: "How to Export WordPress to Excel: Built-In Export vs a Plugin"
url: "https://wpimportexport.com/export-wordpress-to-excel/"
description: "WordPress Tools > Export only makes an XML file. See how to export posts, pages and more to an Excel spreadsheet with the columns and filters you choose."
type: post
published: 2026-11-12T11:00:00+00:00
modified: 2026-11-14T10:49:03+00:00
categories: ["Export Guides", "Tutorials"]
tags: ["CSV Export", "Import Export by RockStarLab", "WordPress Excel export"]
docs_topics: ["Export guides"]
---

# How to Export WordPress to Excel: Built-In Export vs a Plugin

Someone asks for “a spreadsheet of everything on the website”: a manager planning a content audit, an SEO consultant, a client before a redesign. WordPress has an export tool built in, but it doesn’t make a spreadsheet. Below, the built-in **Tools → Export** is compared with exporting to Excel through [Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/), and a coffee roastery’s blog posts go into an .xlsx file.

**Free:** posts, pages, comments, media and site URLs. **PRO:** custom post types, users, menus, taxonomy terms, WooCommerce data and database tables.

## Short Answer

- **WordPress Tools → Export** makes an XML file (WXR) for moving content into another WordPress site. Excel can open it, but you get tags and code, not a table.
- **To get an Excel file**, go to **Import Export by RockStarLab → Export**, choose the content type, pick the columns and choose **XLSX**.

## What the built-in export gives you

![WordPress Tools Export screen: it creates a WordPress eXtended RSS (WXR) XML file, with options for All content, Posts, Pages, Media and other types, and a Download Export File button](https://wpimportexport.com/wp-content/uploads/2026/11/01-wordpress-export-tool.webp)

_The built-in export makes an XML file for another WordPress site._

The built-in tool lets you choose all content or one type, with a few filters for posts (category, author, dates, status). The result is a WXR file: XML made for the WordPress Importer. Our blog’s posts came out as a 600 KB XML file where each post looks like this:

```
<item>
  <title><![CDATA[Nunc Scelerisque Viverra Mauris Aliquam]]></title>
  <link>https://www.example-roastery.com/2022/05/12/nunc-scelerisque-viverra-mauris-in-aliquam/</link>
  <pubDate>Thu, 12 May 2022 15:10:59 +0000</pubDate>
  <dc:creator>admin</dc:creator>
  <content:encoded><![CDATA[<!-- wp:paragraph --> …
```

That’s the right format for moving a site, but nobody wants to sort or filter it. You also can’t choose which fields go in, add a word count or a public link, or get users, products or orders the same way.

## Export to Excel with the plugin

**Step 1.** Choose what to export:

![Import Export by RockStarLab export step 1 with content types Blog Posts, Pages, Comments, All Site URLs, Media, Custom Post Types, Menus, Users, Taxonomy Terms, WooCommerce types and MySQL Database Table](https://wpimportexport.com/wp-content/uploads/2026/11/02-content-types.webp)

_Choose what to export; the free plugin covers posts, pages, comments, URLs and media._

Our screenshot shows the full list with PRO active. The free plugin has Blog Posts, Pages, Comments, All Site URLs and Media.

**Step 2.** Optionally filter: by status, date, category, author or a custom field. We exported all posts.

**Step 3.** Choose the columns. We added Title, Date, Status, Author Name, Category Names, Permalink and Word Count.

**Step 4.** Choose **XLSX** and give the file a name:

![Export step 4 with the XLSX format selected, Include Header Row checked and the file name all-posts](https://wpimportexport.com/wp-content/uploads/2026/11/03-xlsx-format.webp)

_XLSX gives you an Excel workbook._

The download was an Excel workbook with a header row and one row per post, 84 posts in our case:

| post_title | post_date | post_status | author_name | category_names | word_count |
| --- | --- | --- | --- | --- | --- |
| Coffee and Chocolate Pairing | 2026-11-09 11:14:11 | draft | admin | Uncategorized | 8 |
| Latte Art Workshop | 2026-11-09 11:10:53 | draft | admin | Uncategorized | 11 |
| Roastery Open Day | 2026-11-09 11:10:53 | draft | admin | Uncategorized | 10 |

Drafts are included unless you filter by Status equals `publish`. Numbers such as the word count are real numbers in Excel, so you can sort and add them up. If you prefer CSV, see [opening CSV files correctly in Excel](https://wpimportexport.com/csv-opens-in-one-column-excel-delimiter/).

## Side by side

|  | Tools → Export | Import Export by RockStarLab |
| --- | --- | --- |
| File format | XML (WXR) | XLSX, CSV, ODS, JSON, XML |
| Choose columns | No | Yes |
| Filters | Category, author, dates, status | Any field, custom fields, taxonomies |
| Extra columns (word count, permalink, image URL) | No | Yes |
| Users, WooCommerce products and orders | No | PRO |
| Schedule repeated exports | No | Yes |
| Best for | Moving a whole site to another WordPress | Spreadsheets, audits, reports |

## Before you edit and re-import

An export only reads your site. If you plan to change the spreadsheet and import it back, [back up the site](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) first and include the ID column, so the import updates the existing posts (see [updating posts without duplicates](https://wpimportexport.com/how-to-bulk-update-existing-wordpress-posts-without-creating-duplicates/)).

## 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 file from one sentence:

```
Export all our pages to Excel with ID, title, status, link and last modified date.
```

In our run, the agent called `rsl-ie/export-start` for pages in XLSX with those five fields. The job exported 33 pages, and `rsl-ie/file-get` returned `all-pages.xlsx` with its download link.

## FAQ

### Can I open the WordPress XML export in Excel?

Excel can open it, but you see XML elements, not one row per post. Use an XLSX or CSV export for a spreadsheet.

### Can I export WordPress users or WooCommerce orders to Excel?

Yes, with PRO. Users, products, orders, coupons and customers are separate content types.

### Does the Excel export include custom fields?

Yes. Add them from the Custom Fields or ACF Fields group on the column step.

### Can I export to Google Sheets?

Export to XLSX or CSV and open the file in Google Sheets.

### Can I import the Excel file back?

Yes. The importer reads XLSX, and Auto Map matches columns named after WordPress fields, like `post_title`.

## Related Guides

- [Export WordPress Posts by Category, Tag or Author to CSV](https://wpimportexport.com/export-posts-by-category-tag-author-csv/)
- [Export WordPress Posts with Featured Image URL and Categories to Excel](https://wpimportexport.com/export-wordpress-posts-featured-image-url-excel/)
- [How to Export WordPress Post Meta (Custom Fields) to CSV or Excel](https://wpimportexport.com/export-wordpress-post-meta-custom-fields-csv/)
- [How to Export All WordPress URLs to CSV or Excel](https://wpimportexport.com/how-to-export-all-site-urls-to-csv-or-excel-in-wordpress/)
- [Export WordPress Content for Translators and Import the Translations Back](https://wpimportexport.com/export-translate-reimport-wordpress-content/)

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