CSV to Markdown Table Converter

How it is calculated

Each non-empty line of the pasted text is one row, split into cells with the chosen delimiter (comma by default, or semicolon). Standard CSV quoting is understood, so a quoted cell can contain the delimiter, and each cell is trimmed of surrounding spaces. The first row always becomes the header. The second output line is the separator row, one marker per column: :--- for left, :--: for centre, ---: for right. Rows shorter than the widest row are padded with empty cells, and the column count is the widest row. Pipe characters inside a cell are escaped as \| so they do not split the cell. The result also reports the row count, header included, and the number of columns. Empty input gives no result.

Common mistakes

• Leaving the delimiter on comma for semicolon-separated data, which is common when decimals use a comma: every line then becomes one wide cell or splits at each decimal comma.
• Expecting a tab-separated paste to work. Only comma and semicolon are offered, so a tab-separated paste ends up as one column; convert tabs to one of the two first.
• Forgetting the header. The first line is always the header row, so data without a header gets its first record promoted into the header.
• Starting a cell with a double quote and never closing it. The rest of the line is swallowed into that cell. Inside a quoted cell, a literal quote is written as two double quotes.
• Expecting numbers to be aligned by the tool. It only writes the alignment marker; the right-aligned look appears when a Markdown renderer displays the table.