Fill Empty Values in CSV Files Online
Fill empty and null values in CSV files with a custom replacement value, directly in your browser.
About this tool
Replace null and empty values in a CSV file with a custom placeholder. Set different fill values for text and numeric columns. Essential before loading data into tools that do not handle nulls well.
Frequently Asked Questions
What counts as a null or empty value in a CSV file?
SQL NULL values and empty strings are both treated as missing and will be filled. Values that are whitespace only are not automatically treated as null — use the Trim tool first if needed.
Can I fill numeric and text columns with different values in a CSV file?
Yes. Set a text fill value for string columns and optionally a separate numeric fill value for number columns. Enable the "Also fill numeric nulls" option to apply both.
What if I only want to fill nulls in specific columns of a CSV file?
This tool fills all eligible columns. For column-level control, use the SQL Query tool and write SELECT COALESCE("col", 'replacement') AS "col" for each column you want to fill.
Is my data private?
Yes — completely. Your file is never uploaded to any server. Everything runs locally in your browser using WebAssembly — processing happens entirely inside your tab. Once you close the tab, nothing is retained.
What is the maximum file size?
The free limit is 50 MB. For larger files, performance depends on your device's available memory — most modern machines handle 500 MB to 1 GB comfortably.
Related Tools
Validate Email Addresses in CSV Files Online
Validate email addresses in CSV files directly in your browser. Add a boolean column flagging valid and invalid emails, or filter to show only invalid rows — no upload required.
Add Moving Average to CSV Files Online
Add a moving average, rolling sum, rolling min, or rolling max column to CSV files directly in your browser. Choose window size, order-by column, and optional partitioning — no upload required.
Search Text in CSV Files Online
Search for text across all string columns in CSV files directly in your browser. Filter rows to only those containing your search term and download the results — no upload required.
Get Top N Rows from CSV Files Online
Extract the top N rows per group from CSV files directly in your browser. Get the top 5 products per category, highest scores per team, or any ranked subset — no upload required.
Add Percent of Total to CSV Files Online
Add a percentage-of-total column to CSV files directly in your browser. Show each row's share of the grand total, or the share within each group — no upload required.