How to use this tool
- Open the CSV and preview the column boundaries. Try the delimiter used by the source system, including tab, semicolon, or pipe.
- Inspect records with too few or too many fields. Check whether a delimiter belongs inside a quoted field or marks a genuine column break.
- For ambiguous quotes or misplaced separators, check the original text and correct it in a copy before reimporting. Compare the row and column totals before export.
Worked examples
| Original data | After review |
|---|---|
| id;city;region appears in one column | Choosing semicolon reveals three columns |
| 7,Portland, OR where the schema has two fields | 7,"Portland, OR" when the location is one field |
Frequently asked questions
Can a quoted field contain a line break?
Yes. A quoted field can span physical lines. Compare the number of parsed records with the expected records, since counting lines can overstate the total.
Why does a missing quote need human review?
An opening quote can cause a parser to treat later lines as part of the same field. Check where the field should end in the source before you insert a closing quote.
