Google Sheets

Google Sheets is a cloud-based spreadsheet tool, and its array, QUERY and regex capabilities are familiar starting points. This section includes documented, independently reasoned function examples and practical translation into alternative spreadsheet apps.

What you can do here

• Compare lookup, criteria, error-handling, array and text formulas with programs such as LibreOffice, Apple Numbers and Zoho Sheet.
• Follow the version notes and read the underlying vendor references rather than assuming that similarly named functions behave identically.
• Try the Formula Migration Helper and compatibility library with a common sample dataset.

Vendor documentation

Read the official documentation for product-specific features and arguments.

Before moving a workbook

Sheets uses the RE2 regular-expression engine. Function availability, regional separators and import/export behaviour can differ from desktop spreadsheet apps.

Verification status: Official product documentation reviewed for this overview. Any listed formulas elsewhere on the site carry their own evidence status. No native tests in this product are claimed by this page, and no simulated application screenshots are presented.

Individual function guides

Our growing A–Z function directory has worked examples and review notes for selected documented functions. Absence of a guide does not prove a function is unsupported.