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 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
- Go to Import Export → Export, choose Blog Posts and click Next Step.
- Click Add Filter, choose Taxonomy Filter, type Categories (or Tags) and the category names.
- For one author, add another filter: Author Name equals the author’s display name.
- 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:
CategoriesorTags. The internal namescategoryandpost_tagwork 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”.

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.
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) and import it there; see importing posts from CSV.
- 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) 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
- Export Posts per Author per Month
- How to Export and Import WordPress Categories, Tags and Custom Taxonomies
- Export WordPress Pages to CSV: Titles, URLs, Parent and Template
Get the free plugin on WordPress.org.

Comments 0
Have a question or a tip to share? Leave it below.