How to use
- Copy a range from Excel or Google Sheets and paste it into Table data. CSV, semicolon or pipe separated text, and an existing Markdown table all work. The delimiter is detected automatically.
- Choose whether the first line is the header and how to align columns (default, left, center, right). Columns that hold only numbers are right-aligned automatically.
- Pick Markdown or HTML output, then copy it or download it. Paste it straight into a README, a GitHub issue, Notion or a blog.
- Insert blank table drops in a 3-column frame that you can fill by hand.
Conversion example
A pasted tab-separated table with headers Product, Qty, Price (Apple 12 1,500 / Banana 3 800 / Strawberry (seasonal) 20 4,200) converts like this with default options. Qty and Price are number columns, so they are right-aligned.
| Product | Qty | Price |
| --------------------- | --: | ----: |
| Apple | 12 | 1,500 |
| Banana | 3 | 800 |
| Strawberry (seasonal) | 20 | 4,200 |
Turn off Pad columns and set every column to center and the source gets shorter:
| Product | Qty | Price |
| :-: | :-: | :-: |
| Apple | 12 | 1,500 |
| Banana | 3 | 800 |
| Strawberry (seasonal) | 20 | 4,200 |
The two tables hold the same content and differ only in alignment. Padding makes the source easier to read, and skipping it keeps lines short and easy to edit.
Reading the alignment row
| Separator | Meaning |
|---|---|
--- |
default alignment (the viewer decides, usually left) |
:--- |
left |
:---: |
center |
---: |
right |
The separator has at least three hyphens. This tool adds hyphens to match the column width.
Markdown table rules and how this tool handles them
- A header is required. GFM tables need a header line and a separator line. If you turn the header option off, an empty header line is inserted.
- A pipe (
|) inside a cell becomes\|. Left as is, it would split the column. - A line break inside a cell becomes
<br>, because a Markdown table row cannot span lines. - CJK width: in a monospace font a Korean or Chinese character is two letters wide, so padding by character count misaligns the lines. This tool counts Hangul, Han and full-width characters as 2 columns. Some emoji may differ in width depending on the font.
**bold**, links and inline code inside cells are left alone, and Markdown formatting still applies inside the table.- Every row is padded with empty cells to the widest row. Completely blank lines are skipped.
FAQ
Why does pasting from Excel add quotes?
When a cell contains a line break or comma, Excel wraps it in double quotes on copy. This tool reads those quotes correctly (RFC 4180). Line breaks inside cells turn into <br>.
Why is my number column aligned left?
Every value in the column must look like a number (12, -3.5, 1,234, 50%) to go right. One unit or word makes it an ordinary column. Set Column alignment to right to push all columns right.
Can I edit a Markdown table again?
Paste the existing Markdown table and it is read in without its separator row. Fix the cells and generate it again with a different alignment.
What is the HTML table for?
For a CMS or email body that does not support Markdown. Headers come out as <th scope="col"> and alignment as style="text-align:...". To go the other way, from an HTML table to CSV, use the HTML Table to CSV tool.
How large a table can it take?
Up to 2,000 rows, 50 columns and 500,000 characters. Split bigger CSV files before converting.
Related tools
- To see how the finished table renders, use the Markdown Preview.
- To turn HTML into Markdown use HTML to Markdown, and for JSON data the JSON and CSV Converter.
- To convert an Excel file itself to CSV, there is the CSV and Excel Converter.
The table you enter is processed only in your browser and never sent to a server.