How to Use AI With Excel: Formulas, Cleanup and Analysis Workflows

Use AI with Excel spreadsheets two ways: Copilot inside the workbook, or ChatGPT on an uploaded file. Three workflows for formulas, cleanup and analysis.

By Galactic News Editorial · Published 2026-11-07T15:04:07+00:00 · Updated 2026-11-07T15:04:07+00:00

How to Use AI With Excel: Formulas, Cleanup and Analysis Workflows

AI helps with Excel in two ways. It can work inside the spreadsheet, or it can analyze a file you upload. Copilot in Excel works inside the workbook. ChatGPT analyzes uploaded files by running code on them. Both routes need the same habit: check every number before you use it. This guide covers both routes, with three workflows you can run today.

Use AI With Excel Spreadsheets: Pick Your Route

Stay in Excel when the file must stay where it is, and when you want edits applied directly. Upload to a chatbot when you want a fast answer from an exported file, a chart, or a second opinion on the numbers. Many people use both: Copilot for daily work, ChatGPT for the monthly analysis.

Copilot in Excel: Formulas, Charts and PivotTables

Copilot in Excel helps you build and edit workbooks in plain language. It uses Excel's own tools, such as tables, charts, PivotTables, and formulas, to complete your requests. Your content stays editable, and you stay in control of what changes.

It offers three modes. Edit mode changes the workbook directly from your requests, and it is the default. Plan mode drafts a plan before anything changes, so you can edit the plan first. Chat mode keeps the answers in the chat pane and does not change the workbook. Use chat mode when you only want analysis, not edits.

Copilot can edit worksheets, generate data and formulas, apply conditional formatting, create charts and PivotTables, and surface insights such as trends and outliers. It can also fetch information from the web and search your work files for context. Microsoft's support pages note that Copilot supports Claude models from Anthropic and GPT models from OpenAI for editing workbooks.

One limit to know: Copilot cannot see or edit some parts of Excel, including VBA code, Power Query M code, and protected content. It can still generate macro code and Python in Excel code for you to run. Check your license first. If Copilot does not appear in Excel, it may not be included in your Microsoft 365 subscription, or your organization may have turned it off.

Workflow 1: Get a Formula Written and Checked

1. Describe the result, not the formula. Say what you want in plain words: "Add a column that shows each region's share of total sales." Do not guess the function name first.
2. Ask for the formula in the chat. In Copilot, use chat mode. In ChatGPT or Claude, paste a small sample of the data, ten rows at most, with headers.
3. Read the formula before you paste it. Check the cell ranges. Check that the function matches your intent. If you do not understand a part, ask the AI to explain that part in one sentence.
4. Test it on rows you can check by hand. Pick three rows. Work out the answer yourself. If the formula disagrees, the formula is wrong until proven otherwise.
5. Copy the working formula down the column. Then spot-check the top row, a middle row, and the last row. Save the file only after the checks pass.

Workflow 2: Clean a Messy Sheet

1. Work on a copy. Save the file under a new name before any cleanup. The original stays untouched.
2. Ask the AI to map the mess. Upload the file to ChatGPT, or ask Copilot in chat mode: "List each column, its type, and how many blank values it has." Do not ask for fixes yet.
3. Fix one problem at a time. Start with duplicates. Then fix date formats. Then standardize categories, so "NYC" and "New York" become one value. Then fill or flag the blanks.
4. Ask for a change log. Have the AI list every change it made, row by row, in a short table. Review the log before you accept the file.
5. Recount the rows. The row count before and after cleanup must match, unless you removed duplicates on purpose. A missing row is a red flag, not a detail.

Workflow 3: Analyze an Uploaded File With ChatGPT

1. Export a clean file. One table, one header row, no merged cells, no totals row mixed into the data. Save it as .xlsx or .csv.
2. Upload it and ask for a map first. Ask for each sheet name, the number of data rows, the column list, the type of each column, and the count of empty values. Check the map against the file. If the map is wrong, stop here.
3. Ask one question at a time. "Which product line grew fastest this quarter, and by how much?" beats a vague "analyze this." Ask for the method: which columns it used, and which rows it excluded.
4. Ask it to show its work. ChatGPT runs Python code on the file. Ask to see the code or the steps behind each number. A number with no method is a guess.
5. Check three cells by hand. Pick three figures from the answer. Find them in the original file yourself. If one is wrong, treat the whole answer as unverified.
6. Request one chart, not five. Name the chart type and the columns. A single clear chart beats a gallery of decorations.

The Rule That Protects Every Workflow

AI can be confidently wrong about spreadsheets. It can invent a total, misread a date column, or apply a formula to the wrong range. The defense is simple and non-negotiable: verify before you use. Recompute a sample by hand. Check totals against the source file. Keep the original file untouched, and work on a copy. Never send an AI-written figure to a client or a manager without checking it first.

Microsoft's own guidance for Copilot in Excel says the same thing in plainer terms: review and verify all output before relying on it. That rule applies to every tool in this guide, not just Copilot.