Common CSV Errors and How to Fix Them

If your conversion results look "jumbled" or columns are grouped together, you're likely facing one of these three common issues.

1. The Delimiter Mismatch

While 'CSV' stands for Comma-Separated, many regions (especially in Europe) use Semicolons (;) by default.

• The Fix: Our tool auto-detects this, but if your JSON has one property containing the whole line, you should manually check your delimiter.

2. Unescaped Quotes

If a text field contains a double quote, the standard says it must be escaped with ANOTHER double quote:

• Incorrect: "He said "Hello" world"
• Correct: "He said ""Hello"" world"

3. Leading/Trailing Spaces

Many data exports accidentally include spaces around the delimiter: id , name , price.

• The Fix: These spaces will be included in your JSON keys (e.g., "id "). Clean these in your spreadsheet software using the 'TRIM' function before converting.