Spreadsheet Formula Search
Full instructions and common questions
Spreadsheet Formula Search
Find common Excel, Google Sheets, and LibreOffice Calc functions by task, name, or app. Review syntax, examples, compatibility notes, and practical formula recipes.
How to use
- Search by a function name, task keyword, or description, then filter by category and spreadsheet app.
- Review the function description, signature, copyable example, and compatibility note.
- Browse formula recipes, replace the sample ranges and criteria, and confirm the result in your spreadsheet app.
Try an example
Search “sum by multiple criteria” to find SUMIFS. Filter for Google Sheets to find app-specific functions such as QUERY and IMPORTRANGE.
Limits and privacy
This is a curated index of common functions, not a complete mirror of every function in every app, version, or locale. Separators, function names, array behavior, and availability may vary. Consult vendor documentation and verify important formulas in the target app.
Common questions
Why does a copied formula return an error?
Check whether your app and version support the function, whether your locale expects semicolons, and whether date or array arguments use the expected format.
Can I reuse formulas unchanged across Excel, Sheets, and Calc?
Not always. Prefer common functions marked for multiple apps, and review notes for app-specific or dynamic-array functions.
Does this tool read my spreadsheet files?
No. It provides formula references and copy actions; it does not upload or read workbooks.