How to export WordPress site data to CSV, XML, or Excel

Use WordPress XML when you want to move content to another WordPress site. The built-in exporter creates a WordPress eXtended RSS, or WXR, file containing content and related data rather than a spreadsheet. It can include posts, pages, comments, custom fields, categories, tags, custom taxonomies, and users.

Choose CSV or Excel when the file is going to a spreadsheet, accounting system, marketplace, or another structured-data tool. These formats are also more suitable when you need selected columns, custom filters, or a repeatable export.

In the WordPress dashboard, go to Tools > Export. Select All content, or choose Posts or Pages to expose filters for authors, dates, categories, and status. Click Download Export File and save the XML file somewhere outside the website.

You can import this file on another WordPress installation through Tools > Import > WordPress. This route is fine for a straightforward WordPress-to-WordPress content move, but it is not a full-site backup: themes, plugins, server settings, and the complete media library are not covered in the same way as a host or database backup.

The built-in exporter does not provide a general CSV or Excel download. It also only exports post types registered as exportable, so a custom post type may be absent if its registration disables exporting.

Do not rename a WXR file to .csv or open it in Excel expecting a useful table. You would need to write a script that reads the XML, selects fields, handles repeated values, and creates the spreadsheet. That is workable for developers, but it is a poor Friday-afternoon fix for a large site or a recurring job.

For CSV, XML, or Excel, install an export tool that supports the data type you need, then create a new export for posts, pages, users, WooCommerce data, or a custom post type. Build the output by selecting the fields and arranging them as columns or XML elements.

A structured export tool can expose standard fields, custom fields, taxonomies, order data, product data, and user data without making you query the database directly. WP All Export's documented workflow uses All Export > New Export, followed by a drag-and-drop field editor.

Use filters to limit the records before the export runs. Typical rules include date, status, author, category, price, order total, address, and custom-field values. Multiple rules can be joined with AND or OR; check this carefully because using AND when you mean OR can return no records.

Map each output field to the destination system's expected name and format. For CSV, confirm the delimiter and whether the first row contains column headings. For XML, confirm the root element, record element, nesting, and whether special characters need CDATA handling.

Run the export, download the file, and open it in a text editor or spreadsheet before relying on it. Check the record count, column headings, dates, prices, HTML, accented characters, images, repeated values, and custom fields. A field that appears blank may be stored as metadata, an array, or a serialized value and may need a different mapping.

Keep the original export in a restricted location and remove sensitive files from public uploads when they are no longer needed. For recurring structured exports, consider WP All Export Pro Premium for custom filters, field mapping, schedules, and WooCommerce support. It is suited to structured exports, not a replacement for a full-site backup.