Skip to main content

Classify

Use the Classify / Categorize bulk tool to classify each cell of a column into one of several predefined categories.

For example, you can classify user feedback into relevant categories for your support team.

Prerequisites
You have opened a workbook containing data for classification in one of its columns.

  1. Click GPT for Excel Word in the Home tab.

  2. Click Classify / Categorize from the Bulk tools tab.

  3. Configure the classification tool to match the data in your sheet:

    1. Select the column to Classify.

    2. Enter the categories you want to classify your content into, separated by commas.

    3. Select the column to Write results in.

      The image highlights three main steps: selecting a column to classify, entering desired categories separated by commas, and choosing a column to write the results in.
    info

    Using gpt-3.5-turbo models may result in less accurate results. To achieve enhanced accuracy in following instructions and glossary interpretation, select gpt-4 models. Learn more.

  4. Select if you want to run a specific number of cells or All cells. Then, click Run cells.

The closest category to the content of each cell is identified and written in the selected column.

What's next

Discover more bulk tools.