How to Use ChatGPT for Excel (2026)

You don't need to memorize Excel formulas. ChatGPT can write them for you, IF you know how to ask. Most people type vague requests and get vague results. This tutorial shows you how to use ChatGPT for Excel the right way, with practical examples you can copy and use today.

How to Use ChatGPT for Excel (3 Steps)

Using ChatGPT for Excel follows the same pattern every time:

1. Describe your data. Tell ChatGPT what your spreadsheet looks like: column names, data types, what's where. Instead of "I have sales data," say "Column A has dates in MM/DD/YYYY format, Column B has product names, Column C has unit prices, Column D has quantities sold."
2. State what you want. Be specific about the outcome, not just the action. "Calculate total revenue per product" is better than "help with my spreadsheet."
3. Copy, paste, test. Drop the formula into Excel and verify it works on your data. Test on a few rows first. If something looks off, paste the result back into ChatGPT and explain what went wrong.

The key is step one. The more context you give about your spreadsheet, the more accurate the formula.

The AI Academy dives deeper into these prompting principles. Learning how to give AI the right context is a skill that applies far beyond spreadsheets.

5 ChatGPT for Excel Examples You Can Use Right Now

1Generate a VLOOKUP Formula

ChatGPT gives you:

=VLOOKUP(A2, Sheet2!A:B, 2, FALSE)

Paste this into cell C2 on Sheet1 and drag down. The FALSE ensures exact matching. Without it, Excel does approximate matching, which produces wrong results for text lookups. For large datasets, ask ChatGPT to write it using XLOOKUP instead; it's faster and doesn't require the lookup column to be on the left.

2Build a Conditional Formula

ChatGPT gives you:

=IF(A2>10000, "Above Target", IF(A2>=5000, "On Target", "Below Target"))

Nested IFs get unreadable fast. If you have more than three conditions, ask ChatGPT to use IFS instead; it handles multiple conditions without nesting.

3Clean Messy Data

ChatGPT gives you:

=PROPER(TRIM(A2))

This strips leading/trailing spaces and converts "JOHN SMITH" or "john smith" to "John Smith." For messier data (phone numbers, dates stored as text, inconsistent abbreviations), tell ChatGPT what the messy version looks like and what the clean version should look like. It chains together the right combination of SUBSTITUTE, TEXT, and MID functions.

4Create a Simple Macro

ChatGPT gives you a complete VBA script that you paste into the Visual Basic Editor (Alt + F11 → Insert → Module → Paste). Run it, and your range is formatted instantly.

This is where ChatGPT saves the most time: writing macros that would take 20 minutes to code from scratch. You don't need to know VBA syntax. Just describe what the macro should do step by step. Common macros worth requesting include auto-sorting by a specific column, removing duplicate rows, or splitting data across multiple sheets based on a category column.

If you want to master these kinds of AI-assisted productivity workflows, our AI Academy walks through them with real-world examples you can apply immediately.

5Analyze Data Patterns

ChatGPT gives you:

• A plain-English analysis of your data
• The formula: =(B3-B2)/B2*100 for percentage growth
• Suggestions for visualizing the trend

Paste actual numbers when you can. ChatGPT spots seasonal patterns, identifies outliers, and suggests the right chart type, faster than manual inspection.

More Excel Formulas ChatGPT Can Write for You

SUMIFS: Conditional Totals

ChatGPT gives you:

=SUMIFS(C:C, B:B, "Sarah", A:A, ">="&DATE(2026,1,1), A:A, "<="&DATE(2026,1,31))

SUMIFS is one of the most powerful Excel functions, and one of the hardest to write from memory. ChatGPT handles the syntax perfectly, including the tricky date comparison operators that trip most people up.

Pivot Table Setup

ChatGPT can't create a pivot table directly, but it can tell you exactly how to set one up. Try this prompt:

I have sales data with columns: Date, Product, Region, Salesperson, Revenue, Units Sold. I want to see total revenue by region and product, with months across the top. Walk me through creating the pivot table.

