PromptLoop
PromptLoop
  • Customers
  • Templates
  • Pricing
⌘K
Sign In

Footer

Promptloop Logo

The power of AI with a simple spreadsheet formula

LinkedIn
YouTube
Twitter

Backed by Y combinator

Backed by

YC Logo

Combinator

Product

  • Pricing
  • Custom AI models in Excel
  • AI web crawler - market research
  • Enterprise AI models - Excel
  • Combine custom AI models

Support

  • How to use Promptloop
  • The formula 101
  • Installing the Add-on
  • Book a Demo
  • Contact Us

Use Cases

  • Categorize text data
  • AI Web Browsing
  • Using AI models in Excel
  • Company research and scraping

Company

  • Blog
  • Customers
  • About
  • Privacy
  • Terms

© Kiter Inc.

Getting Started

Enable PromptLoop

Functions

Autoloop

Web Browsing

Choosing a function

Extract and Summarize

Replicate

Inference

Labeling

Guides

Cutom Models

Entity Tagging

Inventory Labeling

Combine Functions

Company Lookup

Handling Messy Data

Industry Guides

Consulting

E-commerce

Private Equity

Help & More

Contact

Credits & Usage

Help & More

AI Help Chat

Related Articles:

Consumer Research - Response Analysis

Contact | Google Sheets

AI text Labeling

The Promptloop labeling function offers fast, flexible, and reliable AI test labeling and categorization based on a set group of labels.

Formula Syntax#

The function takes a text input and matches it to the most semantically similar. For example, if you have a group of food menu items [ Hot Sauce, Water Mellon, Carrots] and a target cell [ Spicy ], the function would return Hot Sauce.

📝 Syntax

=PROMPTLOOP.LABEL( target, inputLabels, numLabels? ) numLabels is an optional parameter if you want to return multiple labels

Text Labeling

Tips and tricks#

Unlike other PromptLoop functions, the labeling model will only return a match to the set of labels you provide. If the model has two options it will select the closest.

Choosing complete and exhaustive labels improves performance. A set of labor or business descriptions for example should be mutually exclusive. Avoid labels that overlap like (Restaurant, French Restaurant).

  1. List the labels or categories you want to sort your data into, this will depend on the type of data or goal of the analysis. For most cases look to make the options collectively exhaustive (list all possible options as labels) and mutually exclusive (Do not list overlapping categories like human and person unless specifically needed)
  2. Select the target cell or cells that you want to add a label to as the first parameter ( target, inputLabels )
  3. Select the list of labels which should be the same for the whole dataset.
  4. Analyze the results - use a pivot table or =COUNTIF to understand your categories.
💡
Naming labels

Labeling works off of semantic similarity. So labeling "I like apples" with "fruit" instead of a number or code will perform better. Labels and targets can contain multiple sentences where needed.

Text Labeling

You can get started with this Excel Label Template here and read our guide on Entity Tagging and also find more templates and use cases from current customers.

If you are interested in learning more or have questions about how your team can benefit, get in touch here!

Advanced Use#

Labeling harnesses the power of AI language models to match similar text - which can be powerful to combine with functions like INDEX or MATCH.

💡
Advanced Labeling

Combine INDEX and MATCH with LABEL to use the best of Excel and Promptloop EX: =INDEX($F$4:$F$8,MATCH( PROMPTLOOP.LABEL(B4,$G$4:$G$8), $G$4:$G$8,1))

You can use LABEL inside a MATCH function to tag text and graph or run statistics on a large data set. The example below uses pre-defined tags to label open-ended survey responses which can be a powerful tool for market research synthesis.

Text Labeling

Try it in the Playground#

Labeling AI

Match text to a set of labels or text strings

Labels
Input