How to use Dataset Unpivot Tool
- Paste the wide CSV/TSV table or choose a CSV, TSV or XLSX file. Select the workbook worksheet if needed and check headers and delimiter.
- List the identifier columns to repeat, such as region and year.
- List the value columns to turn into rows, or leave that list empty to use every non-identifier column.
- Name the new attribute and value columns, choose whether empty values should be omitted, then unpivot and review the long-table preview before downloading.
Example: Dataset Unpivot Tool
Turn monthly figures into one row per region and month.
Options
- CSV or TSV text
- Paste the wide table, or leave this empty and choose a file. Values are kept exactly as they appear in the text.
- Worksheet name or number
- Choose the worksheet used for wide-to-long conversion. An empty choice uses the first visible sheet; otherwise enter its name or 1-based position.
- The first row holds the column names
- For wide-to-long conversion, enable this when the first record names the columns. Without headings, refer to columns by their 1-based positions.
- Identifier columns
- The columns to repeat on every output row, such as region,year. Leave empty to unpivot the whole table.
- Value columns
- The columns to turn into rows, such as jan,feb,mar. Leave empty to use every column that is not an identifier.
- Name column heading
- This column holds the heading of the source column each value came from.
- Leave out empty value cells
- A blank cell becomes no output row instead of a row holding an empty value. Turn this off to keep one row per field.
- Protect spreadsheet formulas in the download
- The wide-to-long conversion CSV export can prefix formula-like source text, including after leading whitespace. This changes stored text. An XLSX export, when offered, uses inert text cells without the CSV prefix.
Supported inputs and limits
- CSV/TSV/XLSX input up to 20 MiB, 100,000 source rows, 500 columns and 2,000,000 cells.
- Source rows multiplied by selected value columns must not exceed 100,000 expanded rows.
- Expanded rows multiplied by the full output column count (retained identifiers plus the two new columns) must not exceed 2,000,000 cells.
- This preflight applies even when empty values will later be omitted.
- A selected file replaces pasted text.
More details
Identifier and new-column names must not collide.
CSV formula protection can prefix risky text; grouping and aggregation belong to Pivot Table Builder.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Reading a long table next to the wide one
When months are separate column headings, grouping or filtering by month can require repeated work across those columns. A long table puts the month in one attribute column and its measurement in one value column. The identifier columns repeat on each row, so review both the expanded row count and the identifiers before using the result for a pivot or chart.
Questions about Dataset Unpivot Tool
What does unpivoting actually change?
Each value column becomes a row of its own. The identifier values are copied onto that row, the source heading is written into the name column, and the cell itself goes into the value column.
Why is one region missing from my result?
The default leaves out rows whose value cell is blank. Turn off Leave out empty value cells and that region appears again with an empty value.
Which order do the rows come in?
Source rows keep their order. Explicit value columns follow the order you list them; when the list is empty, the remaining columns follow source-table order.
Does my table leave my computer?
It does not. The rows are read and reshaped inside this page, and the CSV you download is created from that same data on your device.