Getting a Markdown table into spreadsheet columns

Paste a Markdown table into Excel or Google Sheets and the whole thing lands in a single cell, pipes and all. The table has structure, but nothing in the paste tells the spreadsheet where one column ends and the next begins.

Spreadsheets have a convention for that, and it is older than Markdown: tab-separated values. A tab means “next cell”, a newline means “next row”. Paste text shaped that way and the columns land correctly with no import dialog.

The three modes

Take this table:

| Elective | Credits | Assessment |
| --- | --- | --- |
| Operations Research | 3 | Exam + project |
| Data Storytelling | 2 | Portfolio |

Aligned columns — the default. Every column is padded to its widest cell:

Elective             Credits  Assessment
Operations Research  3        Exam + project
Data Storytelling    2        Portfolio

This is the one to use for an email, a terminal, a code comment or a plain-text report. It only holds together in a monospace font — in a proportional font the padding no longer lines up, because the characters are not all the same width.

Tab-separated — the same content with a tab between cells. It looks ragged on screen and pastes perfectly into a spreadsheet. Use it for exactly that and nothing else.

Label and value lines — each row becomes its own block, with the header as the label:

Elective: Operations Research
Credits: 3
Assessment: Exam + project

Elective: Data Storytelling
Credits: 2
Assessment: Portfolio

Longer, but it survives anywhere. This is what to reach for when the column widths would wrap — a narrow email client, a chat message, a mobile screen — or when the table is really a set of records rather than a grid.

Which to pick

Destination	Mode
Excel, Sheets, Numbers	Tab-separated
Email, terminal, code comment	Aligned columns
Chat message, narrow screen	Label and value lines
A document you will format anyway	Rich text, which makes a real table

The Report & tables preset sets aligned columns and strips code blocks and images, which is usually what you want when the table is the point of the document.

A note on very wide tables

Eight columns of long text will not fit on a page in any mode. Aligned columns will wrap and lose their alignment; a PDF will run off the edge.

At that point stop trying to make it a document. Use tab-separated output, paste it into a spreadsheet, and share that instead. A spreadsheet is the right container for a wide grid, and no amount of clever conversion changes that.