---
title: "Export Posts from One Category, Tag or Author to CSV"
url: "https://wpimportexport.com/export-posts-by-category-tag-author-csv/"
description: "Export only the WordPress posts of one category, tag or author to CSV or Excel, with readable Category Names and Tag Names columns. Filters explained."
type: post
published: 2026-11-09T09:02:42+00:00
modified: 2026-11-18T13:09:51+00:00
categories: ["Export Guides", "Tutorials"]
tags: ["Import Export by RockStarLab", "WordPress export"]
docs_topics: ["Export guides"]
---

# Export Posts from One Category, Tag or Author to CSV

Sometimes you need only part of the blog in a file: the posts of one category for a client, everything tagged with a product name for a review, or all posts of one author who is leaving. WordPress’s own Tools → Export can limit posts by category or author, but it produces an XML file meant for importing into another WordPress site, not a list you can open in a spreadsheet. With [Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/) you filter the posts by category, tag or author and export them to CSV or Excel. The filters and columns below make the file easy to read; the test site had 76 posts.

**Free:** filters by category, tag, author, status and date for posts and pages, export to CSV, XLSX, ODS, JSON and XML. **PRO:** the same for custom post types with their taxonomies and for WooCommerce product categories, plus transformations of values during export.

## Short Answer

1. Go to **Import Export → Export**, choose **Blog Posts** and click **Next Step**.
2. Click **Add Filter**, choose **Taxonomy Filter**, type **Categories** (or **Tags**) and the category names.
3. For one author, add another filter: **Author Name** equals the author’s display name.
4. Add the columns, including **Category Names** and **Tag Names**, and export to CSV or XLSX.

Exports only read your content, so you don’t need a backup for them.

## Step 1: Filter by category or tag

In step 2 of the export, click **Add Filter** and choose **Taxonomy Filter** in the Field list. Three boxes appear:

- **Taxonomy Name:** `Categories` or `Tags`. The internal names `category` and `post_tag` work too.
- **Condition:** **Has Term(s) – IN** for posts in any of the listed categories, **Has All Terms – AND** for posts in all of them, or **Does Not Have Term(s) – NOT IN** to leave a category out.
- **Terms:** one or more category names, separated by commas, for example `News, Events`. Slugs and IDs work as well.

Click the refresh button on the counter to see how many posts match. On our test site, the category “Uncategorized” had 20 posts.

## Step 2: Filter by author

Click **Add Filter** again and choose **Author Name**, condition **Equals**, and type the author’s display name as it appears in the Posts list. All filters must match, so the two filters together select one author’s posts in one category: 11 of the 20 posts were written by “Theme Buster”.

![Export step 2 with a Taxonomy Filter (Categories, Has Term(s) - IN, Uncategorized) and an Author Name filter equal to Theme Buster, Total Items Available 11](https://wpimportexport.com/wp-content/uploads/2026/11/01-category-and-author-filters.webp)

_Category and author filters together: 11 posts match._

Other author filters: **Author ID** if two authors have similar names, or **Author Email**. To export all authors but split them into separate files per month, see [exporting posts per author per month](https://wpimportexport.com/export-wordpress-posts-per-author-per-month/).

## Step 3: Choose readable columns

Click **Next Step** and add the columns. For a list that people will read in Excel or Google Sheets, these work well:

- **ID**, **Title**, **Date** and **Permalink** (the full address);
- **Category Names** and **Tag Names**: the names separated by commas, such as `Classic, Template, Uncategorized`;
- **Author Name**.

The columns in the Taxonomies group (Categories, Tags) contain more detail per term, such as slug, description and parent, so that the file can be imported again with the same categories. Use them when the file is a backup or goes to another site; use Category Names and Tag Names when the file is for people.

## Step 4: Export and check the file

In step 4, choose **CSV** or **XLSX**, name the file and click **Start Export**. Part of our file:

| ID | Title | Category Names | Tag Names | Date |
| --- | --- | --- | --- | --- |
| 1446 | Template: Excerpt (Generated) | Classic, Template, Uncategorized | content περιεχόμενο, excerpt, template | 2012-03-14 |
| 1241 | Template: Sticky | Classic, Uncategorized | sticky, template | 2012-01-07 |
| 1171 | Template: Paginated | Classic, Template, Uncategorized | content περιεχόμενο, pagination, template | 2012-01-08 |

Each post appears once, with all its categories, even when it belongs to several of the categories you filtered for.

Without a Status filter, drafts and scheduled posts are included too. Add **Status** equals **Published** if the list should show only what is live.

## Common uses

- **Hand over a section** of the blog to a client or a translator: one category, with Title, Content and Permalink.
- **Move one category to another site:** export it with all columns (or [push it with Content Sync](https://wpimportexport.com/how-content-sync-works-api-keys-push-pull/)) and import it there; see [importing posts from CSV](https://wpimportexport.com/import-wordpress-blog-posts-from-csv-excel/).
- **Review one author’s work** before they leave, or before reassigning their posts.
- **Clean up tags:** export posts with a tag and Tag Names to see which other tags they share.

## 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 build the same filter from a sentence:

```
Export the published posts in the category "Edge Case" to CSV with title,
category names, author, date and address.
```

In our run, the agent called `rsl-ie/export-start` with `taxonomy: [{"taxonomy": "category", "terms": "Edge Case", "condition": "in"}]`, `post_status: ["publish"]` and the fields `ID`, `post_title`, `category_names`, `author_name`, `post_date`, `permalink`. The file had 6 posts. The category’s slug on that site is `edge-case-2`, but the agent could use the name the user typed.

## FAQ

### How do I export posts from one category in WordPress?

In Import Export → Export, choose Blog Posts, add a Taxonomy Filter with Taxonomy Name “Categories” and the category name in Terms, then export to CSV or XLSX.

### Can I export several categories at once?

Yes. Type the names separated by commas. “Has Term(s) – IN” gives posts in any of them, “Has All Terms – AND” only posts that are in all of them.

### Can I combine category and author?

Yes. Add a Taxonomy Filter and an Author Name filter; a post is exported only when it matches both.

### Why does the Categories column contain JSON?

That column keeps the full term data for importing the file again. For a readable list, add Category Names and Tag Names.

### Do I need the category slug?

No. The name, the slug or the ID all work in the Terms box.

## Related Guides

- [WordPress CSV Posts Export: Export Blog Posts to CSV, Excel, JSON, XML, and ODS](https://wpimportexport.com/wordpress-csv-posts-export/)
- [Export Posts per Author per Month](https://wpimportexport.com/export-wordpress-posts-per-author-per-month/)
- [How to Export and Import WordPress Categories, Tags and Custom Taxonomies](https://wpimportexport.com/how-to-export-import-wordpress-categories-tags-custom-taxonomies/)
- [Export WordPress Pages to CSV: Titles, URLs, Parent and Template](https://wpimportexport.com/export-wordpress-pages-csv/)

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