CSV Fill Missing Values
Fill empty CSV cells in selected columns, keep contiguous groups separate and download the complete table with a source-free count report.
This tool processes its input contents in your browser instead of sending them to a processing service. Page, asset and fixed usage-measurement requests are described on the Privacy page.
Fill exactly empty selected CSV cells down, up or with a constant, optionally keeping adjacent groups separate.
How to use it
- 1Paste or open a local CSV, then select from the automatically displayed columns.
- 2Choose a direction or constant, and set optional adjacent group keys.
- 3Review changed and still-empty counts, then copy or download the complete CSV.
Example
- Input
- team,owner,item A,Mira,001 A,,002 B,,003 B,Leo,004 B,,005
- Output
- team,owner,item A,Mira,001 A,Mira,002 B,"",003 B,Leo,004 B,Leo,005
Fill owner down and group by team. Two cells change. The first B row remains empty because the preceding A group cannot supply its value.
What happens to your data
The source, carried values and constant stay in the current browser tab. The separate report contains settings and totals without original values or the constant text.
Last updated November 2026
Fill empty cells in selected CSV columns using the nearest supplied value above or below, or a constant you enter. Keep records in their original order, optionally reset the carried value at contiguous group boundaries, and review exactly how many cells changed before downloading.
How it works
An empty cell contains zero characters. A space, zero, NULL and null are ordinary nonempty text and can supply a carried value. Fill down scans from the first row and copies the most recent nonempty value into later empty cells. Fill up scans from the last row and copies the following nonempty value into earlier empty cells. Existing nonempty values are never replaced. Empty cells without a usable source remain empty and are counted separately.
Optional group columns compare their original exact text in adjacent rows. When any selected group key changes, carried values reset. A key that appears again later begins a new segment rather than reaching back across another group. Group matching is case-sensitive and does not trim whitespace. Group columns cannot also be filled. Without group columns, the entire table is one segment. No sorting or global grouping is performed.
Constant fill replaces exactly empty selected cells with your nonempty value, up to 4 KiB of valid Unicode text. Newlines and spaces in that constant are real data and are quoted correctly. A report records that a constant was supplied and its UTF-8 byte length, without including the constant itself. Group settings apply only to fill up or down. Header-only and no-change tables still produce a complete CSV, with an explicit unchanged result.
This is a deliberate data preparation operation, not statistical imputation or a claim that a missing observation equals its neighbor. Choose columns and group boundaries that fit your source. CSV Cell Cleaner changes spaces/case; CSV Value Mapper replaces an exact reviewed dictionary; neither is silently applied by this tool.
Use UTF-8 input up to 500 KiB, 10,000 records including the header, 128 columns and 200,000 cells. Choose comma, semicolon or tab explicitly. Headers must be nonempty and unique, and each record must have the same number of fields. Invalid quotes, unequal widths or an excessive complete output stop the job; no partial CSV is presented as a completed result. Output is limited to 2 MiB and retains the row and column counts. It uses UTF-8 without a BOM and CRLF record endings; logical quoted cell values stay intact even when quoting changes.
The page shows the first eight changed cells and a shortened output preview. Copy and download contain the complete result. The separate JSON report includes column indexes, settings and totals without source cell values, headings or filenames. Edits clear previous exports. Formula-like text is counted and preserved, without an automatic apostrophe or replacement. Spreadsheet applications may evaluate it or reinterpret identifiers; review the file and import affected columns as text. Processing stays in this tab, with no source upload or saved input history.
Worked example: Fill within adjacent team groups
- Input
- team,owner,item A,Mira,001 A,,002 B,,003 B,Leo,004 B,,005
- Result
- team,owner,item A,Mira,001 A,Mira,002 B,"",003 B,Leo,004 B,Leo,005
Fill owner down and group by team. Two cells change. The first B row remains empty because the preceding A group cannot supply its value.
Common use cases
- Carry parent labels down through a report exported with blank repeated labels.
- Fill later empty dates within a deliberately selected adjacent group.
- Fill earlier rows from the next supplied value without sorting the table.
- Apply an explicit placeholder to empty selected fields while retaining whitespace and literal NULL values.
Frequently asked questions
Does this fill cells containing spaces or NULL?+
No. Only exactly empty strings are missing. Spaces, zero, NULL and null remain values and can supply a carried value.
Can a value cross a customer or team boundary?+
Choose group columns to reset at each adjacent change. With no group columns, the whole table is one segment. Group columns cannot also be filled.
What if the same group key appears later?+
It starts a new segment after any intervening key change. The tool does not search or sort all rows into global groups.
Will every blank be filled?+
Not always. A leading blank in fill-down mode, a trailing blank in fill-up mode or a group with no source value remains empty and is counted.
Related tools
CSV Schema Validator
Validate CSV against an explicit Table Schema subset: exact columns, logical types, required values, bounds, uniqueness and primary keys, without changing cells.
CSV Cell Splitter
Split one CSV column by a literal separator, retain text identifiers and choose rows or numbered columns with reviewed exports.
Fixed Width to CSV
Convert a fixed-width text report to CSV with explicit field widths, named columns, optional trimming and clear record-length errors.
CSV Cell Cleaner
Clean whitespace and letter case in selected CSV columns, preserve text IDs and review exact change counts locally.