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

  1. Copilot in Excel: write formulas and summaries from plain English (Microsoft 365).
  2. ChatGPT: "write an XLOOKUP that returns…" and paste the result.
  3. Claude: explain long nested formulas step by step.
  4. Gemini in Google Sheets: the same, inside Sheets.
  5. Formula explainer prompts: paste a formula and ask "what does this do and how can it fail?".

Cleaning and shaping data

  1. Flash Fill (Ctrl+E): splits or combines columns from one example.
  2. Power Query: repeatable cleanup steps without code.
  3. Text to Columns: split pasted text by spaces or commas.
  4. Remove Duplicates / Data Validation: built in and free.
  5. AI prompts for regex: ask an assistant for a pattern to extract emails, IDs or dates.

Insights and charts

  1. Analyze Data (Excel): suggests charts and pivot tables.
  2. Google Sheets Explore: answers questions about your sheet.
  3. AI chart suggestions: describe the chart you want and ask for the steps.

Getting data into Excel

  1. Image to Text: photo or screenshot of a table → text → paste → Text to Columns.
  2. 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