COPILOT

COPILOT(prompt1 [,context1] [,prompt2] [,context2] [..])

Returns the response based on your referenced data using an AI model.

prompt1	The text that describes the task or question.
context1	The cell reference providing reference data for the prompt.
prompt2	(Optional) The text that describes the task or question.
context2	(Optional) The cell reference providing reference data for the prompt.

REMARKS

* For an illustrated example refer to the page under Data Functions
* This function is a preview function and is only available to users on the Beta Channel.
* This function was added in Microsoft 365 (version 2509, first released August 2025).
* This function is only available to users that have an Azure copilot subscription.
* This function cannot be used in any workbooks labelled Confidential or Highly Confidential.
* This function cannot access web pages or internal files, all the data must be imported into the workbook.
* Use direct action words like "summarize", "categorize" or "rank" and give examples if you want the output in a certain style or format.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=COPILOT("Summarize this feedback", A1:B3)
2	=COPILOT("Classify", B1:B10, "into one of the following categories ", A1:A4)
3	=COPILOT("Give me the sentiment of this list of reviews", A1:A10)
4	=COPILOT("Extract the zip codes from these addresses", A1:A10)
5	=COPILOT("Extract the first name and the city", A1:A10)
6	=COPILOT("Rearrange the addresses so they are formatted correctly", A1:A10)
7	=COPILOT("Analyze this profit and loss statement and provide a summary", A1:F200)
8	=COPILOT("List all the football teams in the English premiership")
9	=COPILOT("Tell me the 10 largest companies in the UK")
10	=COPILOT("Explain in plain English what this formula is doing", FORMULATEXT(A1))