The Excel Pivot Table Alternative for Large Files. SQL Power. No Database. No Uploads.
GROUP BY up to 10 dimensions. Apply 19 aggregation functions including MEDIAN, percentiles, and STDDEV. Filter groups with SQL HAVING logic. A browser-native aggregation engine for CSV — the analytical power of OLAP without infrastructure, uploads, or code.
Benchmarked February 2026 · Chrome 132 · Intel i7-12700K · 32GB RAM · Full methodology →
The Excel Pivot Table Problem
Freezes at 300K–500K rows
Excel Pivot Tables become unusable on large datasets. You sit watching the spinning cursor while your deadline passes.
No HAVING filters
"Show only regions where revenue > $50K" requires copying pivot results to a new sheet, applying manual filters, and repeating every time data changes.
No MEDIAN, no percentiles
Excel Pivot Tables don't support true MEDIAN or P90/P95 percentiles. AVERAGE is misleading when your data has outliers — which it always does.
Everything Excel Pivot Tables Can't Do
SQL HAVING Filters
Filter groups after aggregation using the full SQL HAVING logic. AND/OR combinations. Show only the groups that meet your threshold — not the full table.
19 Aggregation Functions
COUNT, SUM, AVG, MIN, MAX, MEDIAN, MODE, STDDEV, VARIANCE, P25, P50, P75, P90, P95, FIRST, LAST, RANGE, COUNT_DISTINCT, CONCAT_UNIQUE.
Multi-Level GROUP BY
Group by up to 10 dimensions with drag-to-reorder. Hierarchical subtotals and grand total row included. Region → Country → State → City — all in one pass.
Top-N with Correct Other Rollup
Show only the top 100 SKUs by revenue. All remaining groups become a single 'Other (47,832 SKUs)' row. Critically: AVG for Other is recalculated as a true weighted average — not average of averages, which would be mathematically wrong.
% of Total Columns
Automatically add '% of Total' columns for every metric. SUM(Revenue) and SUM(Revenue) % of Total side by side — no manual formula required.
Zero Uploads — Supports HIPAA/GDPR Workflows
All processing runs in your browser using Web Workers. No file contents are transmitted to our servers — not during upload, not during processing, not at any point. Designed for HIPAA/GDPR-sensitive workflows by architecture.
What Does Slow Aggregation Cost?
Excel Pivot on large files: ~20 min setup + wait. SplitForge: ~2 min.
Baseline: 20 min derived from internal timing of Excel Pivot Table setup and processing on 500K–1M row exports. Results vary by file size and workflow. Adjust assumptions with the full calculator →
SplitForge vs Excel Pivot Tables — Feature Comparison
See exactly where Excel Pivot Tables stop working — and where SplitForge picks up.
| Feature | SplitForge | Excel Pivot | Power BI | SQL | Python/Pandas |
|---|---|---|---|---|---|
| Row Limit | 10M+ rows tested | 300K–500K (struggles) | 5M (dataset limits) | Database-dependent | 10M+ (memory-bound) |
| Aggregation Functions | 19 functions | 11 basic functions | Many (DAX) | Full SQL | Unlimited (code) |
| MEDIAN / True Percentiles | Yes | No | Via DAX MEDIAN() | PERCENTILE_CONT() | Yes (code) |
| HAVING Filters | Yes — visual GUI | No | Via DAX (complex) | Yes (HAVING clause) | Via .query() (code) |
| Multi-Level GROUP BY | Up to 10 dimensions | 2–3 (degrades) | Many dimensions | Unlimited | Unlimited (code) |
| Data Privacy | Never uploaded | Local | Cloud uploads | Depends on host | Local |
| No Code Required | Yes | Yes | Mostly (DAX needed) | No | No |
| Cost | No subscription | Included with Excel | $10/user/month | DB infrastructure | Open source (code required) |
| Setup Time | < 30 seconds | 2–5 minutes | Hours (data model) | Hours (DB pipeline) | 5–30 min (script) |
* Power BI dataset row limits depend on licensing tier and whether Premium capacity is enabled. Prices and limits based on publicly listed plans as of February 2026.
Which Tool Fits How You Think?
Use SplitForge if you…
Stick with alternatives if you…
Real-World Aggregation Workflows
Six workflows where Excel Pivot Tables break down — and SplitForge picks up.
Sales Performance Reports
500K transaction rows. Finance needs regional performance (Region → State → Rep) with revenue, order count, and average deal size — by 9am Monday.
GROUP BY Region/State/Rep. SUM(Revenue), COUNT(Orders), AVG(Deal), MEDIAN(Deal). HAVING Revenue > $100K. Hierarchical subtotals. Download. 23 seconds total.
E-commerce SKU Analysis
2M order lines. Need SKU-level metrics — units sold, revenue, unique customer count — across 50K SKUs. Excel freezes at 500K rows.
GROUP BY SKU/Category. SUM(Units), SUM(Revenue), COUNT_DISTINCT(CustomerID), P50/P90(Price). HAVING Units >= 100. Top 500 SKUs + Other rollup. Under 90 seconds.
Healthcare Outcomes Analysis
1M patient records. Need outcomes by Facility → Department → Procedure. HIPAA requires no uploads to third-party servers.
GROUP BY Facility/Dept/Procedure. AVG(StayDays), STDDEV(StayDays), COUNT(Readmissions), VARIANCE(Cost). HAVING AvgStay > 5 OR Readmissions > 20. 100% client-side. 45 seconds.
Expense Reporting for Finance
800K expense rows. CFO needs Department → Category → Vendor breakdown with totals, frequency, and P95 outlier detection.
GROUP BY Dept/Category/Vendor. SUM(Amount), COUNT(Txns), AVG(Amount), P95(Amount). HAVING SUM(Amount) > $10K. % of Total columns for share-of-budget view. 18 seconds.
Marketing Attribution
3M campaign events. Need Channel → Campaign → Creative performance with conversions, CPA, and ROI — before the morning standup.
GROUP BY Channel/Campaign/Creative. SUM(Conversions), SUM(Spend), AVG(CPA), COUNT_DISTINCT(Users), MEDIAN(CPA). HAVING Conversions > 50 AND AvgCPA < $25. Top 100 campaigns. 52 seconds.
Inventory Turnover Optimization
1.5M inventory movements across 200 warehouses. Need turnover rates, stock-out frequency, and reorder patterns by Warehouse → SKU → Vendor.
GROUP BY Warehouse/SKU/Vendor. FIRST(DateIn), LAST(DateOut), RANGE(Days), AVG(TurnoverDays), COUNT(StockOuts). HAVING TurnoverDays > 90 OR StockOuts > 3. 38 seconds.
Edge Cases & Technical Depth
How SplitForge handles the aggregation problems most tools quietly get wrong.
MEDIAN vs AVERAGE — When It Actually Matters
When your data has outliers, AVERAGE lies. MEDIAN tells the truth.
HAVING vs WHERE — Why You Need Post-Aggregation Filtering
Filtering before aggregation and after aggregation are completely different operations.
Multi-Level GROUP BY at Scale — 10 Dimensions, 10M Rows
Excel Pivot Tables often become slow and memory-constrained above 3 dimensions depending on system RAM. SplitForge handles 10.
Mixed Data Types in GROUP BY Columns
What happens when the same column contains '123', 123, and '123.0'?
COUNT_DISTINCT at 10M Rows — Memory vs Speed Trade-off
Counting unique values across millions of rows requires storing a Set per group.
Top-N 'Other' Rollup — When Your Last-Place Groups Still Matter
Top-100 SKUs plus one 'Other (47,832 SKUs)' row — full picture without full detail.
Who SplitForge Is — and Isn't — Built For
Great fit for
Not the right fit if you need
10 Million Rows in ~34 Seconds
Full advanced mode — 19 functions including MEDIAN, P90, STDDEV — on a 1.2GB CSV. All in your browser, zero uploads.
Advanced mode: 19 functions including MEDIAN, P90, P95, STDDEV, COUNT_DISTINCT
Method: 10 runs, highest/lowest discarded, 8 averaged
Variance: Results vary by hardware, browser, and configuration complexity (±15–20%)
Frequently Asked Questions
How much does it cost?
Is my data uploaded or stored anywhere?
What's the maximum file size?
What are HAVING filters?
What functions does SplitForge support that Excel Pivot Tables don't?
Can I do multi-level GROUP BY with subtotals?
What is the "Top-N with Other" feature?
What outputs do I get?
Does SplitForge have any limitations?
What browsers are supported?
Complete Your Data Workflow
Data Cleaner →
Standardize messy columns before aggregating. Fix inconsistent category names, normalize phone numbers, strip HTML — clean data = accurate GROUP BY results.
VLOOKUP / Join →
Join two CSVs before aggregating. Enrich transaction data with customer attributes, product metadata, or region mappings — then run GROUP BY on the combined file.
Data Profiler →
Understand your data before aggregating. See column statistics, detect outliers, and identify which columns make sense as GROUP BY dimensions vs metrics.
Stop Fighting Excel's Limits.
19 aggregation functions. SQL HAVING filters. Multi-level subtotals. 10M rows in under a minute. Browser-native OLAP for CSV — analytical power without infrastructure, uploads, or code.
Also try: Pivot/Unpivot · VLOOKUP/Join · Data Cleaner · Data Profiler