What happens to rows that already have the right number of cells?

They're left completely untouched. Only rows with fewer cells than the header get padded.

What about rows with MORE cells than the header?

This tool doesn't touch them; it only pads short rows. Use the CSV extra comma remover to truncate overlong rows instead.

What value fills the missing cells?

Empty strings. Each missing trailing cell becomes a plain empty field, matching how most CSV consumers represent a missing value.

How do I know how many rows were padded?

The tool tracks and can report the number of rows padded, so you can confirm the scale of the fix before trusting the output.

CSV Incomplete Record Filler

Overview

Introduction

A CSV row missing a trailing value or two will misalign every downstream tool that expects a fixed number of columns. This tool fills in the gaps automatically, padding short rows with empty cells so every row matches the header.

It's a targeted fix: only rows that are actually short get changed, so you don't risk altering rows that are already correct.

What Is CSV Incomplete Record Filler?

A CSV repair tool that pads any data row with fewer cells than the header with trailing empty cells, bringing it up to the header's column count.

Rows that already match, or exceed, the header's length are left exactly as they are.

How CSV Incomplete Record Filler Works

The input is parsed into a grid of rows using the shared RFC 4180-aware parser, so quoted fields with embedded delimiters or newlines are counted as a single cell, not split incorrectly.

The header row's cell count becomes the target width. Every data row shorter than that is extended with empty string cells until it reaches the target width, then the grid is re-serialized back into CSV text.

When To Use CSV Incomplete Record Filler

Use it after the incomplete record finder has shown you which rows are short and you're ready to auto-fix them.

It's also useful as a quick normalization step before importing CSV into a system that requires every row to have the same number of fields.

Often used alongside CSV Incomplete Record Finder, CSV Extra Comma Remover and CSV Validator.

Features

Advantages

Only changes rows that are actually short, leaving well-formed rows untouched.
Correctly counts cells even when fields contain quoted commas or embedded newlines.
Runs entirely client-side.

Limitations

It only pads missing trailing cells with blanks; it can't recover the actual missing data.
Rows with more cells than the header are left alone, not truncated: pair with the extra comma remover for that case.

Examples

Padding a short row

Input

id,name,active
1,Ada,true
2,Alan

Output

id,name,active
1,Ada,true
2,Alan,

The second data row was missing its 'active' value, so an empty trailing cell was added to bring it up to 3 columns.

Best Practices & Notes

Best Practices

Review flagged rows with the incomplete record finder first, so you understand what data is genuinely missing before padding.
Treat padded blanks as a placeholder, not a resolved value: go back and fill in real data where it's available.
If most rows in the file are short, double-check the delimiter is actually correct before assuming data is missing.

Developer Notes

The filler reuses `parseCsvGrid`/`stringifyCsvGrid` and only differs from `padGridToRectangle` in that it pads to the *header's* width specifically rather than the widest row in the grid, and it deliberately does not touch rows already at or above that width.