Formula Checker · Fixer · Formatter · Converters

Check, fix and understand spreadsheet formulas.

Catch structural mistakes, clean common copy-and-paste problems, format nested formulas, convert references and translate supported localized functions — with core tools running in your browser.

Browser-based tools450+ function referencesOriginal practical guides

Fast syntax sanity check

Formula Checker

Catch common structural problems before pasting a formula into your workbook. This is a syntax helper, not a spreadsheet calculation engine.

Formula

No checks run yet.

7+browser-based formula utilities

450+function reference entries

4mapped formula languages

0formula uploads required for local tools

Fix the problem first

Check, repair and format formulas

Start with the job you need to finish, then move into translation or reference material only when it helps.

Fix a formula

Repair safe mechanical issues such as smart quotes, separators and missing =.

Format a long formula

Indent nested functions so the structure is easier to audit.

Explain the structure

Identify functions, nesting depth and likely purpose.

Translate a formula

Convert supported localized function names and separators.

Fast spreadsheet converters

Handle regional and reference differences

All converters →

Date serial converter1900/1904 serial numbers ↔ calendar dates. A1 ↔ R1C1Convert direct cell coordinates between reference styles. Comma ↔ semicolonChange argument separators without touching quoted text.

Formula Lab

More ways to work with a formula

Useful tools stay separate so each page solves one clear problem.

Google Sheets checker

Run structural checks with platform-specific caveats.

Build from a recipe

Generate a starting formula for common tasks.

Find a function

Search more than 450 canonical function names.

Translation table

Browse explicit English, French, German and Spanish mappings.

Deep dives

Popular function guides

Browse the library →

XLOOKUPSyntax, examples, translations and practical notes. SUMIFSSyntax, examples, translations and practical notes. IFSyntax, examples, translations and practical notes. FILTERSyntax, examples, translations and practical notes. TEXTJOINSyntax, examples, translations and practical notes. NETWORKDAYSSyntax, examples, translations and practical notes.