Smart CSV Gap-Filler & Aligner

Smart CSV Gap-Filler & Aligner

Blank cell (with suggested fill) Text in a mostly-numeric column

Beyond Basic CSV Validation

Most CSV tools only check whether a file parses - this one looks at whether the data makes sense. For each column, it detects the dominant type (mostly numbers, or mostly text) by checking what at least 60% of the non-blank values look like, then flags two kinds of problems: blank cells, and values that don't match their column's type - like a stray "N/A" or "unknown" sitting in an otherwise all-numeric Salary column.

For every blank cell, it suggests a fill based on the rest of that column: the column average for numeric columns, or the most frequently repeated value for text columns - visible directly in the highlighted preview, with a one-click copy of the filled-in CSV.

How Suggestions Are Chosen

Numeric Columns → AverageBlanks in a column that's mostly numbers get filled with that column's mean, rounded to match whether the column uses decimals.
Text Columns → Most Common ValueBlanks in a mostly-text column get filled with whichever value appears most often elsewhere in that column.
Type Mismatch HighlightingA text value inside a mostly-numeric column (and vice versa) is flagged separately from blanks, since it likely needs a manual look rather than an auto-fill.
100% LocalEvery calculation runs in your browser - your data is never uploaded.

Frequently Asked Questions

Does this tool upload my CSV data anywhere?

No - parsing, analysis, and gap-filling suggestions are all computed entirely in your browser using plain JavaScript. Your data is never uploaded or sent to a server.

How does it decide if a column is "numeric"?

It checks every non-blank value in the column and treats it as a numeric column if at least 60% of them parse as valid numbers - a small number of text exceptions (like "unknown" or "N/A") in an otherwise numeric column will be flagged as mismatches rather than changing the column's overall type.

Are the suggested fills guaranteed to be correct?

No - a column average or most-common-value is a reasonable statistical guess, not a fact about the specific missing record. Always review suggested fills before using them, especially for anything that matters (like financial data).

What happens to the type-mismatch cells - are they auto-fixed too?

No - mismatched values (like text in a numeric column) are only highlighted for your attention, never automatically changed, since there's no safe way to guess what the correct value should have been.