Import CSV or TSV
Select a UTF-8 file, paste delimited text, or explore the included sample. Quoted commas and multiline cells are supported.
DATA ANALYSIS STUDIO
CSV Pivot Table Maker
Turn rows of raw data into clear answers. Group fields, compare categories, calculate metrics and export polished pivot tables — all on your device.
✓ Multi-level grouping✓ 6 aggregations✓ No server upload
Pivot workspace
Import your data, design a pivot and export the result.
1. Choose your dataset
Import a CSV, TSV or delimited text file. The first non-empty record is used as the header.
Drop your CSV file here
or choose a file to start building
CSV / TSV / TXT · up to 35 MB · UTF-8OR START ANOTHER WAY
Reading your CSV…0%
✓ Ready
Preview source records (first 8)
Preview values are shortened for display; analysis uses the original data.
Inspect source column quality
Column statistics are computed locally from up to 10,000 records, not the full dataset.
| Column | Type hint | Blank | Numeric | Distinct | Examples |
|---|
2
Build your pivot table
Click a field action to assign it, then refine its settings.
Rows
Group verticallyColumns
Compare horizontallyValues
Metrics to calculateFilters
All conditions must match3
Pivot table results
Your grouped results will appear here.
0Source rows
0Matched records
0Grouped rows
0Value columns
Ready for your first pivot
Add a field to Values and optionally assign rows and columns.
Source records behind this cell
Select a pivot value to inspect the underlying records.
0 / 0
Source values are unchanged. The download contains only the displayed source-record page, not the full underlying dataset.
Select any calculated value to inspect contributing source records. Excel export creates a static summary worksheet, not an Excel-native PivotTable. Copy page copies only the visible rows. Downloads export all grouped rows, not just the current page. CSV and TSV exports neutralize text that could otherwise be interpreted as spreadsheet formulas.
EXPLORE MORE
From CSV to insights in three steps
Make summary tables without installing spreadsheet software or sending data to a server.
Group, filter and calculate
Stack row dimensions, create column comparisons, group ISO dates, and add sums, counts, averages, minimums, maximums or unique counts.
Export and share
Download the full pivot as CSV, TSV, JSON, a static XLSX summary, or a self-contained HTML report. Save the pivot layout separately to reuse with the same CSV structure.
COMMON QUESTIONS
Frequently asked questions
Is my CSV uploaded to PixelOkay?
No. This tool reads and analyzes data in a browser worker on your device. It does not make network requests to upload your file. Your browser may still request the web page assets from your hosting provider.
Can I create a pivot with more than one row, column or value?
Yes. Add up to five row fields, three column fields, and five measures. You can calculate sum, count, average, min, max and distinct counts, or show supported metrics as percentages of the row, column or grand total.
What input formats and limits are supported?
CSV, tab-separated and other delimited UTF-8 text is supported, with automatic delimiter detection. Browser-side safeguards allow files up to 35 MB, 200,000 records and 100 columns. Extremely high-cardinality results may require more selective grouping.
Does it replace Excel pivot tables?
It covers common browser-based summary workflows, including multiple grouping dimensions, filtering and export. It exports static Excel summary sheets, but does not import Excel workbooks, create Excel-native pivot caches, or support calculated fields and every Excel feature.