What This Tool Does
This tool scans for quotes that appear inside a field but aren't properly escaped (e.g., "Height: 6'4""), which causes parsers to split rows incorrectly.
How It Works
1Upload the CSV with quote errors.
2The tool heuristically identifies quotes that are part of the content vs. structural quotes.
3It adds the necessary escape characters (double formatting).
4Download the fixed file.
Input Format
CSV files where quotes are breaking the columns.
Output Format
Valid RFC-4180 compliant CSV.
When to Use This Tool
- Data fields contain inches (") or feet (') symbols.
- Columns are split in the middle of a text field.
- Imports fail due to "Unexpected quote" errors.