Clean CSV for a Report Without Losing IDs or Quoted Fields
Follow a two-record CSV through delimiter conversion and a Markdown report, checking leading zeros, quoted commas, row counts and unsupported multiline cells.
Keep one untouched source file and produce a separate presentation copy. The example below contains two records, an identifier with leading zeros and a comma inside a quoted field; these are the facts each conversion must preserve.
Tools in this guide
1. Start with a small record you can verify
Use this CSV: a header id,note, followed by 00123,"hello, world" and 00456,ready on separate lines. There are two data records and two fields per record. The comma in hello, world belongs inside note.
Do not sort or deduplicate raw physical lines before parsing. A repeated row may be a separate event, and a quoted CSV field can span lines. Removing lines can change both the record count and field contents.
id,note
00123,"hello, world"
00456,ready2. Convert separators with CSV parsing
In Delimiter Converter, select comma as the source separator and Tab as the output. The first data record should contain the fields 00123 and hello, world separated by one tab. The second should contain 00456 and ready.
Check the parsed row count and field values. Do not globally replace commas with tabs: that would split the first note into another column. This converter handles quotes within one physical line, not multiline fields. For quoted newlines, inspect the source in CSV Viewer and use a full CSV parser instead.
id note
00123 hello, world
00456 ready3. Control types when importing the result
Set the id column to text in the receiving spreadsheet or database. The strings 00123 and 00456 must not become 123 and 456. A correctly generated TSV cannot stop an application from applying automatic numeric conversion.
If moving through JSON, keep these identifiers as quoted strings and decide how empty cells differ from missing fields or null. For nested records, define the flattening policy before export rather than accepting whichever columns happen to appear.
4. Build the presentation table separately
For this simple sample, paste the TSV into Markdown Table Generator, select Tab and enable the header row. Expect two data rows under id and note, with hello, world in one cell.
The Markdown generator splits simple delimited lines; it is not a full quoted-CSV importer. Do not feed it the original quoted comma sample with comma selected, or multiline cells, and assume equivalent data. Review the rendered table and retain the structured source as the authoritative copy.
5. Write a short transformation log
Record the source record count, delimiter change, text-typed columns and any deliberate removals. Compare a few boundary records with the untouched source, including empty values, leading zeros and embedded punctuation.
Treat spreadsheet formula interpretation as an import concern when sharing untrusted data. Changing delimiters or exporting Markdown does not certify the contents as safe or accurate.