How to Convert Markdown Tables to Excel

The problem: Markdown tables use pipe characters (|) and dashes to create structure. Excel doesn't understand this syntax — it expects tab-separated values. A straight copy-paste from a Markdown table dumps all the symbols into a single cell instead of creating rows and columns.

The solution: Convert the Markdown table to TSV (Tab-Separated Values) before pasting. That's exactly what the MarkdownPaste converter does with its "Copy for Excel" feature.

What you'll need

• A Markdown table (from an AI assistant, documentation, or your own notes)
• A browser tab open to markdownpaste.online
• Microsoft Excel, Google Sheets, or another spreadsheet application

No account, no extension and no install required.

The workflow

1. Copy your Markdown table

From your AI chat (Claude, ChatGPT, Gemini), documentation, or notes, copy the Markdown table. It looks like this:

Select the table text and copy it with Ctrl+C (or Cmd+C on Mac).

2. Open MarkdownPaste

Navigate to markdownpaste.online in your browser. The converter loads instantly — no sign-up required.

3. Paste into the Markdown input

Click into the left panel labeled "MARKDOWN INPUT" and paste with Ctrl+V (or Cmd+V). The right panel instantly shows a rendered preview of your table.

4. Click "Copy for Excel"

Below the preview, you'll see two buttons:

• Copy Rich Text — for Word, Google Docs, Gmail
• Copy for Excel — for spreadsheets ← Click this one

When you click "Copy for Excel", MarkdownPaste converts your table to TSV format and writes it to your clipboard.

5. Open Excel or Google Sheets

Switch to your spreadsheet application and click on the cell where you want the top-left corner of your table to appear.

6. Paste

Press Ctrl+V (or Cmd+V). Excel automatically splits the tab-separated values into individual cells, creating a properly formatted table.

7. Verify and format

Check that:

• All columns are in separate cells (not merged)
• All rows are on separate lines
• Headers are in the correct row
• Numbers and dates are formatted as needed

Apply Excel formatting (borders, colors, number formats) as desired.

Before and after

Here's the difference between pasting Markdown directly versus using MarkdownPaste:

Practical examples

Example 1: Product inventory

| SKU | Product Name | Category | Price | Quantity |
|-----|--------------|----------|-------|----------|
| P001 | Wireless Mouse | Electronics | $29.99 | 245 |
| P002 | USB-C Cable | Accessories | $12.99 | 500 |
| P003 | Laptop Stand | Furniture | $49.99 | 87 |

Example 2: Sales data

| Date | Region | Sales Rep | Revenue | Units Sold |
|------|--------|-----------|---------|------------|
| 2026-01-15 | North | Sarah Johnson | $12,450 | 342 |
| 2026-01-15 | South | Mike Chen | $8,920 | 215 |
| 2026-01-16 | East | Lisa Park | $15,300 | 428 |

Example 3: Employee directory

| Employee ID | Name | Department | Position | Start Date |
|-------------|------|------------|----------|------------|
| E1001 | James Wilson | Engineering | Senior Developer | 2023-03-15 |
| E1002 | Maria Garcia | Marketing | Marketing Manager | 2022-08-01 |
| E1003 | David Kim | Sales | Account Executive | 2024-01-10 |

Example 4: Project tasks

| Task ID | Description | Assignee | Priority | Due Date | Status |
|---------|-------------|----------|----------|----------|--------|
| T-101 | Design homepage mockup | Alex | High | 2026-09-25 | In Progress |
| T-102 | Write API documentation | Sam | Medium | 2026-09-28 | Not Started |
| T-103 | Set up database | Jordan | High | 2026-09-23 | Complete |

Common problems and solutions

Problem: Columns are misaligned or merged

Cause: The Markdown table has inconsistent column counts or missing pipes.

Solution: Ensure every row has the same number of columns. Each row should start and end with a pipe character (|).

Problem: Cell content contains line breaks

Cause: Multi-line content in Markdown table cells.

Solution: MarkdownPaste strips line breaks from cells to prevent column shifting. If you need multi-line content, add it manually in Excel after pasting (Alt+Enter for line break in a cell).

Problem: Numbers formatted as text

Cause: Excel interprets certain values as text instead of numbers or dates.

Solution: Select the column, go to Data → Text to Columns, and specify the format. Or use Excel's NUMBERVALUE() function to convert.

Problem: Special characters cause issues

Cause: Tabs or unusual characters in cell content.

Solution: MarkdownPaste automatically removes tabs and normalizes line breaks. If problems persist, check for unusual Unicode characters.

Problem: Empty cells not preserved

Cause: Missing pipes between empty cells.

Solution: Use | | or || to indicate empty cells. Example: | Product | Price | | (empty Stock column).

Problem: Formatting doesn't match Excel defaults

Cause: TSV only transfers data, not styling.

Solution: Apply Excel formatting after paste: borders, cell colors, number formats, date formats, etc. The structure is preserved; styling must be applied in Excel.

Why TSV works for Excel

Excel and Google Sheets automatically split pasted text based on delimiters:

• Tab character → separates columns
• Newline → separates rows

TSV (Tab-Separated Values) is perfect for this because:

• Tabs rarely appear in normal text content
• Unlike commas (CSV), tabs don't conflict with decimal points or list items
• Excel recognizes tab-delimited data and auto-splits it
• No quoting or escaping needed for most content

MarkdownPaste converts your Markdown table by:

1. Removing the pipe characters (|)
2. Replacing them with tab characters
3. Stripping the separator line (|---|---|)
4. Converting inline formatting (**bold**, *italic*) to plain text
5. Removing any tabs or line breaks within cells

Good to know

• Privacy: Nothing is uploaded. All processing happens in your browser.
• Works offline: Once loaded, MarkdownPaste works without an internet connection.
• Google Sheets compatible: The same TSV format works in Google Sheets, Apple Numbers, and LibreOffice Calc.
• Large tables: Supports tables of any size, though very large tables (1000+ rows) may take a moment to process.
• Inline formatting: Bold, italic, links, and code in table cells are converted to plain text.
• Headers preserved: The first row of your Markdown table becomes the header row in Excel.