WORKED EXAMPLE / PUBLIC SAMPLE DATA
Repair a CSV with duplicate headers and uneven rows
This semicolon-delimited export repeats an email header, has a short row and contains an extra field. Here is exactly how the repair tool handles it.
These are fictional sample records. Both files below are free; processing your own file includes a free diagnostic and limited preview, followed by a $2.99 one-time payment for the complete output.
Open this sample in the toolBefore
name;email;email Ada;ada@example.com; Lin;lin@example.com Sam;sam@example.com;;extraDownload the sample input
What the tool found
- 3 rows have inconsistent widths. Empty cells are padded; extra fields are preserved.
- 2 missing or duplicate headers normalized.
- Detected ; delimiter. Converted to comma-separated fields.
- UTF-8 input → UTF-8 output with consistent CRLF newlines.
After
name,email,email_2,column_4 Ada,ada@example.com,, Lin,lin@example.com,, Sam,sam@example.com,,extraDownload the complete sample output
Why preserve the extra field?
A surplus field could contain useful information. The tool adds a column for it instead of dropping it. Short rows receive empty cells; duplicate headers receive unique names. Those changes make the file rectangular without inventing missing values.
Can this repair every broken CSV?
No. Ambiguous or unterminated quoting can make row boundaries unknowable. The tool rejects those cases before checkout instead of guessing which values belong together.
What happens to my file?
Original uploads are processed in memory. Your generated output is private and accessible for 24 hours. Use the same browser for checkout and download. Read our file-handling policy.