Fill Blank Cells

Fill empty cells in a CSV or Excel table. Fill down or up, copy from the left, use a fixed value, or fill with the column average, median or most common value.

  • Free, no sign-up
  • Runs in your browser
  • Your data stays private

How to use the Fill Blank Cells

  1. Paste your table.
  2. Choose how to fill: down, up, left, a fixed value, mean, median or most common.
  3. Copy the filled table and check the per-column report.

Why use this Fill Blank Cells

  • Seven fill methodsDown, up, left, constant, mean, median and mode.
  • N/A as blankTreats N/A, null, NaN and dashes as blank cells if you want.
  • Column choiceFill only the columns you list, by number, letter or name.
  • Fill reportShows how many cells were filled in each column.

Frequently asked questions

How do I fill down blank cells like in Excel?

Choose "The value above (fill down)". Each blank takes the last value above it.

Can I fill blanks with the average?

Yes. Choose "Column average" and numeric blanks get the mean of that column.

Will it fill cells that contain N/A?

Yes, when "Also treat N/A, null, NaN and - as blank" is ticked.

Related tools

More Spreadsheet & CSV tools

User Reviews

–
No ratings yet
Write a review
Your rating *

Your email is never published. Reviews are moderated, and links aren't allowed.

What users are saying

No reviews yet

Be the first to share your experience with this tool — your feedback helps others.