· CSV.ink Team
How to Import a Markdown Table into Excel
Excel does not open .md files as tables. Convert the pipe table to XLSX first, or you will paste a single blob of text into one cell.
A Markdown table looks like a table in GitHub and like punctuation in Excel. If you paste the source into a worksheet, you usually get one column of text full of pipe characters. Importing Markdown format into Excel means turning that text into real cells.
What Excel needs to see
| name | city | | --- | --- | | Emma | Seattle |
The second line is not decoration. Converters use it to tell the header from the data. :--- and ---: are alignment hints; they do not change the values that land in Excel.
A reliable path
- Copy the whole table, including the separator row. Leave out the surrounding paragraph.
- Paste it into a Markdown-to-Excel converter, or upload the .md file.
- Download the .xlsx and open that file. Do not open the .md in Excel.
When the table will not convert
- There is no | --- | line under the header. Add one.
- A cell contains a raw newline. In Markdown that is often written as <br>; a converter should keep it inside one cell.
- The file has several tables. Expect several sheets, not one sheet with everything stacked and unlabeled.
- You copied from a rendered page and the clipboard is already tab-separated. In that case paste straight into Excel and skip conversion.
Going the other way — a sheet you already have, into a README — is Excel to Markdown, not this import.
After the workbook opens
Check the column count against the Markdown header. If a row is short, a missing pipe in the source is the usual cause. Numbers stay as text until you convert them in Excel; that is safer for IDs than guessing types during import.