CSV Quote Repair

Keep quotation marks inside CSV fields

A field with a comma is often enclosed in double quotes. If the field itself contains a quote, CSV represents it with two adjacent double quotes so the reader can tell it apart from the end of the field.

Open CSV Quote Repair

Repair an inventory comment without moving its count

Input

Item,Comment,Count
Gloves,"Marked "large" on the slip",18

Output

Item,Comment,Count
Gloves,"Marked ""large"" on the slip",18

The outer quotes still enclose the comment. The import reader turns each doubled quote into one literal quote in the comment and leaves the count in the third field.

Check the result

  1. Choose the separator the file already uses: comma, semicolon, tab, or pipe.
  2. Compare the number of fields with your source header. If the first row is incomplete, enter the expected field count from the original export settings.
  3. Import the result using that separator and confirm that the repaired field still contains its literal quote.

Common problems

A quote before a separator can be ambiguous

An interior quote followed by a separator can look like the end of the field. Check the intended field boundaries in the source system when the result reports an inconsistent column count.

Backslashes can be ordinary characters

Enable backslash escapes when a backslash immediately before a quote means a literal quote in this export. Leave it off for tables that use backslashes as text.

Read exported pipe and tab tables with their own separator

The download keeps your selected separator. Choose the same separator in your import dialog.

Using CSV Quote Repair

Open your table

Use the exact file that failed to import and set its separator.

Check the quote settings

Use the column count to detect shifted values. Turn on backslash escapes only if the source uses them.

Check repaired rows

Review affected field locations and download the output using the original separator.

Offline use

Open the tool once online and let it finish loading. Use the install option in your browser or Add to Home Screen on iPhone. Reopen the tool to process a new input offline.

References