GPT in Excel reference

Discover all available functions in GPT in Excel, along with simple examples and an extensive list of paramaters.

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: "Give me 5 good short ads about spreadsheets." 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.