How do I group data without a pivot table?

Use the GROUP_BY formula in Datastripes: pass the range, the column to group by and the aggregation, and it returns the grouped table.

Is GROUP_BY the same as a pivot table?

It covers the common case of grouping and aggregating. Highly formatted cross-tab layouts are where classic pivot tables still have an edge.

Can I chart the grouped result?

Yes. The output is a normal table, so you can visualize it directly.

Does it work on CSV or Excel files?

Yes. Load an Excel or CSV file and apply the formula on the imported data.

How to Group Data Without Pivot Tables (Use GROUP_BY)

Group and summarize data in one formula, no pivot table

Pivot tables are powerful but fiddly for simple summaries. Datastripes gives you a GROUP_BY formula that groups and aggregates data in one line.

Why look for a pivot table alternative

Pivot tables need a field list, drag-and-drop areas and a refresh step, and they are easy to break when the source changes. For a quick "total by category" they can be more ceremony than the task deserves.The =GROUP_BY formula in Datastripes works like SQL GROUP BY inside a cell: choose the column to group by, choose what to aggregate, and the result is a normal table you can chart immediately.

From grouped table to chart

Because the output is a regular table, you can send it straight into a chart or dashboard. Change the source data and the grouped result updates with it.

Frequently asked questions

Also explore: Datastripes Features · Spreadsheet Analysis · AI Spreadsheet · CSV Visualizer

Skip the pivot table on your next summary.

Try =GROUP_BY on your own data.

Be one of the first early-birds! Join the early access

Function	Datastripes	ObservableHQ	VibeChart	Tableau	Power BI
Spreadsheet-like interface	✅	❌	❌	❌	❌
Instant & automatic dashboards	✅	❌	❌	❌	❌
Code writing (Python/SQL/JS)	✅	✅	❌	❌	❌
Custom code	✅	✅	❌	❌	❌
No code	✅	❌	✅	✅	✅
Text-to-chart	✅	❌	✅	❌	❌
Integration of chart libraries	✅	❌	✅	❌	❌
Machine Learning integration	✅	🟡	❌	🟡	🟡
Embeddabile in app esterne	🟡	✅	❌	✅	✅
Big Data Support	🟡	✅	❌	✅	✅
Interactive Dashboards	🟡	✅	🟡	✅	✅
Cost	Low Freemium	Low Freemium	Low Freemium	Premium	Medium Freemium

How to Group Data Without Pivot Tables (Use GROUP_BY) | Datastripes