Spreadsheet Formula Builder

BeginnerproductivityMinimum 16K context

Builds and explains spreadsheet formulas for Excel and Google Sheets from a plain-language description of the goal. Handles lookups, conditional aggregation, date math, text parsing, array formulas, and pivot-style summaries, explains how each part works, and debugs formulas that return errors or wrong values.

spreadsheetexcelgoogle-sheetsformulasdata-analysis

Use cases

  • Translating a plain-language requirement into a working formula
  • Debugging
  • Replacing fragile nested IFs with a cleaner approach
  • Building conditional aggregations and lookups across sheets

Example prompt

I need a Google Sheets formula for this.

Sheet "Orders" has columns: date (A), customer (B), region (C), amount (D).

I want, for a given region in cell F1, the total amount for the current month only, ignoring
blank rows.

Give me the formula, explain each part, note any assumption about date formats, and show how it
would differ in Excel.

Recommended models

claude-opus-5gemini-3-6-flashgemini-3-5-flash-lite

Compatible tools

claude-codekiroany

Modalities

Input: text
→
Output: text

Related Skills

data-analysiscsv-data-cleanerchart-generator

Author

OpenModels Community

@openmodelsrun