Markdown Editor by Teklonato

Copy a Markdown table into Excel

Use Copy table in the editor to paste Markdown table data into a spreadsheet. It copies the visible text as rows and columns, including headings and empty cells.

Open the Markdown editor

Paste a Markdown table into Excel

  1. Open a Markdown file that contains a table. If you’re copying the example below, start a blank document, switch to Source, and paste it.
  2. Switch to Write or the formatted pane of Split and select Copy table above the table.
  3. Select the top-left destination cell in Excel and paste.
Rendered Markdown table with the Copy table button outlined above the top-right corner
Copy table copies the headings and every row, including empty cells.

Keep leading zeroes and dates as text

Excel may interpret values such as 00123 or 1/2 when you paste. If those characters are part of an ID or label, format the destination column as Text before pasting. Cell styles and Markdown formatting can be applied in Excel afterward.

Try a table with an empty cell

Paste this example into Source or open it from a .md file. After copying the rendered table, paste into A1 in Excel. The empty Notes cell should stay blank.

| Item   | Quantity | Notes  |
| ------ | -------: | ------ |
| Tea    |        2 |        |
| Coffee |        3 | Ground |

Try this table in the editor