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.
Repair an inventory comment without moving its count
Input
Item,Comment,Count
Gloves,"Marked "large" on the slip",18Output
Item,Comment,Count
Gloves,"Marked ""large"" on the slip",18The 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
- Choose the separator the file already uses: comma, semicolon, tab, or pipe.
- 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.
- 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.