Search rowmedic

Remove DuplicatesFix Date FormatRepair CSVClean TextCSV ValidatorCSV to ExcelRemove Empty RowsClean Excel DataToolsUse CasesPricingBlogHelpWhich columns make a record unique?Read a broken CSV one record at a timeStandardize dates without swapping the month and day
rowmedic
โ† All tools

Repair CSV

A file that opens in one long column may use semicolons. A single extra column in one row often points to an unquoted delimiter. Inspect the parsing warnings and compare the affected records with the source.

Open Repair CSV โ†’

How to use this tool

  1. Open the CSV and preview the column boundaries. Try the delimiter used by the source system, including tab, semicolon, or pipe.
  2. Inspect records with too few or too many fields. Check whether a delimiter belongs inside a quoted field or marks a genuine column break.
  3. 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 dataAfter review
id;city;region appears in one columnChoosing semicolon reveals three columns
7,Portland, OR where the schema has two fields7,"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.

Try this tool with the customer demo โ†’

Browse all tools ยท Import and export help