All available functions in GPT in Excel

Discover all available functions in GPT in Excel, along with simple examples and an extensive list of paramaters. If you are looking for usage examples, download our Microsoft Excel template.

GPT function

The simplest function to start using GPT in Excel. Outputs the result in a single cell.

How to use

Syntax	=GPT(prompt, [value], [temperature])
Copy/paste example	=GPT("Write a tagline for an ice cream shop.")
⚠️ Localization	In some locales, you might need to use ";" to separate parameters instead of ","
Output	A response to your prompt in a single cell

Parameters

Parameter	Definition
prompt (cannot be empty)	Instruction provided to the AI to generate a result in a single cell. The prompt parameter can be: A string: "Write a tagline for an ice cream shop." A cell: A1 A range of cells: A1:C3
(optional) value	Text, cell or range you want your prompt to apply to
(optional) temperature	Number between 0 and 1 that governs the creativity of GPT: 0 makes GPT strictly follow the prompt 0.5 makes GPT slightly creative 1 makes GPT very creative Note: In some locales, you might need to use "0,5" instead of "0.5"

GPT_LIST / GPT_HLIST function

Like GPT, but outputs the results in a column. Very practical when the output is a list.

• Use GPT_LIST to return options listed vertically.
• Use GPT_HLIST to return options listed horizontally.

How to use

Syntax	=GPT_LIST(prompt, [value], [temperature])
Copy/paste example	=GPT_LIST("Give me 5 good short ads about spreadsheets.")
⚠️ Localization	In some locales, you might need to use ";" to separate parameters instead of ","
Output	As many responses to your prompt as you asked, one response per cell

Parameters

Parameter	Definition
prompt (cannot be empty)	Instruction provided to the AI to generate a list. The prompt parameter can be: A string: "Give me 5 good short ads about spreadsheets." A cell: A1 A range of cells: A1:C3
(optional) value	Text, cell or range you want your prompt to apply to
(optional) temperature	Number between 0 and 1 that governs the creativity of GPT: 0 makes GPT strictly follow the prompt 0.5 makes GPT slightly creative 1 makes GPT very creative Note: In some locales, you might need to use "0,5" instead of "0.5"

GPT_SPLIT / GPT_HSPLIT function

Splits text semantically, such as by section, paragraph, sentence, customer…

• Use GPT_SPLIT to return outputs listed vertically.
• Use GPT_HSPLIT to return outputs listed horizontally.

How to use

Syntax	=GPT_SPLIT(text, split_by, [temperature])
Copy/paste example	=GPT_SPLIT("Hello! How are you? Have you heard of GPT for Work?", "sentences")
⚠️ Localization	In some locales, you might need to use ";" to separate parameters instead of ","
Output	Input text is split as requested, one element per cell

Parameters

Parameter	Definition
text (cannot be empty)	Input text to split. The text parameter can be: A string: "Hello! How are you? Have you heard of GPT for Work?" A cell: A1 A range of cells: A1:C3
split_by (cannot be empty)	How to split the text. Examples: sections paragraphs sentences punctuation
(optional) temperature	Number between 0 and 1 that governs the creativity of GPT: 0 makes GPT strictly follow the prompt 0.5 makes GPT slightly creative 1 makes GPT very creative Note: In some locales, you might need to use "0,5" instead of "0.5"

GPT_FILL function

Magically fills or cleans a range from a few examples.

How to use

Syntax	=GPT_FILL(examples, [inputs], [temperature])
Copy/paste example	=GPT_FILL(S4:U5,S6:S14)
⚠️ Localization	In some locales, you might need to use ";" to separate parameters instead of ","
Output	The empty part of the range will be filled based on the examples provided

Parameters

Parameter	Definition
examples	Range containing complete examples that the AI should learn from
(optional) inputs	Range containing incomplete data that the AI should complete from the examples
(optional) temperature	Number between 0 and 1 that governs the creativity of GPT: 0 makes GPT strictly follow the prompt 0.5 makes GPT slightly creative 1 makes GPT very creative Note: In some locales, you might need to use "0,5" instead of "0.5"

GPT_TABLE function

Like GPT, but outputs the results in a table. Very practical when the output is a table.

How to use

