EN8BLORAn app bySoluptions
ESOpen EN8BLOR

Free · Open source · In your browser

Excel formulas,built with blocks.

Long formulas are hard to write in a single line and harder to read later. EN8BLOR turns them into blocks you can see, move and reorganise, writes the formula for you, laid out to read, and turns any formula back into blocks.

Open EN8BLORSee how it works
  • 372 Excel functions
  • Blocks in English or Spanish
  • Nothing to install
  • No account
=LET(PRICE, B2, QTY, C2, TOTAL, PRICE * QTY, IF(TOTAL > 100, TOTAL - 10, TOTAL))

Illustration of how EN8BLOR works. The real app, shown further down, looks like this.

372Excel functions as blocksIn 13 categories, from logical and lookup to financial and engineering.
2languages for the blocksFunction names in English or Spanish on the blocks, and the separator you use: comma or semicolon.
0installs and accountsIt opens in the browser and keeps your work there.
100%open sourceFree to use. The code is public: read it, run it, improve it.

Build

Drag and snap.
The formula writes itself.

Every Excel function is a block with its arguments in place. Snap blocks into each other and the formula is written as you go, in the result panel inside the editor.

  • Search the functions by name or filter them by category.
  • Every function comes with examples to start from.
  • Select a function block and a small toolbox appears over it: add arguments and operators right there.
  • Several formulas on the same canvas: select a block and the result panel shows its formula.
  • Numbers, text, references, variables, maths and comparisons are blocks too.
Functions per category
  1. Statistical68
  2. Engineering49
  3. Financial48
  4. Math36
  5. Text32
  6. Compatibility32
  7. Lookup31
  8. Date25
  9. Information17
  10. Logical12
  11. Database12
  12. Cube7
  13. Web3

372 functions

Read

From one long line
to a formula you can read.

EN8BLOR lays out the formula it writes: one argument per line, LET names next to their values, every closing bracket where you expect it. The result still works in Excel and Google Sheets.

What you usually see
=LET(SALES, SUMIFS($G$2:$G$500, $B$2:$B$500, A2, $C$2:$C$500, ">="&$J$1), TARGET, XLOOKUP(A2, $L$2:$L$40, $M$2:$M$40, 0), IF(TARGET = 0, "No target", IF(SALES >= TARGET, "On target", ROUND(SALES / TARGET * 100, 0) & "%")))
What EN8BLOR writes
=LET(
    SALES, SUMIFS($G$2:$G$500,
        $B$2:$B$500,
        A2,
        $C$2:$C$500,
        ">="&$J$1
    ),
    TARGET, XLOOKUP(A2,
        $L$2:$L$40,
        $M$2:$M$40,
        0
    ),
    IF(TARGET = 0,
        "No target",
        IF(SALES >= TARGET,
            "On target",
            ROUND(SALES / TARGET * 100,
                0
            ) & "%"
        )
    )
)

Blocks in English or Spanish

Choose Spanish and the blocks show the function names of a Spanish Excel, with the semicolon as separator. Choose English for the English names and the comma.

The formula EN8BLOR writes uses the English function names, with the separator you chose.

IFSI
XLOOKUPBUSCARX
SUMIFSSUMAR.SI.CONJUNTO
IFERRORSI.ERROR
ROUNDREDONDEAR
INDEXINDICE
RESULT:=ROUND(SALES / TARGET, 2)=ROUND(SALES / TARGET; 2)Separator: ,;

Decode

Any formula,
back into blocks.

Copy a formula from a workbook, an email or a forum, paste it in the decoder and EN8BLOR builds its blocks. The quickest way to understand a formula someone else wrote, or one you wrote a year ago.

  • Paste a formula: the blocks appear, ready to change.
  • Select a cell with a formula in the grid and EN8BLOR offers to decode it.
  • Import a workbook and decode the formulas it already has.
Decode formula=IFERROR(INDEX($C$2:$C$90, MATCH(A2, $B$2:$B$90, 0)), "Missing")
=
IFERROR−2+
INDEX−2+
Reference$C$2:$C$90
MATCH−3+
ReferenceA2
Reference$B$2:$B$90
Number0
StringMissing

LAMBDA

Write a LAMBDA.
Test it straight away.

Testing a LAMBDA in Excel means knowing that you have to call it with its values at the end. EN8BLOR finds its arguments, asks you for them and builds the call for you.

  1. 1It finds the arguments the LAMBDA needs.
  2. 2Type each value, or select a cell, a range or a named range.
  3. 3It inserts the call in the grid and calculates it.
LAMBDA arguments×
=LAMBDA(a, b, a * b)

Type a value or select a reference

Insert and calculate
C1fx=LAMBDA(a, b, a * b)(A1, B1)

Grid

A grid next to the editor,
to try formulas without leaving.

Insert the formula you just built into the grid and see what it returns. Show the grid or hide it, make it wider or narrower, or swap it to the other side of the editor.

Feels like a spreadsheet

Type data, edit cells, move with Enter and the arrow keys, select cells and ranges.

Sheets

Add and delete sheets in a clear, visual way.

Named ranges

Create names for your ranges and use them in your formulas.

The ghost grid

Pick a reference for a block from a small floating grid, even with the main grid hidden.

Import workbooks

Open an .xlsx file with all its sheets and formulas, and decode them into blocks.

Export to .xlsx

Save the grid with its formulas, with the separator your regional settings use.

The grid calculates the most used functions (SUM, IF, XLOOKUP, FILTER, LET, LAMBDA and others) to test your formulas. Excel is still the reference for the final result.

The real app

Built around the editor.

The editor fills the window. The tools take the least room they need, the formula is written inside the canvas, and the grid sits beside it when you want it.

EN8BLOR with a LET formula built from blocks (an XLOOKUP inside), its laid-out result, and the grid on the right where the formula returns 108

And more

The details that save
time every day.

My Snippets

Keep the formulas you use most in your own library.

.en8blor projects

Save all the formulas on your canvas in one file and open it later.

Minimap

See every block on the canvas and jump to any of them.

Collapse and expand

Fold the parts of a formula you are not working on.

Zoom and focus

Zoom in and out, and centre the formula you are working on.

Your layout

Swap the editor and the grid left or right, and show only the toolboxes you need.

Saved as you go

Your canvas is saved in the browser while you work.

Quick lists

Data types and operators in two dropdowns, one step away.

Open source

Free, and open
for anyone to improve.

EN8BLOR started as a tool for our own work with large Excel models: building long formulas without switching back and forth to Excel all the time. It helped, so we shared it. It keeps evolving with the needs of the people who use it.

Open EN8BLORSee the code

Free to use

No account, no subscription, no limits. Open it and start.

The code is public

Read how it works, run it yourself and propose improvements.

Your work stays with you

The editor runs in your browser. Your canvas, your snippets and the workbooks you open stay on your computer.

Built on Blockly

The block editor is Blockly, the open-source visual programming library.

Some Google Sheets–only functions, such as ARRAYFORMULA, have not been tested yet.

Your next long formula,
one block at a time.

EN8BLOR opens in your browser on a computer. Nothing to install.

Open EN8BLOR

What you need

Where
A web browser on a computer. The editor is made for a large screen.
Price
Free. Open source.
Formulas
Excel and Google Sheets (some functions that only exist in Google Sheets are not tested yet). Blocks in English or Spanish.
App language
English