Back to tools

Data Studio

Find Spreadsheet Formulas by Task for Free

Find Excel and Google Sheets formulas free by task or function name. Compare syntax with LibreOffice Calc and check examples against your workbook and software version.

Start using
Local & online features

YOUR WORKSPACE

Spreadsheet Formula Search

Choose your input to begin
  1. Add input
  2. Choose options
  3. Process
  4. Use your result
Loading tool…
Full instructions and common questions

Spreadsheet Formula Search

Find Excel and Google Sheets formulas free by task or function name. Compare syntax with LibreOffice Calc and check examples against your workbook and software version.

How to use

  1. Search by a function name, task keyword, or description, then filter by category and spreadsheet app.
  2. Review the function description, signature, copyable example, and compatibility note.
  3. 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.

Explore tools

Free use and requirements

Use the local functions for free without a KitNelo account. Optional Gemini generation sends the supplied text to Google and requires a configured server API key; provider fees and quotas can apply.

Examples are references. Check separators, software version and source ranges in your own workbook.

Read KitNelo data and privacy details

Free online functions: steps and checks

Find an Excel Formula by Task for Free

Describe the spreadsheet task or search a function name to find a relevant Excel formula example. Replace sample ranges with your own cells and check the required Excel version before using the expression in a workbook.

Search Google Sheets Functions for Free

Choose Google Sheets and search for a calculation, lookup or text task to inspect matching functions. Use the shown syntax as a reference, then confirm the argument order, separators and actual sheet ranges in your document.

Compare Spreadsheet Formula Syntax for Free

Review examples across Excel, Google Sheets and LibreOffice Calc when moving a calculation between applications. Compare function availability and separators rather than assuming identical behavior, and test the adapted formula against a small set of known results.

Related tools for your next step

Browse this tool category

Practical guides

Simplified Chinese