LoveByPDF logo

LoveByPDF

EN

Excel Agent

Open your Excel or CSV file and say what you need in plain words — a formula, cleaning, sorting, a pivot table or a chart. Formulas are checked, explained and previewed on the sheet before you insert them. How it works · Formula guides

All tools

Drop your Excel or CSV file(s) here

or

Up to 8 files, 40 MB each. Inspecting your file is free, no account needed.

Your file is analyzed and then deleted — never stored, never shared. Your original is never overwritten.

Excel Agent is built for the moment when you know exactly what you want a spreadsheet to do, but not the formula, PivotTable, or VLOOKUP that would do it. Upload one or more Excel or CSV files and describe what you need in plain English - cleaning up messy data, adding a calculated column, combining two files by a shared ID, building a summary by group, or just tidying up formatting. Excel Agent reads your file for real, turns your request into a concrete, numbered list of steps, and shows you that list before anything happens - nothing is invented and no number is guessed: if something you asked for genuinely isn't possible with the data in your file, it says so plainly instead of making something up. Once you approve the plan, every step runs through ordinary, deterministic code (never AI-written formulas or AI-run calculations), and the finished file is re-opened and checked before you ever see a download link - so what you get back is verified, not just assumed to have worked.

How to use this tool

  1. Upload one or more .xlsx or .csv files - reading and profiling them is free and needs no account.
  2. Type what you want done in plain English, or use the one-click "Clean Excel" preset for routine tidy-up (removing duplicates, blank rows, stray whitespace).
  3. Review the exact steps Excel Agent worked out before anything runs, and edit your request if it's not quite right.
  4. Approve the plan and download your finished, verified file, along with a plain-English summary of everything that changed.

Frequently asked questions

Will this invent numbers or columns that aren't in my file?

No. Excel Agent only ever works with columns and values that genuinely exist in your uploaded file - every step in a plan is checked against your file's real structure twice, once before you see it and once again right before it runs. If a request needs data your file doesn't have (a "profit margin" with no cost column, for example), it tells you plainly instead of guessing.

Does AI calculate the numbers in my spreadsheet?

No. AI is only ever used to turn your plain-English request into a named list of steps - every actual calculation, filter, sort, or merge is carried out by ordinary, deterministic code, the same way a formula would compute it, never by an AI model doing arithmetic or writing a formula string that gets evaluated blindly.

What if my request is ambiguous?

Excel Agent would rather ask than guess. If a request could reasonably mean more than one thing, or would require deleting data without being clear about it, you'll see a clarifying note instead of a plan - so nothing gets removed or changed based on a guess about what you meant.

Is my original file safe?

Yes - your uploaded file is never modified in place. Excel Agent always writes its result to a brand-new file, and your original stays exactly as you uploaded it.

Is using Excel Agent free?

Uploading and inspecting your file is always free and needs no account. Getting an AI plan and actually running it are separately priced paid steps (each with a few free uses), and the no-AI "Clean Excel" preset works even without any AI configured.

How to use Excel Agent

How to get Excel formulas from plain English – step by step

Not sure which Excel formula to write? Open your workbook in Excel Agent's Formula Studio, click the cell where the answer should go and say what you need in plain words. You get a real Excel formula that is checked, explained and previewed on your sheet before you insert it.

  1. Open your Excel or CSV file

    Drag your workbook onto the Formula Studio upload box or press Browse for a file (up to 40 MB). Opening the file is free and your original is never overwritten.

    Step 1: Open your Excel or CSV file
  2. Click the cell for the result

    Your sheet appears on the page. Click the cell where you want the formula; its address is shown above the request box.

    Step 2: Click the cell for the result
  3. Say what you need in plain words

    Type your request, for example total of Units, then press Generate. Mention column names so the formula uses the right columns.

    Step 3: Say what you need in plain words
  4. Check the formula

    The formula is shown with a plain-English explanation of what it does and a preview of the result. Read it, then press Insert if it is what you want.

    Step 4: Check the formula
  5. Download the updated workbook

    Press Download to save your workbook with the formula in place. Only the cells you inserted are changed.

    Step 5: Download the updated workbook

Quick tips

  • Name the columns in your request: total of Units in column E works better than total.
  • Always read the explanation and look at the preview before you insert.
  • Keep a copy of the original file; the download is a new file, but it is a good habit.

Common problems & fixes

The formula is not what I wanted
Rephrase the request with more detail, for example the columns and the condition, and press Generate again.
Nothing happens when I press Generate
Click a cell on the sheet first so the tool knows where the result goes.
My file will not open
Save it as .xlsx or .csv and try again; very old formats are not supported.
The result shows an error
Check that the referenced cells hold numbers and not text.

Frequently asked questions

Can it write an Excel formula for me?

Yes. Describe what you need in plain words and Formula Studio returns a formula with an explanation.

Will it change my file?

Only the cells you choose to insert into, and the result is a new download; your original is not overwritten.

Which formulas can it write?

Everyday formulas: totals, counts, conditions with IF, lookups, and text or date formulas. Describe the result you want and it picks the formula.

Is my spreadsheet stored?

No. It is analysed and deleted automatically.

Is it free?

Opening your file in Formula Studio is free; check the page for the current price of other Excel Agent features.

You might also need