2026-06-18 · Table to Sheets guide

Pasted a web table and it all landed in one column? Here's why

You highlight a neat table on a web page, copy it, paste it into Google Sheets or Excel — and every row lands in a single cell, stacked down column A. Or the columns almost work: the first few line up, then everything shifts one place right and the rest is nonsense.

This isn't you clicking wrong. Copying a table from a website only preserves columns if a few specific things are true, and on modern pages they often aren't.

Why the columns collapse

1. The source isn't a real <table>. This is the big one. Plenty of "tables" — dashboards, pricing grids, sports and finance stats — are built from <div> elements styled with CSS grid or flexbox to look like a table. There are no rows and cells to map onto, so the paste falls back to plain text and everything lands in one column.

2. The paste lost its HTML. Columns survive because the clipboard carries a rich-text (HTML) copy alongside the plain-text one. Anything that strips it — a plain-text field, a terminal, a notes app, Ctrl+Shift+V — leaves your spreadsheet nothing but line breaks to work with.

3. Merged cells. A header spanning two columns (colspan) or a label spanning several rows (rowspan) has no equivalent in a flat grid. The spreadsheet fills the first cell and leaves blanks after it, so every row below drifts out of alignment.

4. Hidden or sticky columns. Columns hidden by a toggle, or a frozen first column rendered separately from the rest of the table, arrive as empty junk columns or vanish — shifting everything else.

5. Extra header and layout rows. Multi-level headers, group titles, and filter bars inside the table come along too, so your data starts three rows lower than expected.

6. Line breaks inside cells. A cell holding an address or wrapped description with a real newline splits into two rows on paste, pushing everything after it out of step.

Fixes for a paste you've already made

1. Paste as HTML, not text. Structure rides in on the rich-text copy, so plain Ctrl+V into a fresh sheet is what carries it. In Excel, Home > Paste > Paste Special > HTML keeps the grid; choosing "Text" throws it away.
2. Split the single column back apart. Select it and use Data > Split text to columns in Sheets, or Data > Text to Columns in Excel. Pick the delimiter you can actually see — tab is the usual winner for pasted tables, while comma will shred any value like 1,234.
3. Fix merged cells first. Unmerge, fill the blank label cells down, then delete leftover header rows. Do this before splitting — splitting a misaligned table just gives you tidy nonsense.

The reliable route: export the structure, not the text

Every fix above is repair work on something that already lost its shape. The alternative is to never lose it: read the table's real rows and cells from the rendered page straight into CSV, where each cell is genuinely its own field.

That's what Table to Sheets does. Click it on any page, it lists every table it finds, and you export the one you want to a clean CSV — free and unlimited, no row cap. Because it reads the page's actual structure rather than pixels of text (not OCR, nothing uploaded, runs only when you click), the columns stay aligned. The optional Pro tier ($5/mo) adds one-click export to a new Google Sheet plus a clean mode that strips [1] footnote markers, thousands-separator commas, and leading $ or £.

Honest caveat: if the source is div-based grid markup with no real table in it, no tool can conjure cells that don't exist — that's the one case where splitting by a delimiter is still your best move. And if you'd rather not install anything, paste raw page markup into the free HTML table to CSV converter, or tidy a messy export with the CSV cleaner.

The short version

• One-column pastes almost always mean the source wasn't a real <table>, or the clipboard's HTML was stripped on the way in.
• Misaligned-but-present columns usually mean merged cells, hidden or sticky columns, or stray header rows.
• Repair an existing paste with Split text to columns / Text to Columns — and unmerge before you split.
• To skip the problem entirely, export the table structurally to CSV instead of copying text off the screen.

Related guides

• How to copy a table from a website into Excel — without the mess
• How to export an HTML table to Google Sheets (3 reliable ways)
• How to export a big web table (more than 250 rows) to CSV — free

Related free tools