Skip to content
dotXLSOpen Workspace

Pivot Data

Convert long spreadsheet rows into a wide pivot table for easier analysis and reporting.

Paste Data

Copy cells from Excel or Google Sheets and paste them here.

Import a spreadsheet file

Import CSV or XLSX data into the current dotXLS workspace. Files are processed in your browser.

Tools

The first row supplies column names. Your source worksheet remains unchanged; Apply creates a separate Pivot worksheet.

Pivot Data
Row identifier column(s)

Load spreadsheet data to choose identifier columns.

Distinct values in the pivot column become new worksheet columns. When more than one source row maps to the same output cell, the selected calculation is used.

Undo and Redo controls are available with the current grid.

Paste spreadsheet data to create your workspace.

Name	Department	Amount
Ahmed	Sales	1200
Maria	HR	950

Your data stays in this browser tab and is not sent to WordPress.

Export result

Download the current workspace data after editing or cleaning.