Unpivot NDJSON Files Online
Reshape NDJSON files from wide to long format directly in your browser. Melt multiple columns into variable/value pairs — no upload required.
How to unpivot NDJSON files
- Drop your file. The first column is ticked as an ID column by default.
- Tick every column that identifies a row, such as an ID, a name or a region. ID columns are repeated on every output row.
- Leave the columns you want to melt unticked. Each unticked column becomes rows holding its column name and its value.
- Name the two new columns. They default to variable and value.
- Click Unpivot, check the long-format preview, and download the result.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
An HR team runs a two-question pulse survey. The export has one row per respondent and one column per question, but the dashboard tool wants one row per answer. One respondent skipped the second question.
Input (NDJSON)
{"respondent_id":1041,"team":"Support","q1_score":4,"q2_score":5}
{"respondent_id":1042,"team":"Sales","q1_score":2,"q2_score":null}
{"respondent_id":1043,"team":"Support","q1_score":5,"q2_score":4}Settings
- ID columns (ticked): respondent_id, team
- Value columns (unticked): q1_score, q2_score
- Variable column name: question
- Value column name: score
Result
| respondent_id | team | question | score |
|---|---|---|---|
| 1041 | Support | q1_score | 4 |
| 1041 | Support | q2_score | 5 |
| 1042 | Sales | q1_score | 2 |
| 1042 | Sales | q2_score | NULL |
| 1043 | Support | q1_score | 5 |
| 1043 | Support | q2_score | 4 |
Each respondent now has one row per question, with the ID columns repeated. Respondent 1042 skipped question 2, and that row is kept with an empty score. So the result has 6 rows, 3 respondents times 2 questions. Filter out empty scores afterwards if you only want answered questions.
Frequently Asked Questions
Are empty values kept?
Yes. Each input row gives one output row for every value column, even when the value is empty (NULL). Filter the value column afterwards if you want only filled values.
Can I unpivot columns of different types?
Yes. Whole numbers and decimals combine into a number column, and dates and timestamps into timestamps. Any other mix, such as numbers and text, is converted to text so the run still works.
How do I go back from long to wide?
Use the Pivot tool. Put the variable column into the column headers and use the value column for the cells.
Related Tools
Aggregate CSV Files Online
Group and aggregate CSV files by any column directly in your browser. Calculate sum, average, min, max, and count for any numeric column — no upload required.
Count Values in CSV Files Online
Group and count rows by any column in CSV files directly in your browser. Sort by frequency or value to find the most common entries — no upload required.
Filter CSV Files Online
Filter rows in CSV files by column value, directly in your browser. Your data stays on your device.
Unpivot CSV Files Online
Reshape CSV files from wide to long format directly in your browser. Melt multiple columns into variable/value pairs — no upload required.
Unpivot Excel Files Online
Reshape Excel files from wide to long format directly in your browser. Melt multiple columns into variable/value pairs — no upload required.
Unpivot Parquet Files Online
Reshape Parquet files from wide to long format directly in your browser. Melt multiple columns into variable/value pairs — no upload required.
Unpivot JSON Files Online
Reshape JSON files from wide to long format directly in your browser. Melt multiple columns into variable/value pairs — no upload required.
NDJSON Viewer Online
View and inspect NDJSON files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.