About the CSV Pivot Table
Pivot tables answer questions like “revenue by region and product” in seconds. Paste or open a CSV, pick the column for rows, an optional column to split across, the value to summarise and how — sum, count, average, minimum, maximum or distinct count. Row and column totals and a grand total are added automatically, and a heat-map shading makes the biggest numbers stand out.
Numbers written with commas or currency symbols are understood. Download the pivot as a CSV to paste into a report. Your data never leaves your browser.
How to use the CSV Pivot Table
- Paste or open a CSV.
- Choose rows, columns, value and summary.
- Read the table or download it as CSV.
Features
- Six summary functions
- Row and column totals
- Heat-map shading
- Handles currency and commas
- CSV export
Supported formats
- Plain text
Frequently asked questions
Can I filter rows first?
Use our CSV Filter Rows tool, then paste the result here.
Is my text sent anywhere?
No. Everything runs in your browser, so nothing you paste is uploaded or stored.
Added · Last reviewed · Maintained by Sohail Khax · How we test tools