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 guides

Read a broken CSV one record at a time

Recognize delimiter problems, quoted commas, and missing quotes by comparing a short CSV excerpt with the fields you expect.

When an order export suddenly has an extra column, start with one affected record and its header. Open a copy in a text editor so the original separators and quotes are visible.

Count fields in context

This export promises three fields: an order ID, a location, and a status.

order_id,location,status
1007,"Portland, OR",paid
1008,Albany, NY,open

The Portland row has three fields. Its quotation marks tell a CSV reader to treat the comma inside the location as text. The Albany row has four fields. If the source confirms that Albany, NY is a single location, the corrected record is 1008,"Albany, NY",open.

Check the source before joining adjacent fields. A fourth value can also come from a newly added column whose header was left out.

Follow a quoted field to its end

One record can occupy two physical lines.

order_id,delivery_note
1009,"Use the side door.
Ring twice."

The embedded line break belongs to the delivery note. Inserting a row break after “door.” would split one order into two. A missing closing quote can cause the opposite effect, drawing subsequent orders into one long note. Find the intended boundary in the source system or the original export before editing.

Check the scope of the problem

If every record appears as a single column, inspect the separator in the header. The line order_id;location;status suggests a semicolon-delimited file. If only a handful of records have the wrong width, compare those records with nearby rows that parse correctly.

Reimport the corrected copy, compare its record count with the source, and inspect a value containing a comma, a quote, or a line break. The CSV repair tool lets you review the parsing choices and affected records.