Create PivotTables with Copilot in Excel

Warning: This feature is being deprecated. App Skills will be removed from Excel by late-February 2026. You can use Agent Mode in Excel to create pivot tables and edit your workbook, Copilot Chat to ask basic questions, or explore with Analyst for deep reasoning data analysis.

If you want to see specific data from a large data set, you can ask Copilot to create a PivotTable. With Copilot, you don't have to do a lot of steps—just ask for what you want.

Let's say you have a large data set from your Marketing team. Perhaps it includes data for year, month, type of marketing campaign, product, cost of campaign, budget, revenue, and much more. If you just want to compare what was budgeted for different types of campaigns, you could ask Copilot for a PivotTable that includes only the campaign types and the average budget for each type.

Note: To access Copilot, you'll need the right license.

Create a PivotTable with Copilot

Open Excel.
Make sure to format your data in a table or supported range for Copilot.
Select the Copilot button in the ribbon.
Ask Copilot to create a PivotTable for you. The more details you include, the more accurate and useful Copilot's results will be. Try one of the sample prompts, or type something in your own words.
If Copilot's suggestions don't match what you want, you can add more details and ask Copilot to generate again.