Table Converter (Markdown, LaTeX, HTML, CSV)

Continue in the tool

More pages for this tool

ascii table generator text

ASCII and Unicode text table generator

Paste the rows and choose the border style in the ASCII tab. The table comes out ready for a comment, an email or a README, with every column at the right width, including accents and ideographs.

Six styles, measured width and reading back

The MySQL style is what the database command-line client prints: a border of plus signs and hyphens on top, at the bottom and right after the header, with vertical bars between columns. The full grid adds a separator line between every row and uses equals signs under the header, in the style of reStructuredText tables. The compact style has no outer border, just bars and a line of hyphens and pluses, like PostgreSQL psql. The Unicode styles swap the signs for box-drawing characters in single line, rounded corners or double line.
Aligning columns in a monospaced font requires measuring each text width, and counting characters is not enough. An accented letter built from two parts (an e plus a combining accent) takes one column, while Chinese, Japanese and Korean ideographs, and most emoji, take two. The tool uses that display width to pad each cell with spaces. Numbers sit on the right and text on the left by default, and you can switch per column in the edit toolbar, including centering.
Cells with several lines are drawn as several text lines inside the same table row, at the height of the tallest cell. Tabs become a single space, because a tab character would break the alignment. The reverse path works too: paste an ASCII or Unicode table in MySQL, grid or compact style, and the tool returns the cells to the edit grid, useful for fixing a table from an email or converting a terminal table to Markdown or CSV.

Checked examples

MySQL style

Input: nome,qtd ana,3 bia,10
Expected output: +------+-----+ | nome | qtd | +------+-----+ | ana | 3 | | bia | 10 | +------+-----+

The qtd column is numeric and sits on the right.

Single-line Unicode

Input: nome,qtd ana,3 bia,10
Expected output: ┌──────┬─────┐ │ nome │ qtd │ ├──────┼─────┤ │ ana │ 3 │ │ bia │ 10 │ └──────┴─────┘

Same data, Unicode style.

Full grid

Input: nome,qtd ana,3 bia,10
Expected output: +------+-----+ | nome | qtd | +======+=====+ | ana | 3 | +------+-----+ | bia | 10 | +------+-----+

Double separator under the header and a line between records.

Compact, no border

Input: nome,qtd ana,3 bia,10
Expected output: nome | qtd ------+----- ana | 3 bia | 10

Format similar to psql output.

Full tool FAQ

How do I convert an Excel table to Markdown?

Select the cells in Excel, copy with Ctrl+C and paste into the input box: the content arrives tab-separated and is recognized right away. Keep the Markdown tab active and click Copy. Numeric columns come out right-aligned (---: in the hyphen row) and text columns left-aligned, and you can force another alignment in the editing toolbar. Formulas arrive as the displayed value, not as the formula.

How do I convert CSV to a LaTeX table?

Is semicolon-separated CSV with a decimal comma read correctly?

How do I write the | character inside a Markdown table cell?

Can I merge cells?

How does SQL pick the column types?

Is there a row or column limit?

Can I convert the other way, from Markdown, HTML, JSON or LaTeX to something else?

Is my data sent to a server?

Why do 007 or a ZIP code with a leading zero stay text in SQL and JSON?

Frequently asked questions

Why does the table misalign in some places but not others?

Text only aligns in a monospaced font. In emails and chats with a proportional font, the columns fall apart. Paste into a code block (three backticks in Markdown) or use a plain ASCII style, which suffers less with fonts that lack the Unicode box characters.

Can I generate the table without a header line?

Yes. Turn off the first-row-is-header option in the edit toolbar and the first row becomes ordinary data, without the separator line right under it.

Is this the same as the ASCII character table?

No. Here you draw a data table with text. To look up ASCII character codes, use the ASCII Table tool on the site.

Next steps

Six styles, measured width and reading back

The MySQL style is what the database command-line client prints: a border of plus signs and hyphens on top, at the bottom and right after the header, with vertical bars between columns. The full grid adds a separator line between every row and uses equals signs under the header, in the style of reStructuredText tables. The compact style has no outer border, just bars and a line of hyphens and pluses, like PostgreSQL psql. The Unicode styles swap the signs for box-drawing characters in single line, rounded corners or double line.

Aligning columns in a monospaced font requires measuring each text width, and counting characters is not enough. An accented letter built from two parts (an e plus a combining accent) takes one column, while Chinese, Japanese and Korean ideographs, and most emoji, take two. The tool uses that display width to pad each cell with spaces. Numbers sit on the right and text on the left by default, and you can switch per column in the edit toolbar, including centering.

Cells with several lines are drawn as several text lines inside the same table row, at the height of the tallest cell. Tabs become a single space, because a tab character would break the alignment. The reverse path works too: paste an ASCII or Unicode table in MySQL, grid or compact style, and the tool returns the cells to the edit grid, useful for fixing a table from an email or converting a terminal table to Markdown or CSV.

Checked examples

MySQL style

Input: nome,qtd ana,3 bia,10
Expected output: +------+-----+ | nome | qtd | +------+-----+ | ana | 3 | | bia | 10 | +------+-----+

The qtd column is numeric and sits on the right.

Single-line Unicode

Input: nome,qtd ana,3 bia,10
Expected output: ┌──────┬─────┐ │ nome │ qtd │ ├──────┼─────┤ │ ana │ 3 │ │ bia │ 10 │ └──────┴─────┘

Same data, Unicode style.

Full grid

Input: nome,qtd ana,3 bia,10
Expected output: +------+-----+ | nome | qtd | +======+=====+ | ana | 3 | +------+-----+ | bia | 10 | +------+-----+

Double separator under the header and a line between records.

Compact, no border

Input: nome,qtd ana,3 bia,10
Expected output: nome | qtd ------+----- ana | 3 bia | 10

Format similar to psql output.

Full tool FAQ

How do I convert an Excel table to Markdown?

How do I convert CSV to a LaTeX table?

Is semicolon-separated CSV with a decimal comma read correctly?

How do I write the | character inside a Markdown table cell?

Can I merge cells?

How does SQL pick the column types?

Is there a row or column limit?

Can I convert the other way, from Markdown, HTML, JSON or LaTeX to something else?

Is my data sent to a server?

Why do 007 or a ZIP code with a leading zero stay text in SQL and JSON?

Frequently asked questions

Why does the table misalign in some places but not others?

Can I generate the table without a header line?

Yes. Turn off the first-row-is-header option in the edit toolbar and the first row becomes ordinary data, without the separator line right under it.

Is this the same as the ASCII character table?

No. Here you draw a data table with text. To look up ASCII character codes, use the ASCII Table tool on the site.

Table Converter (Markdown, LaTeX, HTML, CSV)

Continue in the tool

More pages for this tool

ASCII and Unicode text table generator

Six styles, measured width and reading back

Checked examples

MySQL style

Single-line Unicode

Full grid

Compact, no border

Full tool FAQ

Frequently asked questions

Why does the table misalign in some places but not others?

Can I generate the table without a header line?

Is this the same as the ASCII character table?

Next steps

Table Converter (Markdown, LaTeX, HTML, CSV)

Cell editor

Output

Continue in the tool

More pages for this tool

ASCII and Unicode text table generator

Six styles, measured width and reading back

Checked examples

MySQL style

Single-line Unicode

Full grid

Compact, no border

Full tool FAQ

Frequently asked questions

Why does the table misalign in some places but not others?

Can I generate the table without a header line?

Is this the same as the ASCII character table?

Next steps

Cell editor

Output