Fix CSV newlines (CRLF vs LF) before converting (no upload)

Why line endings matter

CSV parsing is line-based: each row is separated by a newline. If tools disagree about what counts as a newline, rows can merge or split incorrectly.

Windows typically uses CRLF (\r\n), while Unix/macOS uses LF (\n).

Symptoms of newline issues

Rows appear duplicated, shifted, or your last column contains stray \r characters.

You may see unexpected empty rows, especially when combined with quoting problems.

• Header looks OK but some rows have “extra columns”.
• A single row becomes two rows when opened in a different app.

Practical fixes

Re-export from the source system when possible—this is the cleanest fix.

If you must normalize locally, convert line endings to LF and then re-validate row lengths against the header.

Be careful with CSV files that contain quoted fields with embedded newlines: those are valid CSV, and naive “split by newline” logic can break rows. Always validate with a small sample before exporting.

How to confirm in 60 seconds

Open the file in a plain text editor and inspect row endings. If you notice stray \r characters or visible ^M, you’re likely seeing CRLF/LF handling differences.

A fast sanity check is to convert 20 rows locally and verify the number of columns stays constant (header columns match each data row).

• Symptom: last column ends with “\r” → normalize line endings.
• Symptom: random extra rows → check for embedded newlines inside quoted fields.
• Symptom: row/column mismatch → fix delimiter/quotes first, then line endings.

Trust note: All processing happens locally in your browser. Files are never uploaded.

FAQ

Is CRLF invalid CSV? No. Both are common. The issue appears when a tool handles them inconsistently.

Should I upload the file to fix it? For private data, keep processing local. Use no-upload tools and verify results with small samples.

import csv
from io import StringIO

sample = text[:50000]  # keep first chunk for fast local triage
rows = list(csv.reader(StringIO(sample)))
print('rows:', len(rows), 'columns(first row):', len(rows[0]) if rows else 0)