Add a calculated column to Excel without formulas
A new column usually means writing a formula, dragging it down the sheet and hoping the range was right. Describe the calculation and the column comes back filled for every row.
The instruction to paste
Example instruction
Add a Margin column holding the calculated value of Revenue minus Cost
What comes back
| Product | Revenue | Cost |
|---|---|---|
| Alpha | 1200 | 700 |
| Beta | 340 | 300 |
| Gamma | 890 | 500 |
| Delta | 260 | 240 |
| Product | Revenue | Cost | Margin |
|---|---|---|---|
| Alpha | 1200 | 700 | 500 |
| Beta | 340 | 300 | 40 |
| Gamma | 890 | 500 | 390 |
| Delta | 260 | 240 | 20 |
How it works
- 01
Upload the file — .xlsx, .xls or .csv, up to 100 MB.
- 02
Paste the instruction, changing the column names to the ones in your own file.
- 03
Download the result. Whatever was cut comes back on a separate tab, so nothing is lost.
Other ways to ask
The instruction is read as a sentence, not filled into a form. These all work on the same file.
Add a Margin % column with the margin as a percentage of Revenue, rounded to one decimal place
Add a Share column with each row's Amount as a share of the total for its Region
The rows and values in your file are never sent to an AI model — only the column headers and your instruction ever leave our servers.
Questions
Do I get numbers or live Excel formulas?
Computed values by default. Ask for "the Excel formula" instead and the cells come back holding a real formula that recalculates.
Can the calculation reference other rows?
Yes — totals, averages and per-group shares all work, because the whole column is available while it is computed.
Where does the new column go?
At the end by default. Say where you want it and it goes there instead.
Related tasks
See everything you can ask forTry it on your own file
Create an account, upload your spreadsheet and paste the instruction above.