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 apparel products for lifecycle inventory management.

Prerequisites

• You have installed GPT for Excel Word.
• You have opened a workbook containing text to classify in one of its columns.

1. Click GPT for Excel Word in the Home tab. If you don't see it, go to Home > Add-ins > My add-ins > GPT for Excel Word.
   
   
2. Click Classify / Categorize from the Bulk tools tab.





3. Configure the classification tool to match the categories with the text in your sheet:
   1. Select the column to Classify.
   2. Enter the categories you want to classify your content into.
   3. Select the column to Put results in.
   
   
   
   
4. (Optional) Add classification instructions to provide context or guidance for more accurate results.
   
   
   Note: To achieve enhanced accuracy in following instructions, select the gpt-4o model. Learn more.
   
   
5. Select if you want to run a specific number of rows or All rows. Then, click Run rows.

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

What's next

Check our classification best practices.