Flat List Format
In the flat list format, there is only one top level of categories without any hierarchy, meaning no subcategories or subnets. Category names are in a single column.
The following information can be contained in a file of this format:
- Optional codes column contains numerical values that uniquely identify each category. If you specify that the data file does contain codes (Contains category codes option in the Content Settings step), then a column containing unique codes for each category must exist in the cell directly to the left of category name. If your data does not contain codes, but you want to create some codes later, you can always generate codes later (Categories > Manage Categories > Autogenerate Codes).
- A required category names column contains all of the names of the categories. This column is required to import using this format.
- Optional annotations in the cell immediately to the right of the category name. This annotation consists of text that describes your categories/subcategories.
- Optional keywords can be imported as descriptors for categories. In
order to be recognized, these keywords must exist in the cell directly below the associated
category/subcategory name and the list of keywords must be prefixed by the underscore
(
_
) character such as_firearms, weapons / guns
. The keyword cell can contain one or more words used to describe each category. These words will be imported as descriptors or ignored depending on what you specify in the last step of the wizard. Later, descriptors are compared to the extracted results from the text. If a match is found, then that record or document is scored into the category containing this descriptor.
Column A | Column B | Column C |
---|---|---|
Category code (optional) | Category name | Annotation |
_Descriptor/keyword list (optional) |