CSV JSON Cell Repair

Repair CSV cells containing raw JSON

Keep an entire JSON object in one CSV column

CSV and JSON both use commas. CSV uses them between cells. JSON also uses them between object members and array elements. A CSV reader needs a quoted field to distinguish nested comma characters from the next column.

Keep row width meaningful. Extra commas outside a selected JSON column can indicate a separate quoting problem. The tool stops on a row whose field count disagrees with the expected width.

Read the worked example