Does the input need leading and trailing pipe characters?

No, both `| a | b |` and `a | b` (without the outer pipes) styles are accepted, matching how different Markdown editors format tables.

What if the second line isn't a valid --- separator row?

The tool checks that the second non-blank line matches a Markdown separator pattern (dashes, optionally with alignment colons) and returns a clear error if it doesn't, rather than misreading data as a header.

How is an escaped pipe (\|) inside a cell handled?

A backslash-escaped pipe is treated as a literal | character in the cell value, not as a column boundary, mirroring how CSV to Markdown Converter escapes it on the way out.

Are alignment markers (:---, ---:, :---:) in the separator row preserved?

No, alignment information is discarded since CSV has no concept of column alignment; only the separator's presence is validated, not its exact dash/colon pattern.

Markdown Table to CSV Converter

Overview

Introduction

Markdown tables in a README or wiki page are easy to read but awkward to work with programmatically. This tool parses a pipe table back into CSV so it can be opened in a spreadsheet or fed into a script.

It validates the required --- separator row before trusting the header, so a malformed or missing separator produces a clear error instead of silently misreading data as headers.

What Is Markdown Table to CSV Converter?

A Markdown-to-CSV converter that reads a GitHub Flavored Markdown pipe table, the header row, the --- separator row beneath it, and every following data row, into CSV.

It tolerates both the fully-piped `| a | b |` style and the bare `a | b` style, since Markdown renderers accept either.

How Markdown Table to CSV Converter Works

Each non-blank input line is split on unescaped | characters (a backslash-escaped \| is kept as a literal pipe in the cell text), after trimming any leading/trailing pipe.

The second line is checked against a separator pattern (dashes, optionally wrapped in alignment colons) before being discarded; every remaining line becomes one CSV data row, padded to match the header's column count.

When To Use Markdown Table to CSV Converter

Use it when you have a table written in Markdown, in a README, issue, or notes file, and need the underlying data as CSV for a spreadsheet or script.

It's also useful for migrating tables out of Markdown documentation into a proper data file.

Often used alongside CSV to Markdown Table Converter, HTML Table to CSV Converter and CSV to HTML Table Converter.

Features

Advantages

Validates the --- separator row explicitly, so malformed tables fail with a clear error rather than silently producing garbage.
Handles both piped and unpiped Markdown table styles.
Runs entirely client-side, so the data never leaves your browser.

Limitations

Column alignment markers (:---, ---:, :---:) are discarded, since CSV has no equivalent concept.
Assumes a single well-formed table per input; text before or after the table isn't filtered out automatically.

Examples

Converting a Markdown table

Input

| id | name | active |
| --- | --- | --- |
| 1 | Ada Lovelace | true |
| 2 | Alan Turing | false |

Output

id,name,active
1,Ada Lovelace,true
2,Alan Turing,false

The header and --- separator rows are read first, then each remaining pipe row becomes one CSV row.

Best Practices & Notes

Best Practices

Strip any prose text surrounding the table before pasting, since only table-shaped lines are parsed.
If you get a separator-row error, double check the second line actually contains only dashes/colons/pipes.
Use CSV to Markdown Converter afterward to confirm a round trip reproduces the same table.

Developer Notes

The separator-row check is a dedicated regex pass before any data is read, rather than a generic "does this look tabular" heuristic, because a Markdown table without a valid --- row isn't a table per the GFM spec, and quietly treating the second data row as if it were a separator would silently drop a real row of data.