Exporting Categories

You can also export the categories you have in an open interactive workbench session into an Microsoft Excel (*.xls, *.xlsx) file format. The data that will be exported comes largely from the current contents of the Categories pane or from the category properties. Therefore, we recommend that you score again if you plan to also export the Docs. score value.

Table 1. Category export options
Always gets exported... Exported optionally...
  • Category codes, if present
  • Category (and subcategory) names
  • Code levels, if present (Flat/Compact format)
  • Column headings (Flat/Compact format)
  • Docs. scores
  • Category annotations
  • Descriptor names
  • Descriptors counts

Important! When you export descriptors, they are converted to text strings and prefixed by an underscore. If you re-import into this product, the ability to distinguish between descriptors that are patterns, those that are category rules, and those that are plain concepts is lost. If you intend to reuse these categories in this product, we highly recommend making a text analysis package (TAP) file instead since the TAP format will preserve all descriptors as they are currently defined as well as all your categories, codes, and also the linguistic resources used. TAP files can be used in both IBM® SPSS® Modeler Text Analytics and IBM SPSS Text Analytics for Surveys . See the topic Using Text Analysis Packages for more information.

To Export Predefined Categories

  1. From the interactive workbench menus, choose Categories > Manage Categories > Export Categories. An Export Categories wizard is displayed.
  2. Choose the location and enter the name of the file that will be exported.
  3. Enter a name for the output file in the File Name text box.
  4. To choose the format into which you will export your category data, click Next.
  5. Choose the format from the following:
    • Flat or Compact list format: See the topic Flat List Format for more information. Flat list contains no subcategories. See the topic Compact Format for more information. Compact list format contains hierarchical categories.
    • Indented format: See the topic Indented Format for more information.
  6. To begin choosing the content to be exported and to review the proposed data, click Next.
  7. Review the content for the exported file.
  8. Select or unselect the additional content settings to be exported such as Annotations or Descriptor names.
  9. To export the categories, click Finish.