How to Convert a Markdown Table to CSV
Download a Markdown table as RFC 4180 CSV with values containing commas and quotes escaped properly, ready for any importer.
Direct answer
Paste the table into the converter and press Download .csv. Values containing commas, quotes, or line breaks are quoted and escaped to RFC 4180, so the file imports cleanly into Excel, Google Sheets, a database loader, or any tool that reads CSV.
Open Markdown to Excel converterWhen to use this
- An importer or API expects a CSV upload.
- You are loading data into a database or BI tool.
- You want a plain, portable file rather than a workbook.
Steps
- Paste the Markdown table into the converter.
- Press Download .csv.
- Open or upload the file wherever it is needed.
- If Excel opens it with everything in one column, check its delimiter setting — some locales default to semicolons.
- For a direct Excel paste, use Copy for Excel instead, which avoids delimiter guessing entirely.
Example conversion
| Product | Description | Price | | --- | --- | ---: | | Bolt, hex | 10mm, zinc-plated | 0.42 | | Washer | For "wide" flange | 0.09 | | Nut | M10, nylon insert | 0.15 |
Product Description Price Bolt, hex 10mm, zinc-plated 0.42 Washer For "wide" flange 0.09 Nut M10, nylon insert 0.15
Common mistakes
- Do not assume CSV is safe for values containing commas unless they are quoted — this is the single most common cause of a shifted column on import.
- Do not use CSV when you need formatting, multiple sheets, or a frozen header; download .xlsx instead.
- Do not double-click a CSV to open it in Excel in a locale that expects semicolons — use Data → From Text/CSV so you can pick the delimiter.
FAQ
- What is RFC 4180?
- The specification most CSV readers follow: fields separated by commas, records by CRLF, and any field containing a comma, quote, or line break wrapped in double quotes with internal quotes doubled. Following it is what makes a file import predictably.
- Why CSV rather than XLSX?
- CSV is universal and diff-friendly, so it suits importers, data pipelines, and version control. XLSX suits people who will open the file and read it.
- Are the line endings CRLF?
- Yes, as the specification requires. Every mainstream tool handles it, including on macOS and Linux.
- Does the header row get included?
- Yes, when the source table has one. Most importers expect a header line and let you map columns from it.
Related Excel guides
How to Paste a Markdown Table Into Excel
A pasted Markdown table lands in Excel as one column of text full of pipe characters. Convert it to a real grid first so every value gets its own cell.
How to Convert a Markdown Table to an XLSX File
Download a Markdown table as a real .xlsx workbook with a bold header row, frozen top row, and numbers stored as numbers.
How to Get a ChatGPT Table Into Excel
ChatGPT and Claude answer with Markdown pipe tables. Copying one into Excel gives you a column of pipe characters. Convert it to a grid first.
Fix Markdown Table Numbers Arriving as Text in Excel
Values that paste in left-aligned with a green triangle are text, not numbers, so SUM returns zero. Here is why it happens and how to avoid it.