Prompts
Excel and spreadsheet prompts
Describe your columns or attach a screenshot, and get a formula with an explanation you can check. Works for Excel, Google Sheets and LibreOffice Calc.
Spreadsheet questions are easy for a chat model once it knows your layout. Most of these prompts start by asking you to describe the columns, the header row and the result you want, and then ask for the formula together with a plain explanation and a couple of test cases. That way you can check the answer instead of pasting something you do not understand into a sheet other people rely on.
The twenty prompts cover formulas from a description, explaining a formula someone else wrote, lookups that return errors, conditional sums, working days between dates, dropdown lists, conditional formatting, pivot tables, cleaning names and text, duplicates, a budget layout, moving formulas between Excel, Google Sheets and LibreOffice Calc, and short macros or Apps Script. Four are set to GPT-6.1 Terra, which reasons before replying: lookup errors, long nested IF formulas, monthly summaries and diagnosing an error from a screenshot. Two prompts work with a screenshot you attach, one to fix an error and one to pick a chart for a table.
Our chat cannot open workbook files, so paste a few sample rows as text or attach a screenshot with the formula bar visible. Hide names, salaries and anything confidential first. Always try a new formula on a copy of the sheet and compare a few results with ones you worked out by hand; a formula can look right and still point at the wrong range.
See also GBT Chat for office workers, the guide to AI for spreadsheets and the SQL Helper for database queries.
Make a prompt fit your case
- Say which program and version you use; some functions exist only in newer versions.
- Mention your separator if your language version uses semicolons instead of commas.
- Paste five real rows, including an awkward one, rather than describing the data in general.
- Ask what would break it: blanks, text in number columns, new rows.
-
Describe it, get the formula
My sheet in [Excel or Google Sheets] has headers in row 1: [list columns and what they hold]. I want a formula in [cell or column] that [what it should calculate]. Give me the formula, explain each part in plain words, and give two test cases with the result I should expect.
-
Explain a formula you inherited
Someone else built this spreadsheet and I need to understand this formula: [paste formula]. The columns it refers to hold [what each column contains]. Explain what it does step by step, from the innermost part outwards, and tell me what could make it give a wrong answer.
-
Fix a lookup that returns errors
My lookup formula [paste formula] returns [#N/A or a wrong value] for some rows even though the value seems to exist in [lookup range]. Sample values from both columns: [paste a few]. List the likely causes, such as spaces, text stored as numbers or wrong match type, how to test for each, and the corrected formula.
-
Split full names into columns
Column [letter] has full names like these: [paste examples, including awkward ones with middle names or titles]. Give me formulas to put first name and last name in separate columns in [Excel or Google Sheets], explain how they handle the awkward cases, and say which names still need fixing by hand.
-
Find and handle duplicates
My list in [columns] has duplicates, but two rows count as the same only if [which fields must match]. Show me how to highlight them, how to count them with a formula, and how to keep just the newest row per [field] using [date column]. Step by step for [Excel or Google Sheets].
-
Colour rows by a rule
I want whole rows in [range] to turn [colour] when [condition, for example the due date in column D has passed and column E is not 'Done']. Give me the exact custom formula for conditional formatting in [Excel or Google Sheets] and the clicks to set it up, and explain the dollar signs in it.
-
Build a pivot table step by step
I have a table of [what each row is] with columns [list columns]. I want to see [summary you want, for example total sales by region and month]. Walk me through building a pivot table for it in [Excel or Google Sheets], including which field goes in rows, columns and values, and how to group dates by month.
-
Diagnose an error from a screenshot
I've attached a screenshot of part of my spreadsheet with the formula bar showing. Cell [cell] shows [error or wrong value]. Explain what is causing it, write a corrected formula, and suggest a way to stop the same error spreading when I fill the formula down.
-
Which chart fits this table
I've attached a screenshot of a table from my spreadsheet. I want to show [message, for example how costs changed over the year] to [audience]. Recommend the clearest chart type and say why, which columns go on which axis, and two formatting changes that make it easier to read.
-
Working days between two dates
Column [letter] has start dates and column [letter] has end dates. Give me a formula for the number of working days between them, excluding weekends and the holiday dates I'll list in [range]. Also show how to handle a [Friday and Saturday] weekend instead, and rows where the end date is empty.
-
Sum with several conditions
I need the total of [value column] where [column] equals [value], [column] is between [start date] and [end date], and [column] is not [value]. Write the SUMIFS formula with references to cells holding these conditions so I can change them, and explain the order of its arguments.
-
Add a dropdown list
I want a dropdown in [column] so people can only choose from [list of options], and a second dropdown in [column] whose options depend on the first choice. Explain how to set both up in [Excel or Google Sheets], where to keep the option lists, and how to add new options later.
-
Lay out a monthly budget sheet
Design a simple monthly budget spreadsheet for [household or small business]. Income sources: [list]. Main costs: [list]. Describe the columns and rows, the formulas for totals and the difference between planned and actual, and a small summary area. I'll build it myself, so give cell-by-cell instructions.
-
Move a formula between apps
This formula works in [Excel or Google Sheets]: [paste formula]. I need the same result in [the other app, or LibreOffice Calc]. Translate it, explain any function that doesn't exist there or behaves differently, and mention separator or locale issues I might hit.
-
Untangle a long nested IF
This nested IF formula is hard to read and maintain: [paste formula]. Work out what it is meant to do, describe the logic as a short table of conditions and results, then rewrite it in a simpler form, for example IFS, a lookup table or SWITCH, and show that both give the same results on [sample values].
-
Pull numbers out of text
Cells in column [letter] contain text like [paste three or four examples], and I need just the [number, code or amount] from each in a new column, as a real number I can add up. Give a formula for [Excel or Google Sheets] and explain what it does when a cell has no number.
-
Monthly summary from transactions
I have a list of transactions with columns [date, description, category, amount]. Plan a summary sheet that shows each category's total per month, the monthly balance and the biggest three costs each month. Give me the formulas, explain how they stay correct when I add new rows, and point out any trap with refunds or negative amounts.
-
Make a sheet others can use
My colleagues keep breaking a spreadsheet that [what it does], with tabs [list tabs]. Suggest changes so it is harder to break and easier to understand: separating inputs from calculations, protected ranges, clear headers, notes and a short instructions tab. Order the changes from quickest to most work.
-
Automate a boring step
Every [day or week] I [describe the repetitive task in your sheet]. Write a short [VBA macro or Google Apps Script] that does it, with a comment on every few lines explaining what it does, and tell me how to run it safely on a copy first.
-
Test cases for a formula
I wrote this formula to [purpose]: [paste formula]. Make a small table of test inputs, including blank cells, zero, negative values, text where a number is expected, and boundary dates, with the result each should give. I'll paste the inputs into my sheet to see if the formula behaves.
Keep reading
Your question, answered now
No account, no card, nothing to download. Type what you want to know and the first words of the answer appear in a second or two.