Fill Blank Cells in Excel Online — Free, No Upload, 1 Click
Fill empty cells down, up, with text or zeros. No upload, no sign-up — your file stays on your device.
Drop one .xlsx, .xlsm, or .xls file here, or click to browse
Supports .xlsx / .xlsm / .xls · processed locally · never uploaded
How to Fill Blank Cells in Excel Online
- Drop one .xlsx, .xlsm, or .xls workbook — everything is processed locally and never uploaded.
- Pick a fill mode: fill down (the default), fill up, custom text, or zero.
- Choose whether cells containing only spaces count as blank, and whether the first row is a header (both are on by default).
- Click Fill blank cells — every sheet is processed column by column and counted.
- Check the per-sheet report and download the result as your-file-name-filled.xlsx.
How It Works
SheetJS parses the OOXML package of the workbook directly in your browser into an in-memory array-of-arrays model — one sheet, one cell grid at a time. The tool then walks each worksheet column by column, decides which cells count as blank (honoring your choices for whitespace-only cells and a header row), and applies the chosen fill strategy: copy the nearest non-empty value from above (fill down), from below (fill up), overwrite with your custom text, or write a zero. Every sheet is counted as it is filled. The model is then serialized back into a fresh .xlsx blob and handed to you as a download — a value-level rebuild, so formulas land as their last cached values and advanced styling is simplified. The whole round-trip runs locally in JavaScript; no byte ever leaves your device.
Your file never leaves your device — processing is 100% in-browser.
Compared to Excel’s Go To Special → Blanks
The built-in Excel path is: select a range → F5 / Go To Special → Blanks → type a value → press Ctrl+Enter to fill them all at once. This tool collapses that workflow to a single click and processes every sheet of the workbook in one pass.
| Approach | Where your file goes | What to expect |
|---|---|---|
| This tool | Nowhere — processed in your browser | Free, no sign-up, no size cap, batch-friendly |
| Excel Go To Special → Blanks | Stays on your disk | Manual multi-step, one file at a time, no batch |
Four Ways to Fill Blank Cells
| Mode | What it does | Best for |
|---|---|---|
| Fill down | Copies the nearest non-empty value above into each empty run, column by column. | Category or label columns where one heading applies to several rows below it. |
| Fill up | Copies the nearest non-empty value below into empty cells above it. | Totals placed at the bottom of a group, or exports where labels sit under their data. |
| Custom text | Replaces every blank cell with the text you type, such as “N/A” or “Unknown”. | Marking missing values before import into a database or BI tool. |
| Zero | Writes the number 0 into every blank cell. | Numeric tables used in formulas or pivot tables where empty cells must count as zero. |
What Counts as a Blank Cell
By default a cell is blank only when it is truly empty (null or an empty string). Turn on “Treat cells with only spaces as blank” to also replace cells that contain nothing but spaces, non-breaking spaces, or full-width spaces — the old whitespace is replaced wholesale, not merged with the new value.
With “First row is a header” enabled, the header row is never filled and its text is never used as a fill source: a column starts each fill run from its first data row, so a header like “Region” never spills into blank data cells.
Fill down never invents values: an empty run at the top of a column (with no value above it) is left untouched, and unrelated groups are never guessed across. The output is a value-level .xlsx rebuilt from your data — formulas land as their last cached values, and cell styles, merged cells, and charts are simplified. Use the online editor if formatting must be preserved.
Common Uses
- Completing a category column after opening a report built with merged cells — only the first row of each merged label kept its text.
- Flattening grouped or pivoted exports where headings appear once per block instead of on every row.
- Writing zeros into empty numeric cells so SUMIFS, pivot tables, and charts treat missing readings as 0.
- Adding a consistent placeholder such as “N/A” so a database import or mail merge no longer sees empty fields.
Limitations
- Filling always runs column by column across the whole sheet — filling a rectangular selection only is not supported here; use the online editor for that.
- Styles, formulas, merged cells, and charts are simplified in the output file.
- Encrypted workbooks (a password is required to open) cannot be read.
- Legacy .xls files are supported, but are converted to .xlsx on output.
Frequently Asked Questions
Is this blank-cell filler really free?
Yes — 100% free, with no sign-up, no watermark, and no file limit. All processing happens in your browser.
What does “fill down” do?
It scans each column top to bottom and copies the nearest value above into every consecutive empty cell. When a new value appears, it becomes the source for the following blanks. The first run of blanks in a column, with nothing above it, stays empty.
What about cells that contain only spaces?
They are kept by default. Enable “Treat cells with only spaces as blank” to also fill regular spaces, non-breaking spaces, and full-width spaces; the entire old cell content is replaced.
Will my header row be filled?
No. With “First row is a header” enabled (the default), the first row is never filled and is never used as a fill source for data rows.
Does fill down guess values across groups?
No. Only the nearest non-empty value in the same column is copied. Blank runs with no value above (fill down) or below (fill up) are left exactly as they were.
What happens to formulas and formatting?
The output is rebuilt from cell values: formulas are written as their last cached values, and styles, column widths, merged cells, and charts are simplified. Use the online editor when formatting must be preserved.
Is my file uploaded to a server?
No. The workbook is parsed, filled, and rebuilt entirely in your browser with JavaScript. Your file never leaves your device.
Which formats are supported?
.xlsx, .xlsm, and legacy .xls. The result is always downloaded as a modern .xlsx file.
Related Tools
Need the full reference? Read IFERROR in Excel: Syntax, Examples and Errors — syntax, examples, common errors, and FAQ.
Need to fill only a selected range or keep your formatting intact?
Open the free online Excel editor