Fill Empty Values in Excel Files Online
Fill empty and null values in Excel files with a custom replacement value, directly in your browser.
About this tool
Replace null and empty values in a Excel 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 Excel 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 Excel 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 Excel 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
Count Values in Excel Files Online
Group and count rows by any column in Excel files directly in your browser. Sort by frequency or value to find the most common entries — no upload required.
Extract Unique Values from Excel Files Online
Extract all distinct values from any column in Excel files directly in your browser. Download the unique values list — no upload required.
Compare Excel Files Online
Compare two Excel files directly in your browser. See rows only in file A, only in file B, and rows common to both — no upload required.
Format Timestamps in Excel Files Online
Reformat timestamp and date columns in Excel files directly in your browser. Convert between ISO 8601, Unix epoch, US date, and custom strftime patterns — no upload required.
Find & Replace in Excel Files Online
Find and replace text values in Excel files directly in your browser. Supports plain text and regex patterns across any column — no upload required.