Microsoft Excel's built-in AI feature that suggests charts and insights from your spreadsheet automatically.
What it does
Analyze Data (formerly Ideas) is a built-in Excel feature that scans a selected range and suggests relevant charts, pivot tables, and trend summaries, and also answers plain-English questions about the data — available in Excel for the web at no cost with any Microsoft account.
This is a direct link to Excel Analyze Data — we don't currently earn anything from it.
Free to use in Excel for the web with any Microsoft account; the full desktop Excel app requires a Microsoft 365 subscription.
Want something that never needs an account? Try our own free tools first.
Chat with your spreadsheets and datasets in plain English and get back analysis, charts, and forecasts.
Turns a plain-English description into a working Excel or Google Sheets formula.
Adds AI-powered spreadsheet functions like =AI() to Google Sheets and Excel.
Popular Google Workspace add-on that brings GPT-powered formulas into Google Sheets and Docs.
Excel Analyze Data FAQ