Log in
Home / DataKit / Data Pivot Table Builder
DataKit

Data Pivot Table Builder

Create configurable summaries from imported CSV/XLSX.

Local processing · No file upload · No API key required

Group rows and optionally split results into columns. Sum, count, average, minimum and maximum are supported. Blank or non-numeric values are excluded from numeric aggregates.

Load your input to preview and configure it. 2 website credits per completed export.

How to use Data Pivot Table Builder

  1. Choose your input, then load and inspect the preview.
  2. Configure the fields and options for your output.
  3. Create the result, review it and download a new file. Your original is unchanged.

Privacy and limits

Files and passwords stay on this device. File contents are not sent to AllNewTools. Account and credit requests do not contain your dataset. XLSX files are supported; save legacy XLS workbooks as XLSX first. Workbook formulas are never executed or recalculated, and data exports do not preserve workbook styling, macros, charts or images. Large inputs are bounded to protect browser memory.

CSV contains values only and has no cell types or formatting. Protect formula-like text before opening untrusted CSV in spreadsheet software. Use XLSX when identifiers must remain text.

All DataKit tools · Open-source engines · Privacy policy