Back to blog
6 min read Content Sync

How to Import Posts with Categories and Tags from CSV

Moving posts from a spreadsheet into WordPress is only half done if every post lands in “Uncategorized”. Categories and tags carry the structure of a blog: archive pages, menus and related posts depend on them. A CSV import should assign existing categories, create the missing ones in the right place in the hierarchy, and leave the category list free of near-duplicates.

This guide imports posts with categories and tags from a CSV file with Import Export by RockStarLab (Free). Nine test posts cover the cases that usually go wrong: different spelling, parent and child categories, several values in one cell, an ampersand, accents and empty cells.

Short Answer

Add a categories column and a tags column to the CSV. Separate several values with a comma or a |, and write a subcategory as Parent > Child. Import the file as Blog Posts and click Auto Map: both columns are mapped to the category and tag taxonomies. Use version 2.1.12 or later; earlier versions did not map these columns and ignored taxonomies added by hand on the mapping step.

The CSV Layout

Column Example Meaning
categories News, Events Two categories
categories Recipes > Cakes Cakes as a subcategory of Recipes
categories Recipes > Tarts | News Tarts under Recipes, plus News
tags WordPress, Import Two tags

Columns named category or tag are recognised as well. Columns with other names, such as Section or Keywords, are mapped by hand, as shown below.

What the Test Import Did

The site already had the categories News, Food & Drink and Recipes with the subcategory Desserts, and the tag WordPress.

Value in the CSV Result
News, Events Existing News assigned, Events created
news (lower case) Existing News assigned, no duplicate
Recipes > Cakes Cakes created as a subcategory of the existing Recipes
Tips|Guides Two categories, Tips and Guides
Food & Drink Existing category assigned, no duplicate
Café Culture Created with the accent intact
Desserts Existing subcategory assigned
Empty cell The new post was placed in Uncategorized, as WordPress does by default
Recipes/Pies One category named “Recipes/Pies”; a slash is not a hierarchy separator

A deeper path works the same way: Food & Drink > Coffee > Espresso created Coffee under the existing Food & Drink and Espresso under Coffee. Running the same path again reused the existing categories instead of creating new ones.

Step 1: Upload the CSV

Open Import Export by RockStarLab → Import, choose Blog Posts and upload the file. The preview shows the category and tag cells as they will be read.

Import preview of a CSV with post titles, categories and tags columns
The preview shows the category and tag cells before the import.

Step 2: Map the Columns

Click Auto Map. The categories column is mapped to taxonomy_category and tags to taxonomy_post_tag, both read as term names.

Mapped fields with categories mapped to taxonomy_category and tags to taxonomy_post_tag
Auto Map maps the categories and tags columns to the category and tag taxonomies.

Columns with other names

For a column such as Section, scroll to Taxonomies in the list of WordPress fields and click + Add. Enter the taxonomy slug, category for categories or post_tag for tags, and choose how the cells identify the terms: by name, by slug or by ID. Then drag the column onto the new field.

Add Taxonomy Field dialog with taxonomy slug category and data format Term Name
Columns with other names are mapped by adding a taxonomy field by its slug.

Custom Taxonomies

Taxonomies added by a theme or a plugin, such as Topics or Locations, are imported the same way and are included in the free version, as long as they are registered for posts. A column named taxonomy_ followed by the taxonomy slug is mapped by Auto Map; for any other column name, add a taxonomy field with + Add and enter the slug. The slug is shown in the address bar on the taxonomy’s admin page, after taxonomy=.

In the test, the site had a hierarchical taxonomy Topics (slug topic) and a flat one, Moods (slug mood). The value Travel > Europe > Italy created three nested topics, and Calm, Curious two moods:

Posts list with Topics and Moods columns filled from the CSV
A hierarchical and a flat custom taxonomy, imported from the same file.

The > hierarchy only applies to hierarchical taxonomies, like categories. In flat ones, like tags, it stays part of the name.

Several Columns for One Taxonomy

Spreadsheets often spread categories over several columns, such as “Category 1” and “Category 2”, or “Topic” and “Subtopic”. Map each of them to the same taxonomy field: the importer combines their values and skips empty cells. In the test, a taxonomy_topic column and a Subject column mapped to the same taxonomy gave each post the terms from both.

Step 3: Import and Check

Start the import. All nine posts were created in 12 seconds. The Posts list shows the assigned categories and tags:

Posts list with imported test posts and their categories and tags
The imported posts with their categories and tags.

Under Posts → Categories, the new subcategory Cakes sits under Recipes next to the existing Desserts:

Categories list with Cakes and Desserts shown as subcategories of Recipes
Cakes was created under the existing Recipes, next to Desserts.

Updating Categories of Existing Posts

To change categories later, import a CSV with the same post titles or slugs and set If Match Found to Update. The categories and tags in the file replace the ones the post had; they are not added to them. In the test, a post that had News and Events was updated to Recipes > Desserts and afterwards had only Desserts.

Common Problems and Fixes

All posts end up in Uncategorized

The category column was not mapped. Check the mapping step: the column must point to a taxonomy field. Versions before 2.1.12 mapped neither categories nor taxonomy fields added with + Add, and still reported the import as successful; update the plugin and import again with Update.

“Parent > Child” became one long category name

The file was imported with a version before 2.1.12, or the separator was a slash. Delete the combined category under Posts → Categories and import again with > between the levels.

A category exists twice

The names differ in more than letter case, for example an extra space or a different dash. Matching ignores case and decodes &, but other differences create a new category. Rename the duplicate or use the exact name from Posts → Categories.

A category name contains a comma

Commas and | separate values. Identify such a category by its slug instead: choose Term Slug as the format when adding the taxonomy field.

FAQ

Are missing categories created automatically?

Yes. A name or slug that does not exist yet is created, including missing parent levels in a Parent > Child path.

Can I use category IDs?

Yes. Add the taxonomy field with Term ID as the format. IDs only work for categories that already exist on the target site.

Does it work with Excel files?

Yes. The columns are the same in XLSX files. The Excel import guide covers featured images in the same file.

Import Export by RockStarLab is free 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