CSV fill down blank cells: copy the value above into the empty cells below it
In short: Upload a list that names a company or a group once and leaves the rows under it blank. Choose the columns and every blank is filled from the cell above. Limit: It copies the value above and cannot tell which blanks are really missing data.
Upload a CSV or .xlsx file, or paste it with a header row. Tick the columns to fill. Each blank cell takes the nearest value above it in the same column, the way Fill Down works in Excel. Blanks at the top, with nothing above, stay empty, and rows that are blank everywhere are left alone.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. Check your list free nowSee pricing
Sample result
Five example rows get 3 blank Company cells filled from the value above: Acme twice and Globex once.
- Cells filled
- 3
- Column
- Company
- Blanks at the top
- 0
What this means for you
Filled cells are not working mailboxes; a check shows which addresses exist.
- Several columns at once
- Existing values kept
- Top blanks left alone
- Empty rows skipped
- Fill down
- CSV
- Blanks
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Filled the blanks? Check the addresses before the send.
- Download the filled file, or use the check button under the result, which carries its addresses across.
- Upload or paste it at /verify. Every address gets a live mailbox check, and the first 100 email checks are free with a Google sign-in, no card.
How do I fill blank cells with the value above in a CSV?
- Upload the file as a CSV or .xlsx, or paste the cells with the header row first.
- Tick the columns whose blank cells should be filled.
- Check the preview and the count of cells filled.
- Download the filled file.
Example
- You enter
- Five rows with a Company column that names Acme and Globex once each and leaves the rows under them blank, with Company ticked.
- You get
- 5 rows, 3 cells filled: Eli Park and Sam Fox get Acme, and Cara Lin gets Globex. Cells that already had a value are unchanged.
- Limits
- Runs in your browser; nothing is uploaded. It copies the value above and cannot tell a group blank from missing data.
Why do exports leave blank cells?
Many reports and CRM exports are grouped: the company, the owner or the campaign appears on the first row of its group and the rows under it are blank. That looks tidy but breaks a filter, a pivot table or an import, because each row no longer carries its own value.
Filling down copies the value into every row of the group, so each row stands on its own.
How does it decide what to fill?
Going down the file, it remembers the last non-blank value of each ticked column. A blank cell, or one with only spaces, takes that value. A cell that already has a value is never changed and becomes the new value to copy.
Blank cells above the first value of a column are left empty and counted. A row that is blank in every column is treated as a break and is not filled. To remove such rows, use remove blank rows from CSV.
What does it not do?
It cannot tell a blank that belongs to the group above from a value that is simply missing, so tick only the columns that are grouped. It does not fill the email column with an address you do not have; for that, see fill missing emails. To see how complete each column is first, use the CSV fill rate checker.
Who uses this tool, and for what?
- Marketers
- Give every contact under a company heading its own company value before a segmented send.
- Cold emailers
- Repair a lead export that names the account once and leaves the contacts under it blank.
- Analysts
- Make a grouped report filterable by filling the group name into each row.
What can’t this tool tell you?
- It copies the value above and cannot tell which blanks are really missing data.
- Blanks above the first value of a column stay blank.
- It does not fill an email column with addresses it does not have.
- Only the first sheet of a workbook is read.
Common questions
- Does it change cells that already have a value?
- No. Only blank cells, and cells with only spaces, are filled.
- Can I fill several columns at once?
- Yes. Tick as many as you like. Each column is filled from its own cell above.
- What happens to blanks at the top?
- They stay blank, because there is no value above them. The result shows how many.
- Should I fill the email column?
- Usually not. A blank email is a missing address, not a group heading. Tick only grouped columns such as company or owner.
- Does it need an email column?
- No. Any CSV works. If the list has a column of addresses, the check button under the result carries them across.
- Is my file uploaded?
- No. The file is read in your browser and goes nowhere.
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.