Spreadsheet Practice

Free formula tools

Each tool runs our formula engine in your browser, so results are calculated, not guessed, and nothing you paste is uploaded.

Formula Explainer

Paste an Excel or Google Sheets formula and see every part of it calculated on real data, in order, with each function's arguments named.

  • Step-by-step values, innermost first
  • Checks for approximate VLOOKUPs, unlocked ranges, quotes and more
  • Use a sample table or paste your own
Explain a formula

Formula converter

Convert formulas from Excel to Google Sheets and back: ARRAYFORMULA, QUERY, SPLIT and TEXTSPLIT, REGEX functions, FILTER and more, with notes on what changes.

  • Both directions, with an explanation of each change
  • Flags functions with no equivalent
  • Conversions tested in our engine on both sides
Convert a formula

Function Translator

Excel function names in Spanish, German, French, Portuguese, Italian, Dutch and Polish, and a box that translates a whole formula, separators included.

  • 164 functions in 8 languages
  • BUSCARV, SVERWEIS, RECHERCHEV, PROCV and the rest
  • Names cross-checked against Microsoft's own articles
Translate function names

Practice on your own data

Paste a table from Excel, Google Sheets or a CSV and get 10–12 graded formula exercises built from its columns.

  • SUMIFS, XLOOKUP, FILTER, RANK and more, on your columns
  • Every exercise checked on changed data
  • Nothing leaves your browser
Practice on your data

More ways to practice

Formula Lab: a free in-browser spreadsheetFormula answers you can testFree Excel skills test