Can I Spreadsheet?

Spreadsheet how-to recipes

282 common spreadsheet tasks with copy-paste formulas for Microsoft Excel, Google Sheets, and LibreOffice Calc — each recipe formula executed and verified in LibreOffice Calc. 282 of them have also been executed in Google Sheets (2026-08-30), and those pages show what each engine actually returned side by side. Excel is documentation only.

What the two engines did with the same 282 recipes: 282 had their worked example — and every extra formula on the page — executed in Google Sheets (2026-08-30, Drive import) as well as LibreOffice. 265 came back with exactly the values LibreOffice produced. 17 disagreed on at least one formula, and those are the interesting ones: a function Google Sheets lacks, an argument that means something else there, or an array expression it declines to expand inside a scalar function. Each of those pages prints both engines’ values side by side and flags the disagreement rather than picking a winner. Every recipe in the corpus has now been executed in both engines, including the ones whose worked examples need extra worksheets — those are built one workbook per check, so their tab names and tab order survive the Drive round-trip without anything being renamed or rewritten.

Dates & times (85) · Text & names (53) · Lookups & filters (46) · Counting & conditions (34) · Formatting & display (6) · Math, money & stats (58)

Dates & times

Text & names

Lookups & filters

Counting & conditions

Formatting & display

Math, money & stats