Import terms from a CSV file
The importer creates new terms from a spreadsheet file in three steps: choose where the terms go, upload and map the file, then confirm.
Prepare your CSV file
The first row of the file must contain the column names. The file needs a name column or a term_path column. All other columns are optional.
| Column | Required | What it does |
| name | Yes, unless term_path is used | The term name. Rows with an empty name are skipped. |
| slug | No | The term’s URL name. If it is empty, WordPress creates it from the name. |
| description | No | The term description. |
| parent_slug | No | The slug of the parent term. The parent can already exist or be another row in the same file. |
| term_path | No | The full hierarchy in one cell, such as Clothing > Men > Shirts. Missing parent terms are created. |
| custom_link | No | An http or https address that the term links to instead of its archive page. |
| image_source (Pro) | No | A public image address. The image is downloaded into the Media Library. |
A simple file looks like this:
name,slug,description,parent_slug
Clothing,clothing,All clothing,
Shirts,shirts,Shirt collection,clothing
The same hierarchy written with a term path:
term_path,description
Clothing,All clothing
Clothing > Shirts,Shirt collection
Before you import, note the following:
- Comma, semicolon, and tab separators are detected automatically.
- Files that Excel saves as “Unicode text” or with Windows encoding are converted to UTF-8. Save files in other encodings as “CSV UTF-8” first.
- Rows can be in any order. Parent terms are always created before their children.
- The same name can be used under different parents, for example Men > Accessories and Women > Accessories.
- Common alternative column names are recognized, such as title for name, parent for parent_slug, and image_url for image_source.