CSV to Markdown table, and back again

Paste a spreadsheet range, a CSV file or a Markdown table. Edit it as a grid. Copy it out as Markdown, CSV, TSV, HTML or JSON. Nothing is uploaded.

Writing a Markdown table by hand means counting pipes and padding columns until they line up. Going the other way — getting a table out of a README and into a spreadsheet — is just as fiddly. This tool reads any of the common table formats, shows you the cells, and writes whichever format you need, with the columns already aligned.

What it reads

Formats the table editor understands

Input	How to bring it in	Notes
Excel, Google Sheets, Numbers	Copy a range and paste	Tab-separated on the clipboard; cells with line breaks survive
Excel workbook (.xlsx)	Choose or drop the file	Pick the worksheet; dates come through as dates, not day counts
CSV and TSV	Paste, choose or drop	Comma, semicolon, tab or pipe, detected for you; quoted fields handled properly
Markdown table	Paste	Column alignment is kept; escaped pipes are unescaped
HTML table	Paste, or copy a table from a web page	Merged cells are spread out into the grid
JSON	Paste or choose a .json file	An array of objects becomes rows with a header; arrays of arrays work too

Markdown tables that line up

The Markdown output pads every column to the same width, so the source reads as a table in a plain-text editor, not just once it is rendered. Wide characters such as Chinese, Japanese and Korean count as two columns, the way a monospaced font draws them. Pipes inside cells are escaped and line breaks become <br>, so nothing breaks the table. Set a column's alignment and the separator row gets the matching colons.

CSV that Excel opens correctly

The CSV writer follows RFC 4180: fields holding commas, quotes or line breaks are quoted, and quotes inside are doubled. It has been checked against Python's own CSV module on fifteen thousand awkward cases. Leave “Excel-friendly” on and the download starts with the byte-order mark that tells Excel the file is UTF-8, so accented letters and symbols don't arrive as garbage.

Edit like a small spreadsheet

• Tab and Enter move between cells; Tab past the last cell adds a row.
• Paste a block of cells into any cell and it fills the grid from there.
• Sort by a column — numbers sort as numbers, not as text.
• Transpose, insert and delete rows and columns, and undo any of it.
• Tidy trims stray spaces and removes empty rows and columns in one go.

Questions

How do I convert CSV to a Markdown table?

Paste the CSV anywhere on the page or drop the file onto the grid. The Markdown version appears on the right with the columns padded to line up. Press Copy.

Can I paste straight from Excel or Google Sheets?

Yes. Copy a range of cells and paste it onto the page. Spreadsheets put tab-separated text on the clipboard, which is read as a table, including cells that contain line breaks.

Can it open an .xlsx file?

Yes. Choose or drop an Excel workbook and pick the worksheet. Values are read, including the results of formulas, and dates come through as dates rather than Excel's internal day numbers. Formatting is not carried across.

How do I convert a Markdown table to CSV?

Paste the Markdown table, choose CSV on the right, and copy or download it. Alignment colons are read and escaped pipes inside cells are restored.

Is my data uploaded anywhere?

No. The table is parsed and written by the page itself, in your browser. Nothing is sent to a server, so it is safe for client lists, financial data or anything else you would rather keep to yourself.

Why do accented characters look wrong when I open the CSV in Excel?

Older versions of Excel assume a CSV is in the local legacy encoding unless the file says otherwise. Keep “Excel-friendly download” ticked and the file starts with a byte-order mark that tells Excel it is UTF-8.

Can it convert JSON to CSV?

Yes. Paste a JSON array of objects and each object becomes a row, with the keys as the header. Then choose CSV. It works the other way too: any table can be written out as JSON.

The other tools