Markdown to Excel
Convert Markdown tables to a real .xlsx, one worksheet per table.
Convert Markdown tables to a real .xlsx, one worksheet per table. Paste your content and get an instant result.
Paste Markdown containing one or more tables and this page builds an Excel workbook: each table becomes its own worksheet, the first heading names the file, and numeric cells are stored as numbers rather than text.
The workbook is assembled in the tab from the Markdown token stream, so nothing is uploaded. The first heading in the document supplies the file name, falling back to workbook when there is no heading.
A document with no table still produces a workbook holding its source lines, because an empty file is not a conversion. That behaviour is stated here because it is easy to mistake for an error.
One worksheet per table
Each Markdown table becomes a worksheet in document order. The header row is the first row, and a cell whose text is a number is written as a numeric cell, so a column can be summed in the spreadsheet instead of being sorted as text.
Alignment markers are not carried into the workbook: a right-aligned Markdown column is a presentation hint, and the spreadsheet has its own formatting model.
- One worksheet per Markdown table
- Numbers written as numeric cells
- File name from the first heading, or workbook when there is none
When there is no table
The converter does not refuse a document without a table. It writes the source lines into a sheet, which is useful when you wanted the text in a spreadsheet and not a grid.
Inline formatting such as bold or a link is written as its text, so a cell holds the readable value rather than Markdown syntax.
How to use the table input
Paste the Markdown into the input workspace and export the workbook: each table becomes its own worksheet in document order, the first heading names the file falling back to workbook, and a cell whose text is a number is written as a number so a column can be summed. Inline formatting becomes its readable text and alignment markers are dropped.
A document with no table still produces a workbook holding its source lines rather than refusing, which is the stated behaviour to expect rather than an error. The workbook is assembled in the tab and nothing is uploaded.
What to Expect
Best for
- Turning Markdown tables into worksheets you can calculate with
- Exporting several tables into one workbook
- Getting a file that opens in Excel, LibreOffice and Sheets
Not ideal for
- Charts, pivot tables or formulas, which the converter does not create
- Preserving Markdown formatting inside cells
- A document whose tables have ragged column counts
What this tool keeps
- Each table as a separate worksheet
- Numeric cells as numbers, so sums work
- The first heading as the workbook's file name
What may need cleanup
- A sheet of source lines when the input had no table
- Column widths, which the converter does not tune
- A ragged row, which is padded or truncated to the table's width
Common errors
- Expecting a chart or a formula to be generated
- Reading a one-sheet text export as a failed conversion
- Assuming inline bold survives into the cell
Example use cases
- Moving a pricing table into a spreadsheet
- Exporting several Markdown tables into one workbook
- Getting numbers into cells that a spreadsheet can total
Sample input
Paste Markdown with a region and revenue table and a quarterly plan table.
Sample output
A workbook with two worksheets, revenue cells stored as numbers, named from the document's first heading.
Who this is for
- Analysts converting documentation into a workbook
- Operations teams moving a table into Excel
- Anyone who needs a spreadsheet rather than a table image
Frequently asked questions
How are Markdown tables mapped to Excel?
Each table becomes its own worksheet, the first heading names the file, and numeric cells are stored as numbers rather than text.
Does the converter create formulas or charts?
No. It writes plain cells, so formulas, pivot tables and charts are not created.
What happens when the input has no table?
The workbook contains a sheet of source lines instead of a table.
Build custom tools for your store
Join the SDK program to create useful ecommerce utilities for your store.