ImportFix

Row length error

Fix CSV row length errors before import

Normalize rows with missing or extra cells so every record matches the expected file shape.

What this problem usually means

Row length errors happen when some rows have more or fewer cells than the header row. Many importers treat that as a blocking problem because they cannot map fields reliably if the file shape changes from row to row.

Why it happens

  • Some rows are missing a value, so the row ends early.
  • Quoted text or stray delimiters caused values to spill into the wrong columns.
  • Manual edits or merged exports introduced extra separators in only some rows.

What ImportFix checks

  • How many rows differ from the header length
  • Whether a malformed quote pattern may be causing a merged or split field
  • How the repaired preview changes after row normalization
  • Any remaining warnings that still need manual review

Common repairs

Pad short rows so they match the expected column count
Preserve extra cells in longer rows instead of silently discarding them
Attempt safe recovery when a merged field likely belongs in the next column
Export a normalized CSV with consistent row shape

When to review manually

If a row was recovered heuristically, review the destination columns carefully. A normalized row count helps imports succeed, but the real question is whether the value landed in the correct field.

Related guides

Keep exploring the most common import problems, or jump into the repair workspace directly.

Open repair workspace