GPT.Classify - Categorize text into predefined groups in Excel

GPT.Classify is an AI function that classifies a given text into one of the specified categories.
How to use GPT.Classify function in Excel to classify wine
How to use GPT.Classify function in Excel to classify review

Syntax

=GPT.Classify(text, categories, [examples])
ArgumentDescription
text
[required]		The text to classify. Cannot be empty.
categories
[required]		Comma-separated list of categories or a range specifying possible categories.
examples
[optional]		Range of examples (two columns) for better classification accuracy.

Before you begin, add Functions to Excel

Functions are one of the 20+ features within XLTools Add-in for Excel. Works in Excel 2019, 2016, 2013, 2010, desktop Office 365.

Get started with XLTools ribbon
Download XLTools for Excel
 – free trial gives you 14 days of full access to all features.

Examples [download]

Download this spreadsheet with examples and try the function yourself.

Download examples with this function (xlsx)

FormulaDescriptionResult
=GPT.Classify("Apple", "fruit, tech company")Classifies "Apple" based on the given categories."tech company"
=GPT.Classify("Tesla", "automobile, tech company, energy")Classifies "Tesla" into one of the specified categories."automobile"
=GPT.Classify("Python", "programming language, snake", A1:B2)Classifies "Python" with the help of examples for better accuracy."programming language"

Any questions or suggestions?
How can we help?