Black Friday Offer

Pro is here. Save 50% on every license during Black Friday month.

00d 00h 00m 00s Claim the offer

Prepare your csv file

Updated October 31, 20262 min read

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.

ColumnRequiredWhat it does
nameYes, unless term_path is usedThe term name. Rows with an empty name are skipped.
slugNoThe term’s URL name. If it is empty, WordPress creates it from the name.
descriptionNoThe term description.
parent_slugNoThe slug of the parent term. The parent can already exist or be another row in the same file.
term_pathNoThe full hierarchy in one cell, such as Clothing > Men > Shirts. Missing parent terms are created.
custom_linkNoAn http or https address that the term links to instead of its archive page.
image_source (Pro)NoA 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.