How to handle newlines and quotes in CSV

The core rule: quotes protect delimiters

If a value contains the delimiter (comma/semicolon/tab) or a newline, it must be wrapped in double quotes. Inside a quoted value, a literal double quote is escaped by doubling it ("").

Why embedded newlines break row counting

Many parsers split on newlines first, then parse columns. If a newline appears inside a value but the value isn’t properly quoted, the file “looks” like it has extra rows and the header-to-row column count no longer matches.

Practical checks before converting

• Scan for quotes: do you see values like “ACME, Inc.” or multi-line addresses?
• Check a failing row: the row often contains a stray quote or an unescaped quote.
• Confirm delimiter: wrong delimiter can hide quote issues and vice versa.

Local conversion workflow

1. Paste CSV (or select a file) into a local converter.
2. Convert and inspect a couple of objects around the failing row.
3. Download JSON and validate shape if needed.

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

Practical checklist (fast)

If you’re stuck, use this quick checklist to narrow the problem before you try “random fixes”. Start by validating the input format (syntax first), then confirm shape expectations (array vs object, headers vs rows). Convert a small sample, inspect the output, and only then export the full result.

• Validate: confirm the input is strict JSON/XML/CSV (no stray characters).
• Confirm shape: arrays vs objects; headers vs row lengths; repeated tags vs arrays.
• Test a sample: first 20–50 rows/items are enough to detect parsing issues.
• Export: copy/download the output and re-check it in the consumer (script/spreadsheet/API).

This workflow is privacy-first by design: All processing happens locally in your browser. Files are never uploaded.

FAQ

My CSV has quotes everywhere. Is that bad? Not necessarily—some exporters quote all fields. The important part is consistent escaping.

What’s the fastest fix for a broken file? Re-export from the source system with proper CSV settings, or fix the problematic row’s quoting.

Local verification snippet

Run a quick local check before export/convert:

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)