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. |