CSV / Table Formatter

Format CSV and messy rows into useful tables

Delimited text is a portable way to move tabular data between spreadsheets, databases, applications and documentation. Real CSV can contain quoted commas, escaped quotes and multiline cells, so splitting every line at each comma is unreliable. This formatter uses a structured CSV parser and reports issues it encounters.

Paste data from a spreadsheet, export or log, inspect the parsed table and choose the output needed for documentation, a web page, an API fixture or another spreadsheet.

Available table formats

• Markdown: create a readable table for README files, documentation and issue descriptions.
• HTML: generate semantic table, header and cell elements with escaped content.
• JSON: convert header-based rows into objects or headerless rows into arrays.
• CSV and TSV: standardise delimiters and correctly quote values that contain special characters.

How to handle uneven rows

An uneven row contains fewer or more cells than the others. Enable normalisation to fill missing cells to the widest detected row. Review the preview before using the output because a missing delimiter may indicate a source-data error rather than an intentionally empty cell.