Extracto
Get started
All free tools
Free tool · No signup

CSV Pivot Table

Turn a CSV file into a pivot table. Group rows, split columns and calculate counts, sums, averages, minimums or maximums on your device.

Processed on your device. No upload, account or daily limit.

One CSV or TSV up to 5 MB, 10,000 records and 100 source columns. Up to 200 row groups and 20 column groups. Headings up to 200 characters and group labels up to 500. Numeric inputs support up to 30 integer and 12 fractional digits; averages round to six decimal places. Files stay on your device.

Keep going

Put your data to work.

Explore scrapers for products, business listings, jobs and more.

Explore scrapers

More free tools

Data utilities

Excel to CSV & JSON

Choose a worksheet from an XLSX workbook and export its displayed cell values as CSV or JSON, without uploading your file.

Open tool Data utilities

GeoJSON to CSV

Convert GeoJSON features to CSV with properties, Point coordinates and full geometry JSON. Files stay on your device.

Open tool Data utilities

Compare Text Lists

Compare two lists to find shared values, values unique to either list and a combined deduplicated list.

Open tool Data utilities

XML to CSV Converter

Convert XML records into a table, choose repeating elements and keep attributes. Export CSV or JSON on your device.

Open tool Data utilities

Regex Data Extractor

Extract matching text and capture groups with a regular expression. Try examples and export the matches as CSV or JSON.

Open tool Data utilities

CSV Data Profiler

Inspect empty cells, duplicate rows, unique values and frequent values in a CSV file. Download a column-by-column report.

Open tool