How to Fix Broken CSV Files: Quotes, Delimiters, and Row Errors

### Common CSV Errors & How to Fix Them

#### 1. Inconsistent Column Count
**Symptom**: Error stating "Row 45 has 12 columns, expected 10".
**Cause**: An unescaped comma inside an address or field created an unexpected extra column.
**Fix**: Use the [CSV Validator](/csv-validator) to inspect line 45 and wrap the cell in quotes (`"...`").

#### 2. Malformed / Unclosed Quotes
**Symptom**: Parser absorbs thousands of rows into a single text block.
**Cause**: A quote mark was left unclosed (`"John Smith`).
**Fix**: Locate the open quote mark using [CSV Validator](/csv-validator) and add the missing closing double quote.