Add Calculated Column to NDJSON Files Online
Add a new column to NDJSON files computed from an arithmetic expression over existing columns. No formulas, no code — just point and click.
How to add Calculated Column to NDJSON files
- Drop your file onto the upload area. It is loaded into the in-browser engine and the first 200 rows are shown.
- Type a name for the new column. The default is "calculated".
- Build the expression. Pick a column or "constant" on the left, choose an operator (+, −, ×, ÷ or %), then pick a column or constant on the right. The two sides start on the first and second columns of the file.
- Click Calculate. The new column is added as the last column and the preview updates.
- Download the result in the same format you uploaded.
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
A hardware shop exports its stock count and wants the value of stock on the shelf for each product line: units counted multiplied by unit cost. One line was not counted this week.
Input (NDJSON)
{"sku":"HW-101","item":"Wood screws 4x40 (box)","units":38,"unit_cost":4.25}
{"sku":"HW-102","item":"Brass hinge pair","units":12,"unit_cost":7.5}
{"sku":"HW-103","item":"Wall plugs (100)","units":0,"unit_cost":2.75}
{"sku":"HW-104","item":"Masking tape 24mm","units":null,"unit_cost":3.25}
{"sku":"HW-105","item":"Sandpaper P120 (10)","units":25,"unit_cost":5.75}Settings
- New column name: stock_value
- Expression: units × unit_cost
Result
| sku | item | units | unit_cost | stock_value |
|---|---|---|---|---|
| HW-101 | Wood screws 4x40 (box) | 38 | 4.25 | 161.5 |
| HW-102 | Brass hinge pair | 12 | 7.5 | 90 |
| HW-103 | Wall plugs (100) | 0 | 2.75 | 0 |
| HW-104 | Masking tape 24mm | NULL | 3.25 | NULL |
| HW-105 | Sandpaper P120 (10) | 25 | 5.75 | 143.75 |
Each row multiplies its own units by its own unit_cost, and the result is appended as stock_value. Wall plugs have a real count of 0, so their value is 0. Masking tape has no count at all, so its value is NULL, not 0: any arithmetic with a NULL operand gives NULL. Run Fill Empty Values first if a blank count should be treated as zero.
Frequently Asked Questions
Can I use more than two operands or brackets in one expression?
No. Each run applies one operator to two operands, which can be columns or constants. Every run starts from the file you uploaded, so to chain steps, download the result, drop it back in and calculate again. For longer formulas, use the SQL Query tool.
What happens if I divide by zero?
The calculation does not stop. Rows where the divisor is zero get an empty (NULL) result, for both ÷ and %, whatever the column types. Every format writes it the same way, as an empty value.
How does the % operator work?
It is modulo, the remainder after division, not percent. 17 % 5 gives 2, and the sign follows the left operand, so -5 % 3 gives -2. To get a percentage, divide one column by another, then multiply the result by the constant 100 in a second run.
Related Tools
Round Numbers in CSV Files Online
Round numeric columns in CSV files to any number of decimal places directly in your browser. Set precision per column with a simple slider — no upload required.
Add Conditional Column to CSV Files Online
Add a new column to CSV files based on an if/else condition directly in your browser. Set a value for rows that match and a different value for rows that don't — no upload required.
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.
Add Calculated Column to CSV Files Online
Add a new column to CSV files computed from an arithmetic expression over existing columns. No formulas, no code — just point and click.
Add Calculated Column to Excel Files Online
Add a new column to Excel files computed from an arithmetic expression over existing columns. No formulas, no code — just point and click.
Add Calculated Column to Parquet Files Online
Add a new column to Parquet files computed from an arithmetic expression over existing columns. No formulas, no code — just point and click.
Add Calculated Column to JSON Files Online
Add a new column to JSON files computed from an arithmetic expression over existing columns. No formulas, no code — just point and click.
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.