ExcelTool.io

Markdown to Excel Converter

Paste markdown tables from READMEs, docs, or AI chat output and download them as an Excel workbook - one sheet per table.

How to Convert Markdown Tables to Excel

  1. Paste markdown - a whole README, a chat answer, or just the table. You can also upload .md, .markdown or .txt files, several at once.
  2. Check the count - the summary reports how many tables were found and how many rows they hold, before anything is downloaded.
  3. Download XLSX - each table lands on its own sheet, headers included as the first row.

How a Pipe Table Becomes a Sheet

The parser scans the text for a line containing a pipe that is followed by a separator row - the | --- | --- | line, with or without alignment colons. That pair marks the start of a table. Each following line that still contains a pipe is split into cells on unescaped pipes, and every cell is trimmed of surrounding spaces. Leading and trailing pipes are optional, so the loose style that AI chats and many wikis produce parses the same as a strict GitHub table.

A table ends at the first blank line or the first line without a pipe. Rows that are shorter than the widest row are padded with empty cells, so a table where somebody dropped a trailing pipe still comes out rectangular rather than shifting the columns.

Edge Cases and Limits

  • Values are written as text. Markdown carries no types, so 95 becomes the text 95 and 2026-02-10 stays text too. Fix a column with Convert Text to Number when you need to calculate on it.
  • Alignment is dropped. The colons in :---: are used to recognise the separator, not to format the column.
  • The separator row is required. A block of pipe-delimited lines with no --- row underneath is not a table and is skipped; add one, or paste the block into CSV to Excel with the pipe as the delimiter.
  • HTML tables are not read. If your document uses <table> markup instead of pipes, use HTML to Excel.
  • Escapes decoded: \| becomes a pipe inside the cell and \\ becomes one backslash. All other markdown stays literal.
  • Sheet names are Table 1, Table 2 and so on, in document order.

Tables Pasted from AI Chats and Wikis

Most tables people paste here did not come from a strict Markdown editor, so the parser is deliberately tolerant: pipes at the start and end of a line are optional, extra spaces around cells are trimmed, and text before or after the table is ignored. Four things still break a paste, and all four are quick to spot:

  • The separator row is missing. Chat answers sometimes render a table visually without emitting the | --- | line. Add one line under the header and the table is found.
  • A row was wrapped by the window it was copied from, splitting one record across two lines. The second half becomes its own row, or is dropped if it has no pipe.
  • A blank line inside the table ends it. The rows after the gap become a second table, and therefore a second sheet, unless they have their own separator row.
  • Bold headers such as **Region** arrive with the asterisks intact - the parser removes only pipe and backslash escapes, never formatting.

When to Use a Different Tool

Going the other way, Excel to Markdown turns a worksheet back into a pipe table. Tables in a LaTeX paper are handled by LaTeX to Excel, tables in a web page by HTML to Excel, and JSON or YAML records by JSON to Excel and YAML to Excel. Once the workbook is downloaded, Excel Editor opens it in the browser for a quick tidy-up.

Frequently Asked Questions

Related Tools