Back to blog
5 min read 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 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
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.

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.

Get the free plugin on WordPress.org.

Dmitriy
About author

Dmitriy

WordPress Developer with 15+ years of commercial experience. Elite Author on ThemeForest and creator of custom WordPress plugins. Passionate about clean code, performance optimization, and building useful tools for the WordPress community.

JOIN THE CONVERSATION

Comments 0

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

Leave a comment

Your email address will not be published. Required fields are marked *

We store your name, email and comment to show and moderate it; your email is never published. Spam protection is provided by Cloudflare Turnstile and profile pictures by Gravatar. See our Privacy Policy.


Try the plugin with no risks!

New users get 1 month with access to all premium features. Experience the most powerful WordPress data engine today.

Download Now
Get PRO for FREE