Turn any web table into CSV, Excel or JSON
Grab a table from a URL, pasted HTML or your clipboard — merged cells handled, headers detected, clean columns out. No manual copy-paste fixing.
How it works
Grab the table
Paste the page URL and fetch it, drop in raw HTML, or copy a table in your browser or spreadsheet and paste it straight into the capture zone with Ctrl+V.
We clean it up
Merged cells are expanded into a proper grid, the header row is detected automatically, nested tables are flattened, and every row is squared into clean columns.
Export anywhere
Toggle off the columns you don't need, then copy for Excel or Google Sheets in one click — or download CSV, JSON or Markdown.
Built for real-world, messy tables
Merged cells, solved
Rowspan and colspan cells are expanded with the value duplicated into every spanned slot, so your CSV comes out perfectly rectangular — no shifted columns.
Three ways in
Fetch a URL, paste page HTML, or paste a table copied from any browser or spreadsheet. The two paste modes are completely unlimited.
Straight into Excel or Sheets
The Copy for Excel/Sheets button puts the table on your clipboard as tab-separated values — paste into any cell and each value lands in its own column.
Pick your columns
Toggle any column off before exporting. CSV, JSON, Markdown and Copy all respect your selection, so you never re-clean data in a spreadsheet.
Finds every table
Pages with several tables get a picker showing each table's dimensions and header preview — the largest one is selected for you automatically.
Excel-safe CSV
CSV downloads include a UTF-8 BOM and proper quoting for commas, quotes and line breaks, so Excel and Google Sheets open them cleanly every time.
How to extract a table from a website
Copying a table off a web page by hand almost never works: columns collapse into one blob, merged cells shift everything sideways, and you spend longer fixing the paste than you saved. A web table extractor does the tedious part for you — it finds every <table> in the page, expands merged cells into a proper grid, detects the header row, and converts the HTML table to CSV, JSON or Markdown with clean, aligned columns. Paste a URL and this tool fetches the page; if you already have the page open, paste its HTML source or simply copy the table and paste it here — those two modes have no limits at all.
Convert an HTML table to Excel or Google Sheets
The fastest route into a spreadsheet is the Copy for Excel/Sheets button: it writes the table to your clipboard as tab-separated values, so pasting into Excel, Google Sheets or Numbers drops every value into its own cell. Prefer a file? The CSV download is saved with a UTF-8 BOM and proper quoting, so accented characters, commas and line breaks inside cells survive the trip. Developers get the same table as JSON — an array of objects keyed by the header row — and writers can grab a ready-made Markdown table for docs and READMEs.
When a free table scraper isn't enough
Fetching a URL only sees the HTML the server sends. Tables rendered with JavaScript, grids built from <div>s, dashboards behind a login and paginated listings all need a tool that works on the rendered page — that's what the Ultimate Web Scraper extension does, point-and-click, including auto-pagination that merges a table spread over dozens of pages into one export. And a table is rarely the whole job: map out a site first with the Sitemap URL Extractor, pull a whole product catalogue with the Shopify Product Extractor, or convert any page into clean plain text with the Website to Text converter.
Frequently asked questions
How do I copy a table from a website to Excel?
Load the table here — paste the page URL, or select and copy the table in your browser and paste it into the 'Paste a copied table' tab. Then click 'Copy for Excel/Sheets': the table goes onto your clipboard as tab-separated values, so when you paste into Excel or Google Sheets each value lands in its own cell. If you prefer a file, the CSV download opens directly in Excel.
Why doesn't a table show up when I fetch the URL?
Because it isn't in the page's HTML. Many sites render tables with JavaScript after the page loads, so the raw HTML a server-side fetch sees contains no <table> at all. Workaround: open the page yourself, copy the rendered table and use the 'Paste a copied table' tab. Or use the Ultimate Web Scraper extension — it reads the fully rendered page in your browser and extracts JavaScript tables in one click.
How are merged cells (rowspan and colspan) handled?
Each merged cell is expanded across every row and column it spans, with its value duplicated into each slot. That turns a visually merged table into a clean rectangular grid, which is exactly what CSV, JSON and spreadsheets expect — no misaligned columns.
IMPORTHTML not working — is this an alternative?
Often, yes. Google Sheets' IMPORTHTML only reads the raw server HTML, so it fails on JavaScript-rendered tables, login-protected pages and sites that block Google's fetcher — and it breaks silently when the table index shifts. This tool fetches the same way from a URL, but also lets you paste HTML or a copied table, which works for anything you can see on screen. For tables behind logins or built with JavaScript, the Ultimate Web Scraper extension extracts them from the live page.
Is the tool free? What are the limits?
Yes — no signup, and all parsing happens in your browser. URL fetching is limited to 5 fetches per day per browser; the Paste HTML and Paste-a-copied-table modes are completely unlimited. The Ultimate Web Scraper extension has no fetch limit because it extracts from pages you already have open.
Can I convert an HTML table to JSON?
Yes. The JSON export gives you an array of objects, one per row, keyed by the detected header row (empty headers become 'Column 1', 'Column 2', and duplicates are suffixed so keys never collide). Column toggles apply, so you can export only the fields you need.
Can it extract a table that's split across multiple pages?
The free tool processes one page at a time — you can fetch or paste each page and merge the CSVs yourself. If the table is paginated (page 1, 2, 3… or a 'Load more' button), the Ultimate Web Scraper extension auto-paginates and merges everything into one dataset for you.
Tables are just the start.
The free Ultimate Web Scraper extension extracts lists, product catalogues, emails and any repeating data from any site you open — JavaScript-rendered, behind logins, across pagination — point-and-click, no code.
Free forever plan · No credit card · Works on any website