Text Insights in Excel

Feature Benefits 

• Efficiency: Quickly summarize large volumes of text without manual effort.

• Clarity: Gain a better understanding of your data and identify key themes through concise summaries.

• Customization: Tailor the results to your specific needs with flexible prompting options.

Getting Started 

1. In your workbook, open the sheet containing the text you wish to analyze.

2. Select Copilot from the Home tab of the Ribbon.

3. Type your request in the prompt box. ​​​​​​​​​​​​​​​​​​​​​

   Prompt examples:  "Review the customer feedback on this sheet and identify the major themes."  "Summarize the comments."  "Can you tell me about the bug descriptions in a professional tone with two bullet points?" "Summarize the URLs into a set of bullet points, where each bullet point corresponds to a website category."

4. Submit your prompt to begin analyzing the text.

5. Once the analysis is complete, Review the summary provided and submit any additional prompts to further distill the data to your specifications.

Discover the potential of Text Insights in Excel to convert raw text into meaningful insights and uncover key themes. With its intuitive interface and robust data capabilities, it's an essential tool for more effective decision-making. 

See also

Identify insights with Copilot in Excel

Summarize with Copilot