Syntax	=GPT_TABLE(prompt, [head], [inputs], [temperature])
Copy/paste example	=GPT_TABLE("top 10 most eaten fruits and their nutrition data")
⚠️ Localization	In some locales, you might need to use ";" to separate parameters instead of ","
Output	The response to your prompt in the shape of a table

Parameters

Parameter	Definition
prompt (cannot be empty)	Instruction to generate a table. The prompt parameter can be: A string: "top 10 most eaten fruits and their nutrition data" A cell: A1 A range of cells: A1:C3
(optional) head	Range containing at least one row. the first row should be headers, the following rows can be used to specify examples If left empty, headers will be generated automatically.
(optional) inputs	Range containing partial rows to complete with GPT_TABLE
(optional) temperature	Number between 0 and 1 that governs the creativity of GPT: 0 makes GPT strictly follow the prompt 0.5 makes GPT slightly creative 1 makes GPT very creative Note: In some locales, you might need to use "0,5" instead of "0.5"

GPT_FORMAT function

Formats dates, currencies, addresses, names, etc. Fixes capitalization. And so much more.

note

GPT_CONVERT and GPT_FORMAT perform the same task. We removed GPT_CONVERT from the list of available functions, but it still executes if manually typed.

How to use

Syntax	=GPT_FORMAT(input, target_format, [source_format], [temperature])
Copy/paste example	=GPT_FORMAT("14 February 71", "iso")
⚠️ Localization	In some locales, you might need to use ";" to separate parameters instead of ","
Output	The converted input in a single cell unless it is converted a table, which outputs a table

Parameters

Parameter	Definition
input (cannot be empty)	Input text to format. The input parameter can be: A string: "14 February 1971" A cell: A1 A range of cells: A1:C3
target_format (cannot be empty)	Target format for the input. Examples: "iso", "currency iso", "international phone number", "lowercase/uppercase/camelcase/snake case/title case/sentence case"…
(optional) source_format	Source format of the input. Optional, but including it can yield better results.
(optional) temperature	Number between 0 and 1 that governs the creativity of GPT: 0 makes GPT strictly follow the prompt 0.5 makes GPT slightly creative 1 makes GPT very creative Note: In some locales, you might need to use "0,5" instead of "0.5"

GPT_EDIT function

Applies the given task to the given text. The default task is to fix grammar and spelling.

How to use

Syntax	=GPT_EDIT(text, [task], [temperature])
Copy/paste example	=GPT_EDIT("For sum reezon thoose nunsberz arnt addin up")
⚠️ Localization	In some locales, you might need to use ";" to separate parameters instead of ","
Output	The edited text in a single cell

Parameters

Parameter	Definition
text (cannot be empty)	Input text to edit. The text parameter can be: A string: "For sum reezon thoose nunsberz arnt addin up" A cell: A1 A range of cells: A1:C3
(optional) task	Text, cell or range specifying how the text should be edited. Defaults to fixing grammar and spelling. Other examples: "Make it funnier" "Make it shorter" "Make it sound formal" "Add an ending"
(optional) temperature	Number between 0 and 1 that governs the creativity of GPT: 0 makes GPT strictly follow the prompt 0.5 makes GPT slightly creative 1 makes GPT very creative Note: In some locales, you might need to use "0,5" instead of "0.5"

GPT_CLASSIFY function

Classifies a given text into a single category.

How to use

Syntax	=GPT_CLASSIFY(value, categories, [examples], [temperature])
Copy/paste example	=GPT_CLASSIFY("banana", "fruit, vegetable")
⚠️ Localization	In some locales, you might need to use ";" to separate parameters instead of ","
Output	The best applicable category

Parameters

Parameter	Definition
value (cannot be empty)	Input text to classify. The value parameter can be: A string: "banana" A cell: A1 A range of cells: A1:C3
categories (cannot be empty)	Comma-separated categories or range of categories to choose from. Only the most relevant category will be returned.
(optional) examples	A table of examples in two columns. The first column should contain the inputs and the second column should contain the outputs.
(optional) temperature	Number between 0 and 1 that governs the creativity of GPT: 0 makes GPT strictly follow the prompt 0.5 makes GPT slightly creative 1 makes GPT very creative Note: In some locales, you might need to use "0,5" instead of "0.5"

