Unpivot a CSV table
Keep the ID columns you choose, and each selected value column becomes a variable/value record.
- Runs in your browser
- No upload
- Check before download
Files and cell values stay in this tab. Nothing is uploaded or saved. Closing or clearing the tab loses the inputs.
Keep the ID columns you choose, and each selected value column becomes a variable/value record. ID and value columns must not overlap. Keep empty cells, or skip them and see the count. You name both new columns.
UTF-8 only; BOM accepted. Cells and keys remain exact strings: 001 differs from 1. An empty cell is empty text, not inferred null; literal NULL stays text. Headers must be unique and nonempty. Quoted newlines are preserved. Formula-like cells remain unchanged; spreadsheets may execute them on opening.
First record is a header
Transforms: 8 files, 16 MiB per file and 32 MiB in total, 200,000 records, 128 columns, and 1,000,000 input or output cells. Split: 64 MiB, 1,000,000 records and 500 parts. A field can have up to 262,144 UTF-16 units and a record up to 1,048,576 characters. Output up to 128 MiB; the worker stops after 60 seconds. The ZIP bytes stay in memory, so this is not an unlimited disk stream.
Inspect the selected sources before choosing columns.
How to use it
- Choose files and delimiters
UTF-8 only; BOM accepted. Cells and keys remain exact strings: 001 differs from 1. An empty cell is empty text, not inferred null; literal NULL stays text. Headers must be unique and nonempty. Quoted newlines are preserved. Formula-like cells remain unchanged; spreadsheets may execute them on opening.
- Inspect and configure columns
Keep the ID columns you choose, and each selected value column becomes a variable/value record. ID and value columns must not overlap. Keep empty cells, or skip them and see the count. You name both new columns.
- Create and verify the native download
Preview: first 20 output records. Files and cell values stay in this tab. Nothing is uploaded or saved. Closing or clearing the tab loses the inputs.
Before exporting
CSV files
Files and cell values stay in this tab. Nothing is uploaded or saved. Closing or clearing the tab loses the inputs.
Empty-cell policy
UTF-8 only; BOM accepted. Cells and keys remain exact strings: 001 differs from 1. An empty cell is empty text, not inferred null; literal NULL stays text. Headers must be unique and nonempty. Quoted newlines are preserved. Formula-like cells remain unchanged; spreadsheets may execute them on opening.
Output
Transforms: 8 files, 16 MiB per file and 32 MiB in total, 200,000 records, 128 columns, and 1,000,000 input or output cells. Split: 64 MiB, 1,000,000 records and 500 parts. A field can have up to 262,144 UTF-16 units and a record up to 1,048,576 characters. Output up to 128 MiB; the worker stops after 60 seconds. The ZIP bytes stay in memory, so this is not an unlimited disk stream.