Home / Free Tools / Excel prompts

Excel Prompts for Formulas, Cleanup and Reports

Most spreadsheet problems can be solved with one good formula, but finding it takes time. These Excel prompts let you describe the task in plain words and get a formula for Excel or Google Sheets, plus help with errors, cleanup, dates and pivot tables.

10 free Excel prompts

Replace anything in [square brackets] with your own details, then paste the prompt into ChatGPT, Claude or Gemini.

01

Formula from words

I use [Excel or Google Sheets]. Column A has [what], column B has [what]. Write a formula for C2 that [what you want] and explain it simply.

02

Sum with a condition

Write a formula that adds column [B] only where column [A] equals "[value]". Show one example.

03

Look up a value

Write a lookup formula to find the [price] for each [product] from another sheet. Explain each part and how to avoid errors.

04

Fix an error

This formula shows an error: [formula]. The error is [error]. Explain the cause and give the corrected formula.

05

Clean names

Column A has names with extra spaces and mixed capitals. Give a formula that makes them neat, like "Ali Khan".

06

Split text

Column A has "[First Last]". Give formulas to split it into first name and last name in two columns.

07

Highlight rows

Explain how to highlight rows in [Excel or Sheets] where column [C] is greater than [number], step by step.

08

Days between dates

Write a formula that gives the number of working days between the dates in A2 and B2. Explain it.

09

Pivot table plan

I have sales data with columns [list]. Suggest a pivot table setup to see [what I want to know], step by step.

10

Explain a formula

Explain this formula step by step for a beginner: [paste formula]. Then suggest a simpler version if one exists.

How to get better results

1

Say which program you use, because Excel and Google Sheets differ slightly.

2

Describe your columns, such as A for name and B for amount.

3

Give one example row and the result you expect.

4

Test the formula on a few rows before you copy it down.

Frequently asked questions

Do these prompts work for Google Sheets?

Yes. Mention Google Sheets in your prompt so the formula fits it.

What if the formula gives an error?

Use the fix-an-error prompt and paste the formula and the error message together.

Can I trust the formula without checking?

Always test it on a few rows where you already know the answer.

Related guides

More prompt topics

Need a prompt that fits your task?

Use the free Prompt Builder to turn your idea into a clear prompt in seconds.

Open the Prompt Builder