Clean empty cells in CSV and Excel files
Gaps in a spreadsheet break sorting, totals and every import that reads the file afterwards. Upload the file, choose how blanks should be handled, and download a cleaned copy.
Clean a fileThree ways to handle a blank
A blank is not always the same thing, so it is not always fixed the same way. Pick the steps that match the file and they run in the order you set.
Fill missing values
Replaces cells with nothing in them by a value you choose, applied to the columns you point at. Use it when a gap has an obvious default, such as a zero in an amount column or a placeholder in a label.
Fill empty text cells
Targets cells that hold an empty piece of text rather than nothing at all. Spreadsheets leave these behind after an edit and they look identical to a real gap on screen, which is why they need their own step.
Drop rows with gaps
Removes whole rows that are missing a value. Use it when an incomplete record is worth less than a clean table, for example before importing into a system that rejects the whole batch over one gap.
Questions
Does the file I upload get changed?
No. The upload is read, the cleaning steps are applied to a copy, and the result is offered as a separate file to download. The original file is untouched.
What is the difference between a missing value and an empty text cell?
A missing value is a cell with nothing in it at all. An empty text cell holds a value that happens to be an empty piece of text, which spreadsheets often leave behind after an edit. The two are filled by separate steps because a file can contain both.
How long are uploaded and generated files kept?
Results expire after a configured period, after which the stored input and result files are deleted automatically.