GPT_EXTRACT function

Extracts data (like email addresses or company names) from a text. Outputs as comma-separated values.

How to use

Syntax	=GPT_EXTRACT(text, to_extract, [temperature])
Copy/paste example	=GPT_EXTRACT("I worked 5 years at Amazon.com and then 3 years at Apple", "companies")
⚠️ Localization	In some locales, you might need to use ";" to separate parameters instead of ","
Output	The extracted entities as comma-separated values in a single cell

Parameters

Parameter	Definition
text (cannot be empty)	Input text to extract data from. The text parameter can be: A string: "I worked 5 years at Amazon.com and then 3 years at Apple" A cell: A1 A range of cells: A1:C3
to_extract (cannot be empty)	Text, cell or horizontal range specifying what you want to extract. Examples: "companies" B3:E3
(optional) temperature	Number between 0 and 1 that governs the creativity of GPT: 0 makes GPT strictly follow the prompt 0.5 makes GPT slightly creative 1 makes GPT very creative Note: In some locales, you might need to use "0,5" instead of "0.5"

GPT_SUMMARIZE function

Summarizes text according to a given format (three sentences by default).

How to use

Syntax	=GPT_SUMMARIZE(text, [format], [temperature])
Copy/paste example	=GPT_SUMMARIZE("some long content here")
⚠️ Localization	In some locales, you might need to use ";" to separate parameters instead of ","
Output	A summary in the requested format in a single cell

Parameters

Parameter	Definition
text (cannot be empty)	Input text to summarize. The text parameter can be: A string: "Some long content" A cell: A1 A range of cells: A1:C3
(optional) format	Format of the summary. Examples: "key takeaways" "action items" "two paragraphs" "100 words" "tweets"
(optional) temperature	Number between 0 and 1 that governs the creativity of GPT: 0 makes GPT strictly follow the prompt 0.5 makes GPT slightly creative 1 makes GPT very creative Note: In some locales, you might need to use "0,5" instead of "0.5"

GPT_TAG function

Applies user-defined tags to text or automatically suggests relevant tags if none are specified.

How to use

Syntax	=GPT_TAG(value, [tags], [examples], [top_k], [temperature])
Copy/paste example	=GPT_TAG("I love chocolate", "food, positive, negative")
⚠️ Localization	In some locales, you might need to use ";" to separate parameters instead of ","
Output	The applicable tags as csv in a single cell

Parameters

Parameter	Definition
value (cannot be empty)	Input text to tag. The value parameter can be: A string: "I love chocolate" A cell: A1 A range of cells: A1:C3
(optional) tags	Comma-separated tags or range of tags applicable. If left empty, GPT_TAG will automatically come up with the tags
(optional) top_k	Maximum number of tags to return
(optional) examples	A table of examples in two columns. The first column should contain the inputs and the second column should contain the outputs.
(optional) temperature	Number between 0 and 1 that governs the creativity of GPT: 0 makes GPT strictly follow the prompt 0.5 makes GPT slightly creative 1 makes GPT very creative Note: In some locales, you might need to use "0,5" instead of "0.5"

GPT_TRANSLATE function

Translates text from one language into another. Works better if you specify the source language.

How to use

Syntax	=GPT_TRANSLATE(text, [target_language], [source_language], [instructions], [temperature])
Copy/paste example	=GPT_TRANSLATE("Cool off with our delicious treats!", "spanish")
⚠️ Localization	In some locales, you might need to use ";" to separate parameters instead of ","
Output	The requested translation in a single cell

Parameters

Parameter	Definition
text (cannot be empty)	Input text to translate. The text parameter can be: A string: "Cool off with our delicious treats!" A cell: A1 A range of cells: A1:C3
(optional) target_language	Language of the output. Examples: "spanish", "chinese", "french". Defaults to "english".
(optional) source_language	Language of the input. Example: "english"
(optional) instructions	Additional instructions for the translation. Can include a dictionary of translations.
(optional) temperature	Number between 0 and 1 that governs the creativity of GPT: 0 makes GPT strictly follow the prompt 0.5 makes GPT slightly creative 1 makes GPT very creative Note: In some locales, you might need to use "0,5" instead of "0.5"