- Create a column with a header named ‘Categories’.
- Under the ‘Categories’ header, each entry can have multiple categories assigned to it.
- The Categories must be separated by commas.
- The CSV fields must be enclosed by single or double quotes.
Here’s an example of what the category column for a single row should look like in the CSV file.
Categories "One, Two, Three"
The above would create three new categories, if they did not previously exist, and associate them to the entry being imported.
When editing in a spreadsheet application such as Excel or LibreOffice Calc, do not add quotes. The spreadsheet application will automatically add them as necessary.
Category hierarchy can not be imported. You must import the categories first. After the import is complete, you can edit the categories to set the parent categories to create the category hierarchy. When editing the categories, the relationships to the entries will be adjusted so no edits will have to be made to them to account for changing the category parents. Alternatively, you can import the categories first, including the hierarchy, first using the Category Import tool which does support bulk importing of nested categories.
If you are using a spreadsheet application to create your CSV file, do not add the open/closing quotes. When you save the CSV file from the spreadsheet, the spreadsheet will add the quotes automatically.