Markdown Table Generator — Table to Markdown

The Complete Guide: Writing and Formatting Markdown Tables

Whether you are documenting an API on GitHub, writing a technical blog post, or organizing notes in Obsidian, you will eventually need to create a table in Markdown. However, manually aligning pipe characters (|) and hyphens (-) is incredibly tedious. In this guide, we will cover the core syntax, column alignment rules, escaping tricks, and how to instantly convert spreadsheet data into Markdown.

Basic Markdown Table Syntax

The foundational rule for creating a table in Markdown is straightforward: use vertical pipes (|) to separate columns, and add a dashed line consisting of hyphens (-) immediately beneath the header row.

| Header 1  | Header 2  | Header 3  |
| --------- | --------- | --------- |
| Data 1    | Data 2    | Data 3    |
| Data 4    | Data 5    | Data 6    |

While some Markdown parsers allow you to omit the outer pipes at the beginning and end of a line, including the outer pipes is considered best practice. It ensures optimal compatibility across major platforms like GitHub Flavored Markdown (GFM), Reddit, and Jekyll.

Controlling the Alignment of Columns

To improve the readability of your data, you can specify text alignment (left, center, or right) for each individual column. You do this by placing a colon (:) on the dashed separator row.

As a general typography rule: use right alignment for numbers and currency (it helps decimal points line up), center alignment for statuses, tags, or boolean values, and left alignment for descriptive text paragraphs.

Limitations and Escaping Characters

Markdown tables have severe constraints compared to HTML tables. Be aware of the following gotchas:

1. No Native Multi-line Cells

By design, a single row in a Markdown table must correspond to a single line of text in your `.md` file. If you need a line break inside a cell, you must manually insert standard HTML break tags (<br>).

2. How to Write a Pipe Character Inside a Cell

Because the pipe character (|) defines column boundaries, attempting to write a mathematical absolute value like `|x|` or a logical OR `||` will break the table parsing entirely. You must escape the character with a backslash (\|) or use the HTML entity (|).

Stop Formatting by Hand: Converting CSV / Excel

If your table has more than three columns, manually typing it out is a massive waste of developer time.