Can I Spreadsheet?

Can I Spreadsheet?

caniuse.com for spreadsheet functions. Search any function to see whether it's documented, tested, and how Excel, Google Sheets, LibreOffice Calc, and Excel for the web actually behave.

600 of 600 functions

🔍 Formula compatibility checker Paste any formula — instantly see if every function works in Excel, Google Sheets, current LibreOffice & Excel for the web. 📝 How-to recipes Copy-paste formulas for common tasks — each one executed and verified in LibreOffice Calc, not just documented. ⚠️ Quirks & gotchas Where the three apps disagree on the same formula — surprising differences caught by running them. 📈 LibreOffice by version Which functions each LibreOffice release supports — XLOOKUP, FILTER, SORT & 15 more, tested across versions. ⚖️ Function comparisons VLOOKUP vs XLOOKUP, SUMIF vs SUMIFS, IFERROR vs IFNA — which to use when, with real compatibility data.

Popular functions

The most-searched functions, each with executed cross-app results and version history:

OFFSETMEDIANMINIFSFORECAST.ETSMROUNDCHARERROR.TYPEISERRORNUMBERVALUEABSSTDEVVLOOKUPXLOOKUPINDEXMATCHINDIRECTIFIFSIFERRORSUMIFSUMIFSCOUNTIFCOUNTIFSFILTERSORTUNIQUESEQUENCETEXTJOINCONCATENATETEXTSPLITSUBSTITUTELEFTMIDRIGHTTEXTDATEDIFEOMONTHWEEKDAYNETWORKDAYSWORKDAYAVERAGEIFMAXIFSROUNDMODPMT

600Functions inventoried
3/4Engines executed
6987Test cases executed
1193Quirks discovered
Methodology: every result badge on this site traces back to a formula that was actually written into a real workbook and recalculated by that engine, proven with deterministic and volatile canary formulas on every run (see the test harness). Nothing here is scraped from vendor docs and presented as tested. LibreOffice Calc (four pinned builds) and Google Sheets (Drive import, 2026-09-01) are both executed; Excel is not — its column is Microsoft’s documented behavior, which is what the executed engines are measured against. Functions we haven't run through an engine yet are labeled not yet live-tested and show inventory data only.

Most compatibility-interesting functions

All functions