Papiral
PixelForge
Tabular
TabularPivot CSV Data — Reshape Long to Wide Format
Reshape long-format CSV data into a wide pivot table. Turn category values into column headers.
What this tool does
Long-format data (one row per observation) is great for databases but awkward for reports. Tabular's pivot tool reshapes it: pick the row key column, the column whose values will become headers, and the column that holds the values to fill in. The result is a wide-format table — the same structure you'd create with a pivot table in Excel or Google Sheets, without leaving your browser.
Problems it solves
- Reshaping monthly sales data from one row per month to one row per product
- Converting survey responses from long to wide for analysis
- Turning database export rows into a crosstab report
- Preparing data for charting tools that expect wide format
- Aggregating time-series data by category into a matrix
Example
Long-format sales data pivoted to one row per person with months as columns.
Before
| Name | Month | Sales |
| Alice | Jan | 100 |
| Alice | Feb | 200 |
| Bob | Jan | 150 |
| Bob | Feb | 120 |
After
| Name | Jan | Feb |
| Alice | 100 | 200 |
| Bob | 150 | 120 |
Frequently asked questions
What happens when there are duplicate index + pivot combinations?
The first value encountered wins. Tabular doesn't aggregate (sum, average, etc.) — it uses the first matching value for each cell.
What is the difference between the row key, pivot, and value columns?
Row key: the column that identifies each output row (e.g. 'Name'). Pivot: the column whose distinct values become new column headers (e.g. 'Month'). Value: the column whose data fills the cells (e.g. 'Sales').
Is this a Pro feature?
Yes. Pivot Table is available on Pro and Business plans.
Can I unpivot (melt) wide data back to long format?
Not yet — unpivot (melt) is planned as a future feature.
Related tools
Sort Rows
Sort your CSV or Excel file by any column — alphabetically or numerically, ascending or descending.
Filter Rows
ProKeep only the rows that match your criteria — filter by column value, text match, or emptiness. No formulas needed.
Select Columns
ProChoose exactly which columns to keep and drop the rest. Simpler than reordering when you just need to cut columns.