Free online tool

Aggregate or pivot online - Data

Groups rows, calculates values and optionally creates pivot columns. Process CSV, TSV, JSON, XML online and download the result without changing the original.

You have used 0 of 5 free transformations Free transformations remaining: 5
The allowance renews 24 hours after the period begins.

You have used your five free transformations

Create a free account or sign in to keep processing files without waiting for the allowance to renew.

Create free accountSign in
Drop your files here or click to select them from your device Select files Accepted formats: CSV, TSV, JSON, XML Up to 1 file, 20 MB per file

Selected files

0

How to configure the result

Each option controls a specific part of processing. Keep defaults when you do not need to control that aspect.

Choose the generated file format. Only targets compatible with the input are listed.
Specifies pages, sheets, slides, rows or columns affected by the action.
Specifies pages, sheets, slides, rows or columns affected by the action.
Configure Aggregate function. Keep the default when this property does not need customization.
Specifies pages, sheets, slides, rows or columns affected by the action.
Controls how input encoding, structure or schema is interpreted.
Controls how input encoding, structure or schema is interpreted.
Specifies pages, sheets, slides, rows or columns affected by the action.
Enable Format the output only when this behavior should be applied to the result.
Private, temporary processingFiles are deleted automatically after 60 minutes.

Your files are ready

Download the result before the retention period ends.

Save to my Cloud
Data

What Aggregate or pivot does

Groups rows, calculates values and optionally creates pivot columns. The tool validates the selected files and applies only the requested operation and settings. The tool changes selected properties without requiring a full manual edit.

Compatibility and limits

Input formats
CSV, TSV, JSON, XML
Results
CSV, TSV, JSON, XML, XLSX, ODS
Number of files
Minimum 1, maximum 1
Maximum total size
24 MB
FAQ

Frequently asked questions

Defaults provide a balanced result. Change only properties you need to control.

Input supports CSV, TSV, JSON, XML and can produce CSV, TSV, JSON, XML, XLSX, ODS. The selector rejects incompatible extensions before processing.

No. A new result is created and the uploaded file remains unchanged during temporary processing.
Tools

Related tools

Convert data
Select or remove columns
Sort and filter data
Clean data

You can also convert

CSVXLSXJSONCSVCSVJSONXMLJSON