Fill Blank Cells in Excel
Fill empty cells with values from above, below, or custom text
Drop your file here
or click to browse
Supported: .xlsx,.xls,.xlsm,.xlsb,.csv,.tsv (Max 50 MB)
How It Works
Upload Excel
Drag & drop or browse for your Excel file
Choose Fill Method
Fill from above, below, or enter a custom value
Download
Get your Excel file with all blanks filled
Common Use Cases
Merged Cell Exports
Fix data exported from systems where merged cells leave blanks below
Pivot Table Prep
Fill category labels so pivot tables group data correctly
Replace Missing Values
Fill empty cells with "0", "N/A", or any default value
VLOOKUP Preparation
Ensure lookup columns have no blanks for accurate matching
Frequently Asked Questions
What does "Fill from above" mean?
Fill from above copies the value from the nearest non-empty cell above into each blank cell. This is useful for merged-cell exports where the category appears once and rows below it are empty.
What does "Fill from below" do?
Fill from below works the opposite way - it copies the value from the nearest non-empty cell below into blank cells. Useful when labels appear at the bottom of groups.
Can I fill blanks with a specific value?
Yes! Choose "Custom value" and enter any text or number. Common uses include filling blanks with "N/A", "0", "-", or "Unknown".
Will this affect cells that already have values?
No, only empty/blank cells are filled. Cells with existing values remain unchanged.
Is my data safe?
Absolutely. All processing happens locally in your browser. Your files never leave your device or get uploaded to any server.