Frockly

Build an Excel formula from blocks, or turn an existing one into blocks to see its nesting, free in the browser.

editorProductivityvisualizationsfree toolsOnline Tools
Platforms
Web
Pricing Free

Frockly is an online Excel formula editor that works with blocks. You snap together numbers, text, cell references, ranges, arithmetic and functions such as SUM, IF, COUNTIF and AVERAGE, and the finished formula appears in a panel you can copy into Excel or another spreadsheet.

It also works backward. Paste a long, deeply nested formula and Frockly rebuilds it as a block structure, so you can collapse parts, focus on one branch and see what each piece does. You can search for a function by name, add cell references visually, define named formulas and reuse them, and try importing data and formulas from an .xlsx file (still experimental). It does not edit cell values, recalculate or save Excel files.

It is free, needs no account and runs in the browser, on desktop or phone, though desktop suits large formulas better. The interface comes in Japanese, English and French. It is an open-source project published on GitHub by Ryuu12358.