Excel formula explainer

Inherited a sheet full of formulas like =IFERROR(VLOOKUP(A2,Sheet2!$A:$C,3,FALSE),"")? Paste it and read what it does, inner parts first.

Free · No sign-up · Your files are processed on your device and never uploaded

How to use Excel formula explainer

  1. Paste or type…
    1

    Paste or type

    Put your content in the box - or try the example.

  2. Result appears instantly
    2

    Watch the result

    The result updates as you type - choose options above if needed.

  3. TXTCopy / Download
    3

    Download the result

    Ready in seconds. Your file never left your device.

Features

  • Plain-English explanation of 80+ common functions.
  • Step-by-step from the innermost part outwards.
  • Formula tree showing nesting.
  • Cell references explained, including locked $ references and other sheets.
  • Tips on common mistakes (approximate VLOOKUP, IFERROR hiding errors, slow volatile functions).

How to use it

Copy the formula from the formula bar (including or without the = sign) and paste it.

Read "In short", then the steps. The tree shows which part sits inside which.

Free and private

Everything happens inside your browser: your files are read on your own device and are never uploaded, stored or seen by anyone else.

Questions

Does it use AI?

No - a rule-based parser reads the formula, so the same formula always gets the same explanation and nothing is sent anywhere.

It says a function is not in the list

Rare and newer functions are shown by name; the rest of the formula is still explained.

Is it free?

Yes - free and unlimited, with no sign-up and no watermark.

More smart tools

All tools →