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, and LibreOffice Calc actually behave.

600 of 600 functions

🔍 Formula compatibility checker Paste any formula — instantly see if every function works in Excel, Google Sheets & current LibreOffice. 📝 How-to recipes Copy-paste formulas for common tasks — each one executed and verified in a real engine, 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
1/3Engines executed
834Test cases executed
55Quirks 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. 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