Map Extract
Free tool

Convert CSV to a Markdown table

Paste rows from a spreadsheet or a CSV file and get a Markdown table with the columns padded to line up, a divider row in the alignment you choose, and any pipe characters inside values escaped so the table does not break.

Runs in your browser. Nothing you enter is uploaded.

A short stockist list for a project note

This CSV has a business name with a pipe character in it and one empty cell. Both are the usual reasons a hand-made Markdown table goes wrong.

The converter escapes the pipe as \|, so Marlow Print | Design stays in one cell, and keeps the empty review cell as blank padding. Columns are padded to the widest value, so the table is readable as plain text as well as when rendered.

Input
business,town,reviews
Kiln & Co Pottery,Frome,48
"Marlow Print | Design",Bath,112
Oak Lane Joinery,Frome,
Result
| business               | town  | reviews |
| ---------------------- | ----- | ------- |
| Kiln & Co Pottery      | Frome | 48      |
| Marlow Print \| Design | Bath  | 112     |
| Oak Lane Joinery       | Frome |         |

Making the table

  1. Paste the data

    Paste CSV text, or copy a block of cells straight from Excel or Google Sheets; those arrive tab separated and are detected.

  2. Check the separator

    Leave it on Detect, or force comma, semicolon, tab or pipe if the columns come out wrong.

  3. Choose alignment

    Left, Centre or Right sets the divider row for every column: ---, :---: or ---:. Right suits a table of numbers.

  4. Copy it

    Copy the Markdown or save it as table.md. The first row of your data is always used as the header.

Where Markdown tables render

PlaceRenders tables?Note
GitHub, GitLab issues and READMEsYesGitHub Flavoured Markdown tables
Notion, Obsidian and most note appsYes, on pasteSome convert to their own table block
Slack and many chat appsNoShows as text; the padding keeps it readable
ChatGPT, Claude and other AI chatsYesA compact way to give a model tabular context
Plain emailNoUse the HTML table converter instead

Tables in notes, tickets and prompts

A Markdown table is the lightest way to put a few rows of data into a document that lives as text: a handover note on a client's lead list, a ticket asking for a fix to certain records, or a project wiki page listing target towns and who covers them. It survives copy and paste between tools far better than a screenshot.

It is also a good format for giving an AI assistant a small table to reason about, such as twenty prospects with their town and category, because the structure is explicit. For anything over a few dozen rows, attach the CSV instead; long Markdown tables are hard for people and machines to scan.

Questions people ask

How do I convert a spreadsheet to a Markdown table?

Select the cells in Excel or Google Sheets, copy them, and paste them into the box. The cells arrive tab separated, which the converter detects, and a Markdown table appears with the first row as the header. Copy the result into your document, README or note.

Can I align some columns right and others left?

The alignment setting applies to every column. Choose the one that suits most of the table, then edit the divider row by hand for the exceptions: add a colon on the right of the dashes for right alignment, or on both sides for centred.

What happens to pipe characters in my data?

Any | inside a value is written as \| so that renderers treat it as text, not as a column boundary. The cell then displays the pipe normally. Without that escape, a single pipe in a business name would shift every following cell in that row.

Does it support line breaks inside cells?

Standard Markdown tables do not allow a line break inside a cell, so keep cell text on one line. If a value really needs two lines, many renderers accept an HTML line break tag in the cell text, but support varies between apps.

Where your data goes

The table is generated in your browser from what you paste. The data is not uploaded or stored by Map Extract.

Checked against the tool on

Top