How do I convert a Markdown table to Excel?

The quickest reliable path is via CSV: copy the Markdown table into a small converter or script that strips the pipe (|) syntax into comma-separated rows, then open the CSV in Excel, which imports it as a spreadsheet. Pandoc can also convert Markdown to formats Excel reads. For a one-off, several web tools take a pasted Markdown table and return an .xlsx or CSV directly.

How do I convert a Markdown table to CSV?

A Markdown table is already close to CSV: each row is cells separated by pipes. Remove the leading/trailing pipes and the separator row (the |---|---| line), then replace the pipe delimiters with commas. Many editors and small scripts do this automatically. Excel, Google Sheets, and Numbers all open the resulting CSV natively.

Does the conversion keep formulas or just values?

Just values. A Markdown table stores text and numbers, not formulas, so converting to Excel gives you a data grid without live calculations - you add formulas in Excel afterward. If your goal is a live, calculating view rather than a static grid, a dashboard tool that runs queries on the data (rather than a spreadsheet file) is often the better fit.

Is Excel the best format for sharing table data?

Not always. An .xlsx is a file: whoever opens it needs Excel or a compatible app, and the moment the numbers change you resend it. For sharing a view of data that stays current, a dashboard you share as a link - KPIs, a chart, a ranked table, all from the same source - opens on any device and updates in place. Plain takes that approach and exports .xlsx as a fallback when a file is required.

2026-07-236 min·#how-to#sheet

如何把 Markdown 表格转成 Excel(以及什么时候仪表盘比表格更好)

Zephyr WhimsyEditorial · 2026-07-23

把 Markdown 表格转成 Excel(.xlsx 或 CSV)的可靠方法,转换会保留什么,以及什么时候一个可分享的数据仪表盘比表格文件更好。

The short answer

A Markdown table is basically CSV with pipes, so the fastest route to Excel is Markdown table to CSV, then open in Excel. Pandoc and web tools also work. Conversion keeps values, not formulas. If the goal is sharing a live view of the data rather than a static grid, a dashboard you share as a link beats an .xlsx file - that is the path Plain takes, with xlsx export kept as a fallback.

You have a table in Markdown - from an AI answer, a doc, or a README - and you need it in Excel. The conversion is simple once you see that a Markdown table is already almost a CSV. Here are the reliable ways, and one question worth asking before you make yet another spreadsheet file.

The fast path: Markdown table to CSV to Excel

A Markdown table looks like this:

| Month | Revenue |
|-------|---------|
| Jan   | 120000  |
| Feb   | 135000  |

Strip the outer pipes and the |---| separator row, swap the remaining pipes for commas, and you have CSV:

Month,Revenue
Jan,120000
Feb,135000

Save that as .csv and open it in Excel - it imports as a proper spreadsheet. Most Markdown editors, a short script, or a web converter will do the pipe-to-comma step for you. This is the most reliable route because CSV is the universal handoff format every spreadsheet app reads.

Pandoc and online converters

Pandoc can convert Markdown into formats Excel opens, and several web tools take a pasted Markdown table and return an .xlsx or CSV directly. Online tools are convenient on a locked-down machine; just avoid them for sensitive data, since the table is uploaded to a third-party server. For repeatable conversions across many files, a script around the CSV method is the most predictable.

One thing no converter changes: you get values, not formulas. A Markdown table stores text and numbers, so the Excel result is a static grid. You add calculations in Excel afterward.

	CSV method	Pandoc	Online tool	Plain (dashboard)
Best for	Quick, universal	Scripted batches	No-install one-off	Sharing a live view
Output	CSV -> Excel	Excel-readable file	.xlsx / CSV	Dashboard link + xlsx
Keeps formulas	No	No	No	Runs queries live
Privacy	Local	Local	Uploaded	Your account

The first three give you a static spreadsheet file. A dashboard keeps the data as a shareable, queryable view.

When a dashboard beats a spreadsheet

Converting to Excel is right when you need to edit cells, add formulas, or hand someone a file they will work in. But a lot of the time the table is not meant to be edited - it is meant to be read and shared: a set of numbers, a trend, a ranking. For that, an .xlsx is clumsy: the receiver needs Excel, and the file is out of date the moment the numbers change.

Plain's sheet takes a different shape. Instead of a grid, it turns table data into a data dashboard you share as a link - KPIs, a chart, a ranked table, and short captions, all from one source (a Markdown table or CSV). It opens on any device, stays current, and you can build it from a CSV with AI. When someone genuinely needs the raw grid, Plain exports .xlsx as a fallback - the file is the exception, not the default.

How to choose

You want...                          -> Reach for
-----------------------------------------------------------
A quick spreadsheet from a table     -> CSV method (open in Excel)
Scripted, repeatable conversion      -> Pandoc / script
No install, one-off                  -> Online converter
A shareable, live data view          -> Plain (dashboard + xlsx export)

If you need cells and formulas, convert to Excel and move on. If the table is really a small report you want people to read and trust, a dashboard link keeps it current and openable anywhere - with the spreadsheet file always one export away.

所有文章打开工作台