· 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

  1. Copy the whole table, including the separator row. Leave out the surrounding paragraph.
  2. Paste it into a Markdown-to-Excel converter, or upload the .md file.
  3. Download the .xlsx and open that file. Do not open the .md in Excel.

Markdown table to 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.

Excel to Markdown →

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.

संबंधित टूल

← सभी लेख

और लेख