ChatGPT Prompts for Excel and Google Sheets

By Free AI Prompts team · Published 21 November 2026 · Updated 21 November 2026

TL;DR: Copy a prompt, paste it into ChatGPT, and fill in the [brackets] with your real columns, rows and examples. The more specific you are, the better the formula: "column B has prices and column A says Paid" gets a working a
Photo coming soon — a real photo for this page is being prepared. All 12 prompts below work fully without it.

How to use these prompts

Copy a prompt, paste it into ChatGPT, and fill in the [brackets] with your real columns, rows and examples. The more specific you are, the better the formula: "column B has prices and column A says Paid" gets a working answer, while "help with Excel" gets a lecture. After you get a formula, paste it into a COPY of your sheet first, not the original. Check the first three rows by hand. If the result looks wrong, tell ChatGPT what it shows and what you expected — it will usually fix it in one more try.

What these prompts cannot do

These prompts help you write formulas and clean data. They cannot open your file, see your sheet, or fix a broken workbook for you — you paste the problem in words, and the AI answers in words. For a very large or very messy file, break the problem into small pieces and ask about one piece at a time. And keep a backup of your file before you run any cleanup steps on it.

Test on a copy first

Always test a formula on a copy of your file, never the original. Check the first three rows by hand, and if the result looks wrong, tell ChatGPT what it shows and what you expected. Keep the original file untouched until the result is right — one bad paste can ruin a whole sheet.

Copy a prompt and use it

Pick a prompt below, press Copy prompt, paste it into your AI tool, and replace everything in [brackets] with your own details. The prompts work in ChatGPT, Claude and Gemini unless the page says otherwise.

1. Explain a formula in plain words

Explain this Excel formula in plain words, step by step, as if I am a beginner: [paste the formula]. Tell me what each part does, what the result will be, and one common mistake people make with it. Do not use jargon without explaining it.

Use it for: Understanding a formula someone else wrote.

2. Write a formula for my problem

Write an Excel formula for this problem: [describe it in plain words, e.g. I want the total of column B only where column A says 'Paid']. My data starts in row [number]. Give me the formula, explain each part in one sentence, and tell me what to do if it shows an error.

Use it for: Getting a formula without knowing the syntax.

3. Clean up messy data

Help me clean up messy data in Excel. My problem is: [describe it, e.g. names are in ALL CAPS and there are extra spaces]. My data is in [column and range, e.g. A2:A200]. Give me step-by-step instructions using only built-in Excel features — no add-ins. Tell me how to check the result afterwards.

Use it for: Fixing messy spreadsheets safely.

4. Find duplicates in a list

Show me how to find duplicates in Excel. My list is in [column and range, e.g. A2:A500]. Give me two ways: one quick way to highlight duplicates, and one way to list only the duplicate values. Explain each step simply, as if I have never done it before.

Use it for: Spotting repeated entries in a list.

5. Combine first and last names

Write a formula that combines a first name in column [letter] and a last name in column [letter] into one full name, with one space between them. My data starts in row [number]. Also show me what to do if some rows have no last name, so I do not end up with a trailing space.

Use it for: Merging name columns into one.

6. Calculate a running total

Show me how to make a running total in Excel. My amounts are in column [letter], starting in row [number]. Give me the formula for the first two rows, explain why the second formula is different, and tell me how to copy it down the whole column without breaking it.

Use it for: Tracking a total that grows row by row.

7. Sort dates that Excel reads as text

My dates in column [letter] are stored as text, so Excel will not sort them. The dates look like [example, e.g. 21/11/2026]. Show me how to convert them into real dates using only built-in features, step by step, and how to check that it worked before I delete the old column.

Use it for: Fixing dates that will not sort.

8. Make a simple budget sheet plan

Help me plan a simple monthly budget sheet in Google Sheets. My income is [amount], my fixed costs are [list 3-4 costs], and I want to save [amount]. Tell me which columns to make, which 3 formulas I need, and how to see at a glance whether I am over budget. Keep it simple — I am a beginner.

Use it for: Building a budget that is easy to keep.

9. Compare two columns and flag differences

Show me how to compare two columns in Excel and flag the differences. Column [letter] has [what, e.g. last month's prices] and column [letter] has [what, e.g. this month's prices], starting in row [number]. Give me a formula that shows 'Same' or 'Changed', and explain how to highlight the changed rows.

Use it for: Finding what changed between two lists.

10. Turn a table into a summary

Turn this table into a short summary: [paste the table or describe it]. I need: the total, the average, the highest value and the lowest value for [column]. Give me the formulas for each one, and one sentence I can use to describe the result to my manager.

Use it for: Summarising numbers for a report.

11. Fix numbers stored as text

My numbers in column [letter] are stored as text, so my SUM formula shows 0. Show me two ways to fix this using only built-in Excel features, step by step. Tell me which way is safer if the column also has a few real words in it, like [example word].

Use it for: Fixing numbers that will not add up.

12. Create a dropdown list

Show me how to make a dropdown list in Excel. The list should contain: [list the options]. The dropdown goes in column [letter], starting in row [number]. Give me step-by-step instructions, and tell me how to stop people typing something that is not in the list.

Use it for: Making data entry clean and consistent.

Worked example: a formula for "only count the paid ones"

Filled-in prompt: "Write an Excel formula for this problem: I want the total of column B only where column A says 'Paid'. My data starts in row 2. Give me the formula, explain each part in one sentence, and tell me what to do if it shows an error." What ChatGPT returned (example): =SUMIF(A2:A100,"Paid",B2:B100), with a one-line explanation of each part — the range to check, the word to match, and the range to add — plus the tip that a #VALUE! error usually means a number stored as text. The user pasted it into a copy of the sheet, checked the first rows by hand, and it worked. The trick is the plain-words description: describe what you want in one sentence, and the formula writes itself.

This is an illustrative example of how the prompt works, not a live AI answer. This site does not run AI itself.

Frequently asked questions

Are these Excel prompts free?

Yes. Every prompt on this page is free to copy and use. There is no account, no sign-up and no limit.

Do they work in Google Sheets too?

Mostly yes. The prompts say Excel, but the formulas are similar in Google Sheets. If a formula does not work in Sheets, tell ChatGPT "this is Google Sheets" and it will adjust it.

Can ChatGPT see my spreadsheet?

No. ChatGPT cannot open your file. You describe the problem in words, and it answers in words. Never paste private data — use made-up example values if you can.

What if the formula shows an error?

Paste the formula and the error back into ChatGPT and say what you expected. The most common cause is numbers stored as text, or a range that does not match your data.

More prompt collections

Share:
Disclaimer: The prompts on this page are text you copy into your own AI tool. This site does not run AI itself, does not send your text anywhere, and does not store anything you paste. Always check an AI answer before you use it for real work.