You'll get step-by-step instructions for which fields to drag where: rows, columns, values, and filters.

Data Validation Rules

ChatGPT walks you through: Data tab → Data Validation → Allow: List → Source: =Sheet2!$A$1:$A$100. This is the kind of task where knowing how to ask matters more than knowing Excel, the same principle behind using AI to handle routine work tasks more efficiently.

ChatGPT for Google Sheets

Everything in this guide works with Google Sheets too, with a few differences worth knowing. For a dedicated walkthrough of Gemini's built-in AI features in Sheets (including the =AI() function), see our guide on how to use AI in Google Sheets. Most Excel formulas (VLOOKUP, IF, SUMIFS, TRIM, PROPER) use identical syntax in both.

The key differences are that Google Sheets uses ARRAYFORMULA() instead of Ctrl+Shift+Enter for array formulas. It also has exclusive functions like IMPORTRANGE (pull data from other spreadsheets), GOOGLEFINANCE (stock prices), and QUERY (SQL-like filtering). ChatGPT writes all of these well.

For macros, Google Sheets uses JavaScript-based Apps Script instead of VBA. If you ask ChatGPT to write a macro, specify "Google Apps Script" so it generates the right language. Always mention whether you're using Excel or Google Sheets; the answer might be identical, but when it's not, the difference matters.

Advanced Use Cases for ChatGPT and Excel

Dashboard Creation

ChatGPT can plan an entire dashboard for you. Try: "I have 12 months of marketing data with columns: Channel, Spend, Clicks, Conversions, Revenue. Design a dashboard showing ROI by channel, monthly spend trends, and conversion rate over time." It lays out the structure cell by cell: calculated fields, chart types, and cell references. This kind of analysis is also useful for market research projects where you need to organize and visualize competitive data quickly.

Financial Modeling

For finance teams, ChatGPT writes the formulas behind revenue projections, loan amortization schedules, and scenario analysis. Try: "Build a 12-month revenue projection starting at $50,000 with 8% monthly growth for months 1-6, then 5% for months 7-12. Include cumulative revenue and a row showing when we hit $500,000 total." ChatGPT produces the growth formulas, the cumulative SUM, and a MATCH-based formula that identifies the breakeven month.

Project Tracking

Excel is still the go-to for project management in teams that don't want dedicated software. ChatGPT generates formulas for task completion percentages, deadline tracking with conditional formatting, and Gantt chart setups. Ask it to "Write a formula that highlights the row red if the due date in Column E has passed and the status in Column F isn't 'Complete'" and you'll get a conditional formatting rule ready to apply.

Tips for Better Results

Be specific about columns. "Column A has dates, Column B has revenue, Column C has product names" beats "I have a sales spreadsheet."

Paste sample data. Copy 5-10 rows of your actual data and paste it into ChatGPT. It'll tailor the formula to your exact structure.

Ask ChatGPT to explain. Add "and explain how this formula works" to any prompt. Understanding the formula helps you modify it later without going back to ChatGPT.

Always test first. ChatGPT sometimes gets column references wrong. Test every formula on a small sample before applying it to your full dataset.

Iterate when it's wrong. Don't start over. Paste the formula and error back into ChatGPT ("This returns #VALUE! on rows where the date cell is empty") and it'll add the error handling you need.

That iterative approach to working with AI is a core concept in the AI Academy. The lessons teach you how to refine AI outputs across all kinds of professional tasks, not just Excel.

Limitations to Know

ChatGPT doesn't see your spreadsheet. It works from your description, so if you describe your data wrong, the formula will be wrong too. For tasks that need direct spreadsheet access, look into Microsoft's built-in Copilot or Excel add-ins like Numerous.ai.

FAQ

Use AI across your entire workflow, from spreadsheets to presentations to project management.

The AI Academy offers 300+ courses, tutorials, and hands-on exercises to help you master ChatGPT for Excel, data analysis, and productivity workflows.

Start your free 14-day trial →