Data & CSV

Fill empty CSV cells

Replace empty values across a table or in one column.

Your inputs

Your CSV data

UTF-8 CSV/TSV stays on this device. First row contains unique headings; maximum 25 MB, 50,000 rows and 200 columns. Fully empty rows are ignored.

Up to 25 MB per file, 50,000 data rows, 200 columns and 2 million data cells. Fully blank rows and columns are ignored before row, column and cell limits are checked. Individual tools may have smaller result or chart limits.

Or choose a CSV file

Column separator

Apply to

Column

Treat as missing

Replacement text

Results update as you type. Larger files run when you press Update result.

Processed on your device

Your result

LOCAL & PRIVATE

Your result will appear here.

Your inputs stay in this browser. Nothing is uploaded or saved.

A clear answer. Here’s how.

Replaces missing cells under your chosen exact-empty or whitespace-only rule. Applies to all columns or one selected column, without modifying headings. Literal strings such as NULL, NA and 0 are retained unless they meet that rule. Cell content remains text; export protects potential spreadsheet formulas.

See a worked example

Worked example

A fixed demonstration, separate from the values you enter above.

Your CSV data

ID,Name,Department,Amount,Date
001,Ada,Design,120,2026-01-05
002,Sam,Writing,80,2026-01-06
003,Jo,Design,150,2026-01-07
004,Lee,Writing,,2026-01-08
005,Alex,Design,60,2026-01-09

Column separator

Comma

Apply to

All columns

Treat as missing

Exactly empty cells

Replacement text

Not supplied

Example result

Example result
ID	Name	Department	Amount	Date
001	Ada	Design	120	2026-01-05
002	Sam	Writing	80	2026-01-06
003	Jo	Design	150	2026-01-07
004	Lee	Writing	Not supplied	2026-01-08
005	Alex	Design	60	2026-01-09

1 cells filled.