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.
business,town,reviews Kiln & Co Pottery,Frome,48 "Marlow Print | Design",Bath,112 Oak Lane Joinery,Frome,
| business | town | reviews | | ---------------------- | ----- | ------- | | Kiln & Co Pottery | Frome | 48 | | Marlow Print \| Design | Bath | 112 | | Oak Lane Joinery | Frome | |
Making the table
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.
Check the separator
Leave it on Detect, or force comma, semicolon, tab or pipe if the columns come out wrong.
Choose alignment
Left, Centre or Right sets the divider row for every column:
---,:---:or---:. Right suits a table of numbers.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
| Place | Renders tables? | Note |
|---|---|---|
| GitHub, GitLab issues and READMEs | Yes | GitHub Flavoured Markdown tables |
| Notion, Obsidian and most note apps | Yes, on paste | Some convert to their own table block |
| Slack and many chat apps | No | Shows as text; the padding keeps it readable |
| ChatGPT, Claude and other AI chats | Yes | A compact way to give a model tabular context |
| Plain email | No | Use 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