Spreadsheet help for 12 programs
Solve spreadsheet problems with confidence
Find a working formula, troubleshoot an error, check a CSV file or compare how different spreadsheet programs handle the same task.
Start with the right tool
These browser tools and comparisons help with common tasks. Each links to more detailed guides when you need them.
CSV Import DoctorCheck separators, broken quoting, date risks and leading-zero IDs before importing a file.Inspect a CSV →
Formula Migration HelperSee curated formulas and alternatives when moving work between spreadsheet programs.Explore formula options →
Problem SolverStart with a symptom—wrong lookup result, text numbers or changing CSV dates.Find a solution →
Browse guides for your software
Choose the program you use. Each directory links to its published function guides and relevant examples.
LibreOffice Calc
Open-source Calc formulas and reproducible spreadsheet lessons.
Browse guides
Apache OpenOffice Calc
Classic Calc lookups, calculations and compatibility notes.
Browse guides
Gnumeric
Statistics, mathematical functions and scientific analysis.
Browse guides
Calligra Sheets
Spreadsheet functions and KDE workflows.
Browse guides
SoftMaker PlanMaker
Excel-file workflows, lookups and tables.
Browse guides
ONLYOFFICE Spreadsheet Editor
Cloud and desktop workbook formulas and examples.
Browse guides
Apple Numbers
Table references, calculations and text formulas.
Browse guides
Zoho Sheet
Cloud spreadsheet functions and error handling.
Browse guides
Microsoft Excel
Find the equivalent Excel formula in an alternative spreadsheet.
Browse guides
Google Sheets
Translate Sheets formulas and array behaviour to another program.
Browse guides
WPS Spreadsheet
Worked WPS Spreadsheet function guides; cross-version compatibility requires verification.
Browse guides
Collabora Office Calc
Calc-style function guides and edition-specific compatibility notes.
Browse guides
Fix a common spreadsheet issue
All problem-solving guides →
Lookup can't find a matchCheck spaces, number formats and matching behaviour.
COUNTIF gives the wrong countDiagnose text, criteria and inconsistent ranges.
CSV dates changed on importKeep ambiguous dates and identifiers intact.
A formula breaks in another appFind syntax, version and compatibility differences.
Explore useful function guides
Compare across programs →
SUM in LibreOffice CalcThe SUM function in LibreOffice Calc adds numbers, cell ranges, or mixed arguments. Learn syntax, examples, common errors, and …
COUNTIF in LibreOffice CalcThe COUNTIF function in LibreOffice Calc counts cells that meet a single condition. This guide explains syntax, operators, …
COUNTIFS in LibreOffice CalcThe COUNTIFS function in LibreOffice Calc counts cells that meet multiple conditions across one or more ranges. This guide …
VLOOKUP in LibreOffice CalcLearn the VLOOKUP function in LibreOffice Calc: Vertical search and reference to indicated cells.
REGEX in LibreOffice CalcUse REGEX in LibreOffice Calc to extract matched text, replace patterns, remove characters, and work with regular expressions.
XLOOKUP in LibreOffice CalcLearn the XLOOKUP function in LibreOffice Calc: Extended vertical search and reference to indicated cells.
Prefer working from a task? Browse the step-by-step guides, or read the detailed compatibility library.
Examples you can check, with clear evidence
Our guides explain syntax, sample inputs and expected results. We distinguish between examples tested in a spreadsheet application and those checked using vendor documentation or independent reasoning.