Fill Empty Values in NDJSON Files Online
Fill empty and null values in NDJSON files with a custom replacement value, directly in your browser.
How to fill Empty Values in NDJSON files
- Drop your file onto the upload area. The tool counts the NULL values in every column and lists each column that has any, marked as numeric, text, or another type that is left as is.
- Type the replacement for text columns in Fill text nulls with. It starts empty, which fills with an empty string.
- To fill number columns too, tick Also fill numeric nulls and set the Numeric fill value. The default is 0.
- Click Fill Empty Values and check the preview.
- Click Download to save the filled file 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 library exports its loan records for a monthly report. Missing renewal counts mean the loan was never renewed, and missing notes should read "none" rather than appearing blank.
Input (NDJSON)
{"branch":"Central","title":"The Overstory","renewals":2,"notes":"damaged cover"}
{"branch":"Eastside","title":"Piranesi","renewals":null,"notes":null}
{"branch":"Central","title":"Klara and the Sun","renewals":0,"notes":null}
{"branch":"Northgate","title":null,"renewals":1,"notes":"reserved"}Settings
- Fill text nulls with: none
- Also fill numeric nulls: ticked
- Numeric fill value: 0
Result
| branch | title | renewals | notes |
|---|---|---|---|
| Central | The Overstory | 2 | damaged cover |
| Eastside | Piranesi | 0 | none |
| Central | Klara and the Sun | 0 | none |
| Northgate | none | 1 | reserved |
Two notes and one renewal count were NULL, and they are now "none" and 0. The missing title is also "none": the text fill value applies to every text column that has NULLs, not only notes. Values that were already present, including the real 0 renewals for Klara and the Sun, are unchanged.
Frequently Asked Questions
Are empty strings treated as missing?
No. Only NULL values are counted and filled. In CSV and Excel files, blank cells load as NULL, so they are filled. In Parquet and JSON, an empty string is a real value and is left alone.
Can I use a different fill value for each column?
No. There is one value for all text columns and one optional value for all numeric columns. Date, boolean and nested columns are not filled. For per-column values, use the SQL Query tool with COALESCE, or Coalesce Columns to fill from another column.
Are numeric columns filled by default?
No. Numeric NULLs stay NULL unless you tick Also fill numeric nulls. That is deliberate, because filling with 0 changes sums, averages and counts.
Related Tools
Validate CSV Files Online
Validate CSV file structure in your browser. Check null counts, distinct values, and data types for every column — 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.
Coalesce Columns in CSV Files Online
Fill null values in CSV files from other columns — return the first non-null value across up to 8 columns in priority order. Add the result as a new column. Runs entirely in your browser.
Fill Empty Values in CSV Files Online
Fill empty and null values in CSV files with a custom replacement value, directly in your browser.
Fill Empty Values in Excel Files Online
Fill empty and null values in Excel files with a custom replacement value, directly in your browser.
Fill Empty Values in Parquet Files Online
Fill empty and null values in Parquet files with a custom replacement value, directly in your browser.
Fill Empty Values in JSON Files Online
Fill empty and null values in JSON files with a custom replacement value, directly in your browser.
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.