Spreadsheet help

Group spreadsheet data by category.

Use this page for grouped spreadsheet summaries like sales by category, churn by region, or MRR by plan.

Spreadsheet helpExcelDemo dataset ready

How to use it

Start with the same request, then adjust it to your sheet.

Use this page for grouped spreadsheet summaries like sales by category, churn by region, or MRR by plan.

Step by step

  • State the grouping dimension and the metric to aggregate.
  • Generate the grouped summary.
  • Review the output table before adapting the prompt further.

Useful variations

  • Ask for totals, counts, or averages.
  • Mention the date window if you only want the current month or quarter.

Worked example

Example input and output

CategoryRevenue
Starter Plan13800
Enterprise32600

Expected output

CategoryRevenue
Enterprise32600
Pro Plan27700
Starter Plan13800

Try it now

Open the tool with this example already filled in.
Open this example

Related pages

Keep going from here.