Skip to main content
AI Toolbench

AI for Excel and Google Sheets: Write Formulas, Clean Data and Make Charts in Seconds

📊TUTORIALAI for Exceland Google Sheets:formulas in secondsAI Toolbench

Spreadsheets scare a lot of people, mostly because of formulas. The good news: you no longer need to memorize them. AI can write formulas, explain them, clean messy data and suggest charts, all from plain English. Here is how to use it in Excel and Google Sheets.

Option 1: Any AI chatbot (works everywhere)

ChatGPT, Gemini or Claude can write formulas for any spreadsheet app. The trick is describing your columns clearly.

My sheet has dates in column A, product names in column B and sales amounts in column C. Write a Google Sheets formula that totals sales for "Coffee" in March 2026.

Then ask: "Explain this formula step by step", so you learn as you go.

Option 2: Built-in AI

  • Microsoft Excel: Copilot in Excel (available with certain Microsoft 365 plans) can analyze data, suggest formulas and create charts from a question.
  • Google Sheets: Gemini in Sheets (available with certain Google Workspace and Google AI plans) can help create tables, formulas and summaries in a side panel.

Availability depends on your plan and region, so look for the Copilot or Gemini button in your toolbar.

10 formula prompts you can copy

  1. "Count how many rows in column D say 'Pending'."
  2. "Find the average of column C, ignoring blank cells."
  3. "Look up a product's price from a second sheet called Prices."
  4. "Show 'Late' if the date in column E is before today, otherwise 'On time'."
  5. "Split full names in column A into first and last names."
  6. "Remove extra spaces from all text in column B."
  7. "Highlight duplicate emails in column C." (ask for conditional formatting steps)
  8. "Calculate the percentage change between column B and column C."
  9. "Sum column F only for rows where column A is in this month."
  10. "Create a running total in column G."

Clean messy data fast

Paste a small sample (with private details removed) and ask:

This data has inconsistent dates, extra spaces and mixed capitalization. Give me formulas or steps to clean it in Google Sheets.

Get chart ideas

I have monthly sales by product for a year. Which chart best shows trends, and which shows the best-selling product? Give me step-by-step instructions.

Safety tips

  • Never paste customer data, salaries or passwords into a public AI chatbot.
  • Test formulas on a copy of your sheet first.
  • Check a few results by hand. AI formulas are usually right, but not always.

Need more business prompts? See 20 ChatGPT prompts every small business owner should save and our free Invoice Generator.

Have a tool you want tested?

Send it over and it may be in the next review.

Suggest a tool