15 Free AI Tools for Excel Productivity (Formulas, Cleanup, Data Entry)
Quick answer: use Copilot in Excel or ChatGPT/Claude/Gemini to write and explain formulas, Excel's built-in Flash Fill and Analyze Data for cleanup and insights, and an OCR tool like Image to Text to turn photos of tables into rows you can paste.
Formulas and explanations
- Copilot in Excel: write formulas and summaries from plain English (Microsoft 365).
- ChatGPT: "write an XLOOKUP that returns…" and paste the result.
- Claude: explain long nested formulas step by step.
- Gemini in Google Sheets: the same, inside Sheets.
- Formula explainer prompts: paste a formula and ask "what does this do and how can it fail?".
Cleaning and shaping data
- Flash Fill (Ctrl+E): splits or combines columns from one example.
- Power Query: repeatable cleanup steps without code.
- Text to Columns: split pasted text by spaces or commas.
- Remove Duplicates / Data Validation: built in and free.
- AI prompts for regex: ask an assistant for a pattern to extract emails, IDs or dates.
Insights and charts
- Analyze Data (Excel): suggests charts and pivot tables.
- Google Sheets Explore: answers questions about your sheet.
- AI chart suggestions: describe the chart you want and ask for the steps.
Getting data into Excel
- Image to Text: photo or screenshot of a table → text → paste → Text to Columns.
- Handwriting to Text: handwritten lists and forms → Excel. Full guide: convert handwritten text to Excel.
FAQ
Is Copilot in Excel free? It's included with some Microsoft 365 plans; general assistants like ChatGPT have free tiers you can use alongside Excel.
Can AI read a picture of a spreadsheet? Yes: extract the text with Image to Text, paste into Excel and split it into columns.
Related: Handwritten text to Excel