Answer a few questions.
Get the exact formula, query, or pattern.
ErgaLab turns Excel formulas, regex, SQL, XPath, CSS selectors and cron schedules into a point-and-click workflow. Everything runs client-side — nothing you type is ever sent anywhere.
column · operator · value
status equals "active"
generated
WHERE status = 'active'
Instant
Every tool computes as you type. No submit button, no loading spinner.
Private by default
No backend, no accounts, no analytics. Input never leaves your browser.
Built for clicking
Point-and-click builders instead of memorizing syntax — read the syntax back if you want it.
Spreadsheet
Excel Formula Generator
Answer a few questions and get a working Excel formula — no syntax to memorize.
Excel Formula Explainer
Paste any Excel formula and get a plain-English, part-by-part breakdown.
Google Sheets Formula Generator
Build Google Sheets formulas step by step, including QUERY and ARRAYFORMULA.
Google Sheets Formula Explainer
Understand exactly what a Google Sheets formula does before you trust it.
Regex
SQL
SQL WHERE Builder
Pick columns, operators and values to build a WHERE clause visually.
SQL JOIN Builder
Choose two tables and a join type to generate the correct JOIN syntax.
SQL Formatter
Paste messy SQL and get it cleanly indented and capitalized instantly.
SQL Beautifier
Reformat dense or minified SQL into readable, consistently styled queries.