Transpose & Pivot
Flip rows and columns, or build a quick pivot table that groups and summarises your data.
Everything runs in your browser — your file never leaves your device.
Tip: pivot groups identical values in the “group by” column and summarises the values column for each group.
About Transpose & Pivot
Transpose & Pivot is a free online tool that reshapes a spreadsheet without formulas or macros. In transpose mode it swaps rows and columns, so the first column becomes the first row — handy when data arrives sideways from an export. In pivot mode it groups rows by a column and summarizes another, giving you a quick pivot table in seconds.
The pivot builder lets you pick a group-by column, an optional column to split values across, a values column and an aggregation — sum, count, average, min or max. It reads XLSX, XLS, CSV, TSV and ODS files, respects an optional header row, and exports the reshaped result as Excel or CSV.
Everything runs on the self-hosted SheetJS engine inside your browser. The file is parsed locally, the transpose or pivot is computed locally, and the download is generated locally — your data never touches the server, which makes the tool safe for financial or customer spreadsheets.
How to use Transpose & Pivot
- Drop a spreadsheet on the upload area, click Choose file, or load the sample (XLSX, XLS, CSV, TSV or ODS).
- Toggle "First row is a header" to match your data.
- Pick a mode: Transpose to swap rows and columns, or Pivot to group and summarize.
- In pivot mode, choose the group-by column, an optional split column, the values column and an aggregation (sum, count, average, min or max).
- Review the result preview, select Excel (.xlsx) or CSV as the output format, and click Download.