Skip to content
dotXLSOpen Workspace

Unpivot Data

Convert wide spreadsheet columns into normalized attribute and value rows for easier analysis and reporting.

Choose identifier columns and columns to unpivot, preview the normalized rows, then create a separate Unpivot worksheet while keeping the source unchanged.

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 Unpivot worksheet.

Unpivot Data
Identifier column(s) to keep

Load spreadsheet data to choose identifier columns.

Columns to unpivot

Load spreadsheet data to choose columns to unpivot.

Each selected unpivot column becomes an Attribute/Value row for every source record. Identifier columns are repeated to keep each record recognizable.

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.