---
title: "WordPress CSV Posts Export: Export Blog Posts to CSV, Excel, JSON, XML, and ODS"
url: "https://wpimportexport.com/wordpress-csv-posts-export/"
description: "Export all or selected WordPress posts to CSV or Excel with HTML, categories, tags, featured images and ACF fields. Follow the admin steps or use an AI agent."
type: post
published: 2026-08-13T12:58:18+00:00
modified: 2026-11-14T10:49:19+00:00
categories: ["Export Guides", "Import Export Guides", "Video Lessons"]
tags: ["export ACF fields WordPress", "Import Export by RockStarLab", "WordPress blog posts export", "WordPress CSV export plugin", "WordPress CSV Posts Export", "WordPress export posts to CSV"]
docs_topics: ["Export guides"]
---

# WordPress CSV Posts Export: Export Blog Posts to CSV, Excel, JSON, XML, and ODS

WordPress’s own export writes XML for another WordPress site; for a spreadsheet you need CSV or Excel. In **Import Export by RockStarLab → Export**, select **Blog Posts** and choose which posts and columns go into the file. CSV suits a file you will map into another system, XLSX opens directly in Excel.

Start with the question your file needs to answer. An editorial inventory usually needs a title, slug, status and date. Moving articles to another site also calls for the original body, excerpts, taxonomy terms and any custom fields the destination uses.

## 1. Select Blog Posts

