Skip to content

Griddy use cases

Spreadsheet work with a visible result.

Griddy works best when the request ends in something you can inspect: formulas in a range, a cleaned table, a native pivot, an editable chart, or a connected model.

AI for ExcelAI for Google SheetsCompare with Copilot
Excel budget workbook with formulas, conditional formatting, a chart, and the Griddy assistant sidebar
Real product screenshot: one request produced an editable budget table, linked summary, conditional formatting, and chart inside Excel.
01

Formulas

Write and repair formulas from a business rule

Name the source columns, target cells, rule, format, and edge cases. Griddy can place formulas into the spreadsheet, including cross-sheet references and filled ranges.

Explore formula generation

Example prompts

“In Summary!B2:B13, mirror Net Income from Monthly Sales!F2:F13 with formulas and format the results as currency.”
“Add a weighted forecast column using Deal Value times Probability, then fill it down without changing the source columns.”

What to verify

  • Lookups, conditional totals, date logic, ratios, and finance functions
  • Relative, absolute, and cross-sheet references
  • Formula repair with protected ranges and existing layout preserved
02

Data cleanup

Turn an export into a reliable working table

Coordinate several visible cleanup steps in one request: split columns, remove duplicates, trim whitespace, convert types, normalize values, and format the result.

See an Excel cleanup workflow

Example prompts

“Split this CSV into columns, remove duplicate emails, delete rows with blank phone numbers, and standardize names to Proper Case.”
“Convert Close Date to real dates, trim owner names, and leave the raw export sheet unchanged.”

What to verify

  • Duplicate, blank-row, whitespace, and non-printable-character cleanup
  • Text-to-columns, substring extraction, concatenation, and find/replace
  • Text-number and date conversion with explicit review checks
03

Pivot tables

Create a pivot with named fields and aggregation

Specify the source range, row and column fields, values, aggregation, filters, object name, layout, and destination. Griddy creates the native pivot object.

Build a pivot from a prompt

Example prompts

“Create a PivotTable at H1 that summarizes total Revenue by Month from A1:F13 and leave the source block alone.”
“Build a pivot showing spend by Category and Owner, with SUM of Amount and a filter for the current month.”

What to verify

  • Native pivot creation in Excel, Google Sheets, and Griddy
  • Rows, columns, values, filters, names, anchors, and layout
  • Sum, count, average, minimum, and maximum aggregations
04

Charts

Create an editable chart tied to spreadsheet data

Name the source range, category and series fields, chart type, title, destination, and placement. Griddy creates or updates the chart object in the spreadsheet.

See chart creation prompts

Example prompts

“Create a line chart titled Net Income Trend at D2 using Summary!A1:B13, with Month on the X-axis.”
“Create a bar chart of revenue by region and place it on the Dashboard sheet at A1.”

What to verify

  • Common bar, column, line, area, scatter, combo, pie, and doughnut charts
  • Explicit chart source, series mapping, title, and placement
  • Existing-chart updates when a report needs refinement
05

Formatting

Apply formatting as part of the deliverable

Ask for number formats, headers, borders, fills, alignment, widths, and conditional rules alongside the underlying spreadsheet work.

Read the conditional-formatting guide

Example prompts

“Format the forecast range as currency with no decimals and the Ratios sheet as percentages with one decimal.”
“Highlight negative variances in red and positive variances in green without changing the values.”

What to verify

  • Number, date, currency, percentage, and custom formats
  • Fonts, fills, borders, alignment, row heights, and column widths
  • Conditional formatting and data-validation rules
06

Models & structure

Build connected tables, schedules, and models

Create or complete multi-sheet spreadsheet systems with assumptions, formulas, tables, summaries, charts, and protected source ranges.

See a financial-model workflow

Example prompts

“Complete the forecast formulas from Assumptions, preserve the 2024A actual column, and add margin ratios on the Ratios sheet.”
“Build a sales commission calculator with inputs, rep payouts, bonuses, and a team summary.”

What to verify

  • Multi-sheet formulas and structure-preserving edits
  • Forecast, ratio, budget, tracker, and operating-report workflows
  • Tables, columns, sorting, filtering, and summary layouts

Start with one bounded task.

Select the range, name the result, protect what should not change, and review the spreadsheet after the edit.

Excel PluginSheets Plugin