Open spreadsheet compatibility dataset
The machine-verified data behind this site is free to use. It records, for 600 spreadsheet functions, whether each works in Microsoft Excel and Google Sheets (from official documentation) and in LibreOffice Calc (from actually executing the formula, with per-version history). As far as we know it’s the only openly available executed cross-application compatibility dataset.
Download
data/compat.json — one JSON object, keyed by uppercase function name (600 entries, 58 KB). The full test harness, authored test cases, and raw per-LibreOffice-version results are in the GitHub repository.
Schema
| Field | Type | Meaning |
|---|---|---|
cat | string | Function category (e.g. “Lookup and reference”). |
x | boolean | Documented in Microsoft Excel. |
g | boolean | Documented in Google Sheets. |
l | boolean | Documented in LibreOffice Calc. |
lv | string / null | LibreOffice executed verdict: supported, quirky, unsupported, or null when not yet live-tested. |
lver | string | LibreOffice version the verdict was produced on (e.g. 25.8.7.3). |
lnew | string / null | The LibreOffice version the function first became supported in, when known (else null). |
Example
// fetch the dataset
const db = await (await fetch("https://canispreadsheet.com/data/compat.json")).json();
db["XLOOKUP"]
// {"cat":"Lookup and reference","x":true,"g":true,"l":true,
// "lv":"supported","lver":"25.8.7.3","lnew":"24.8.7.2"}
// -> documented in all three; executed as supported in LibreOffice,
// first working in LibreOffice 24.8.License
The compatibility dataset is released under Creative Commons Attribution 4.0 (CC BY 4.0). Use it freely, including commercially — just credit canispreadsheet.com with a link. If you build something with it, we’d love to hear about it.
The data reflects executed tests on the LibreOffice versions noted and each vendor’s published function documentation at the time of testing; it is provided as-is, without warranty. Corrections welcome via the repository.