To import categories or custom taxonomy terms from Excel with Content Importer for WordPress & WooCommerce with Excel, go to WPFactory > Content Excel Importer Pro > Import Categories, select the taxonomy, upload an .xlsx file with name, description, slug and parent columns, and confirm the import.
Steps #
- Go to WPFactory > Content Excel Importer Pro and open Import Categories.
- Select the taxonomy in the dropdown, for example
category,post_tag,product_cat, an attribute such aspa_color, or a custom taxonomy. - Download the SAMPLE EXCEL FILE (headers TERM NAME, TERM DESCRIPTION, TERM SLUG, TERM PARENT).
- Fill in one term per row: column A name, B description, C slug, D parent term name (leave empty for top level).
- Choose the file, click the upload button and confirm “Are you sure you want to import the terms in the file?”.
- Wait for JOB DONE!. Each row shows “imported successfully” or “exists”.
Column rules #
| Column | Content | Notes |
|---|---|---|
| A | Term name | Required. |
| B | Description | HTML allowed; script tags are removed. |
| C | Slug | Cleaned into a valid slug. |
| D | Parent term name | Created first if it does not exist. |
| E | YITH color value | Optional, for attribute terms used by YITH WooCommerce Color and Label Variations (see the attribute values sample). |
Columns are read by position, so keep them in this order even if you rename the headers.
FAQ #
What happens to terms that already exist? #
A top-level term that exists is reported as “exists” and left as is. A child term that exists under a parent is updated with the description, slug and parent from the sheet.
Do I have to import categories before posts? #
No. Categories named in a post or product sheet are created during that import. Import categories first when you need specific slugs, descriptions or a nested structure.
How do I delete terms? #
Use the Delete Categories tab. See How to bulk delete posts, products and terms with Excel.
Ready to set this up? #
This is part of Content Importer, a paid WPFactory plugin: every screen described here is included with your license. Get Content Importer.
Need a hand? Our team answers every ticket on the Content Importer support forum.