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.

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

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.

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.

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

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.