GPT.Summarize - Summarize text into concise formats in Excel

GPT.Summarize is an AI function type that summarizes the provided text according to a specified format or length.
How to use GPT.Summarize function in Excel: formula and examples

Syntax

=GPT.Summarize(text, [format])
ArgumentDescription
text
[required]
Text to summarize. Cannot be empty.
format
[optional]
Specifies the format or length of the summary (e.g., "three sentences", "100 words").

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
– free trial gives you 14 days of full access to all features.

Examples [download]

Download this spreadsheet with examples and try the function yourself.


FormulaDescriptionResult
=GPT.Summarize("Long article text here", "three sentences")Summarizes the article into three sentences."Summary in three sentences appears here."
=GPT.Summarize("In-depth analysis of market trends", "100 words")Summarizes the analysis in 100 words."Summary in 100 words appears here."
=GPT.Summarize("Project report", "one paragraph")Summarizes the report into one paragraph."One paragraph summary appears here."

Any questions or suggestions?
How can we help?