Unpivot CSV to long format
Unpivot wide CSV or TSV data into a tidy long-format table while repeating chosen identifier columns beside each field name and value.
Your results
Unpivot CSV to long format
Need to turn monthly columns, survey questions or other wide CSV data into a long table for charts or analysis? Upload a UTF-8 CSV, identify the columns that should stay on each row, and let the other headers become values in a new field column. For example, Product, Region, January and February become Product, Region, field and value rows. Keep or skip blank source values explicitly. Check the first output rows in the preview, then download a spreadsheet-safe CSV. The transformation copies text; it does not calculate or infer data types.
How to use this tool
- Export your wide spreadsheet as UTF-8 CSV or TSV. Upload or drag the file in, import a direct public URL, or paste a short table after the or separator. Try the monthly sales example.
- Choose the separator and type the exact identifier headers, separated by commas. These columns repeat for each unpivoted field. Choose whether blank values remain or are skipped.
- Create the long-format CSV, review the preview and download it. Every remaining source column becomes a field/value row in original order.
Supported input formats
CSVTSVTXT
Available settings
- Column separator
- Identifier columns (comma-separated headers)
- Field column name
- Value column name
- Blank values
Output and limitations
Unpivot wide CSV or TSV data into a tidy long-format table while repeating chosen identifier columns beside each field name and value.
Upload or drag in one UTF-8 CSV or TSV up to 5 MB, import a direct public file URL, or paste a short table after the or separator. Enter one to twenty identifier column headers separated by commas; these columns stay alongside every output row. All other columns become field and value rows in original order. Choose whether empty values remain as blank rows or are skipped. Output values stay text, including leading zeros, and spreadsheet formula-like cells are escaped. The tool does not calculate totals, infer dates or combine repeated records. Limits: 10,000 input rows, 100 columns, 100,000 output rows and 20 MB CSV. CSV headers containing commas cannot be chosen as identifiers in this version. Export XLSX sheets as UTF-8 CSV first and review the preview before using the result.
What happens to empty month or survey cells?
Choose Keep to write a row with an empty value or Skip to omit only empty or whitespace-only values. A zero is not blank and stays in the output. The report never fills missing values or assumes an empty cell means zero.
Will unpivoting calculate totals or change dates and numbers?
No. It copies source text into rows. Zeroes, quoted values and empty cells remain distinct. If you open the CSV directly in Excel, Excel may infer types; use the CSV-to-Excel text converter when exact identifiers must stay text.
What if processing fails?
Check the supported formats and file limits, then try a smaller file. Keep an original copy. A clear error message will explain an unsupported input or an unavailable processing service.