Open the export wizard in WordPress admin, choose **Blog Posts** and click **Next Step**. Pages, products and custom post types have separate selections. If you only need a list of public links across the site, use the [site URL export](https://wpimportexport.com/how-to-export-all-site-urls-to-csv-or-excel-in-wordpress/) instead.

![Blog Posts selected as the WordPress export content type](https://wpimportexport.com/wp-content/uploads/2026/11/posts-01-type.webp)

_Choose Blog Posts to work with ordinary WordPress posts._

## 2. Export all posts or select a subset

Leave the filters empty to include all available posts. For a public content inventory, add **Status → Equals → publish**. An unfiltered file can include drafts, even when their titles never appear on the blog.

For a hand-picked set, choose **Add Filter → ID → In** and enter the numeric post IDs separated by commas. You can find a post’s ID in its edit URL after `post=`. Check **Total Items Available** before moving on. For a contributor handoff, select Author Email instead. For more combinations, see the [export filter examples](https://wpimportexport.com/wordpress-export-data-filters-examples-how-to-use-them-effectively/).

![Post ID filter with four comma-separated values](https://wpimportexport.com/wp-content/uploads/2026/11/posts-02-filter.webp)

_Use ID and In to select individual posts in one export._

## 3. Choose what goes into each row

In **Select Fields**, build the export file structure from the available fields. Each post gets a row in CSV. Use **Add all** beside an individual group when you need that whole group. For an editorial spreadsheet, keeping only the columns an editor will read makes the file easier to use.

![WordPress post export structure with selected field groups](https://wpimportexport.com/wp-content/uploads/2026/11/posts-03-fields.webp)

_Add the fields your spreadsheet needs from the groups on the right._

| Purpose | Fields to include | What to expect |
| --- | --- | --- |
| Identify a post | ID, title, slug, status, date | An ID identifies a post on the source site. Keep the slug as a second reference when moving between sites. |
| Preserve article content | Content and excerpt | The body contains stored markup, including HTML tags and Gutenberg block comments. The excerpt is a separate field and can be empty. |
| Retain categories and tags | Taxonomies → category and post tag | A CSV cell can contain a JSON list of terms with names, slugs and parent paths. A post with multiple tags still occupies one row. |
| Identify a featured image | Featured image URL, ID, title and caption | The URL points to the image file. The attachment ID belongs to the source site. An image embedded only in the body can appear in the HTML even if the featured image column is empty. |
| Include custom editorial data | Custom Fields or ACF Fields | Select the registered fields needed by the destination. A text field can be read directly, an ACF image can contain a URL, and a Repeater can contain an array of subfield values. |

For example, a travel guide might have a subtitle, cover image and a list of stops. Export the subtitle for a human-readable report. Include the Repeater when the destination also needs each stop’s name and duration. Keep that cell intact when transferring the data. If you need a separate inventory of attachments, follow the [Media Library export guide](https://wpimportexport.com/export-wordpress-media-library-to-csv-excel/). For an SEO audit, select the relevant metadata using the [Yoast title and description guide](https://wpimportexport.com/how-to-export-yoast-seo-titles-and-meta-descriptions-to-csv-for-an-seo-audit/).

## 4. Choose CSV, Excel, ODS, JSON or XML

Choose **CSV** when the destination expects delimited text. Keep the header row enabled and agree on the delimiter with the recipient. Choose **XLSX** for Excel, **ODS** for an OpenDocument spreadsheet, or **JSON** or **XML** when another application expects that format.

![CSV options with header row and export filename](https://wpimportexport.com/wp-content/uploads/2026/11/posts-04-format.webp)

_Keep the header row so each column can be identified during import._

Enter a filename without the extension. Keeping `{job_id}` in the name helps distinguish successive runs. Click **Start Export**. When the job finishes, compare **Items Exported** with the expected count, then click **Download Export File**. Enable **Download as ZIP** if you want a compressed download.

![Completed post export with the file ready to download](https://wpimportexport.com/wp-content/uploads/2026/11/posts-05-result.webp)

_Check the item count before downloading the file._

## 5. Read the file before handing it off

Open CSV using the spreadsheet application’s text import dialog if everything appears in one column. Select the delimiter used during export and UTF-8 for multilingual titles. A post body can contain quotation marks, commas and line breaks. Use a CSV reader that respects quoted cells rather than counting text lines to determine how many posts you have.

Pick one post you recognize. Compare the title and slug with its edit screen, open its featured image URL, and look for a known term in the taxonomy column. For a migration, keep the original download and follow the [WordPress post import and field mapping tutorial](https://wpimportexport.com/import-wordpress-blog-posts-from-csv-excel/) on the destination.

## Export posts with an AI agent

Connect your agent using the [WordPress Abilities API setup guide](https://wpimportexport.com/how-to-use-the-wordpress-abilities-api-with-ai-agents-exports-imports-content-sync-and-backups/). Specify the site, selection, fields and format in your prompt. For example:

> On the connected WordPress site, prepare a CSV inventory of published blog posts. Include ID, title, slug, date, categories and tags. Inspect the post export schema and preview the selection first. Tell me the proposed columns before starting.

> Export the posts with IDs [insert your IDs] to XLSX. Include their original content, featured image URL and the registered ACF subtitle field if available. Run the export, wait for completion, and return the download link, processed count and failed count. Leave the posts and settings unchanged.

The agent can inspect the available fields with `rsl-ie/get-content-schema`, preview with `rsl-ie/export-preview`, submit the job with `rsl-ie/export-start` and check the result with `rsl-ie/job-get`. A pending job still needs to finish before the file is ready. For a recurring report, see [how to schedule repeated exports](https://wpimportexport.com/how-to-schedule-repeated-exports-in-wordpress/).

## Video walkthrough

The video shows an earlier version of the export interface. Use the screenshots above for the current field picker and format settings.

[Video: WordPress CSV Posts Export | Export Blog Posts to CSV, Excel & JSON](https://www.youtube.com/watch?v=m6oy4w64qyc)

## FAQ

### Can I export WordPress posts to CSV?

Yes. Import Export by RockStarLab lets you export WordPress blog posts to CSV, including selected post fields and available custom fields.

### Can I filter posts before exporting?

Yes. You can use filters such as author email, title, date, status, and other available fields to export only specific posts.

### Can I export ACF fields with WordPress posts?

Yes. If Advanced Custom Fields is installed and fields are registered for the selected post type, ACF fields can be selected for export.

### Can I export ACF Repeater fields?

Yes. ACF Repeater field data can be included in the export file when available for the selected post type.

### Which export formats are supported?

The plugin supports CSV, JSON, XML, XLSX, and ODS export formats. You can also download the export file as a ZIP archive.

## Related Guides

- [Export WordPress Content for Translators and Import the Translations Back](https://wpimportexport.com/export-translate-reimport-wordpress-content/)
