Free online tool

Aggregate or pivot online - Spreadsheets

Groups and calculates values. Process XLS, XLSX, ODS 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.

Drop your files here or click to select them from your device Select files Accepted formats: XLS, XLSX, ODS Up to 1 file, 20 MB per file

How to configure the result

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

Sheets

Specifies pages, sheets, slides, rows or columns affected by the action.

Group columns

Specifies pages, sheets, slides, rows or columns affected by the action.

Value column

Specifies pages, sheets, slides, rows or columns affected by the action.

Aggregate function

Specifies pages, sheets, slides, rows or columns affected by the action.

Pivot column

Specifies pages, sheets, slides, rows or columns affected by the action.

Private, temporary processingFiles are deleted automatically after 60 minutes.

Spreadsheets

What Aggregate or pivot does

Groups and calculates values. 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: XLS, XLSX, ODS
Results: XLSX
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 XLS, XLSX, ODS and can produce XLSX. The selector rejects incompatible extensions before processing.

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