GPT in Excel reference

This is a reference of all available functions in GPT in Excel.

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)
Text, cell or range containing the prompt. Examples: • "Write a tagline for an ice cream shop." • A1 • A1:C3
(optional) value
Text, cell or range you want your prompt to apply to
(optional) temperature
Number between 0 and 1. Use it to control creativity.

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)
Text, cell or range containing the prompt. Examples: • "Write a tagline for an ice cream shop." • A1 • A1:C3
(optional) value
Text, cell or range you want your prompt to apply to
(optional) temperature
Number between 0 and 1. Use it to control creativity.