How to Copy a Table From a Website to Excel (Without the Cleanup)

A practical guide to the four ways that actually work, and where each one breaks.

You found the numbers you need on a web page. Getting them into Excel or Google Sheets should take ten seconds. Instead you paste and get one giant column, dates that turn into gibberish, or a "table" that arrives as a wall of unstructured text. Here is what actually works, from simplest to most robust.

1. Plain Copy-Paste (Try This First)

Select the table with your mouse, copy, and paste into a sheet. For simple static HTML tables this genuinely works, and you should not install anything for a one-off.

Where it breaks: merged cells scatter, currency and percent formatting turns numbers into text, thousands separators confuse the sheet, and many modern sites do not use real table markup at all, so the paste arrives as plain text. Paginated tables give you one page at a time.

2. Paste the Table Into Google Sheets as TSV

Tab-separated text is the most reliable paste format. If you can get the table as TSV (tabs between columns, newlines between rows), both Sheets and Excel split it perfectly. The trick is producing clean TSV from a web page, which is where a converter or extension earns its keep.

3. Paste the HTML Into a Converter

When copy-paste mangles the table, go one level down and grab the markup itself:

1. Right-click the table and choose Inspect.
2. In DevTools, find the enclosing <table> element, right-click it, and choose Copy → Copy outerHTML.
3. Paste that into an HTML-to-CSV converter and export.

This route survives formatting that breaks visual copy-paste, because the converter reads the table structure directly. TableLift includes paste-a-table converters for exactly this: HTML to CSV and TSV free, HTML to Markdown, JSON, and typed Excel with Pro. You can also paste whole page source and pick the table by number.

4. Use a One-Click Table Export Extension

If you export tables more than occasionally, an extension removes the DevTools step. Click the icon, the page is scanned, every table and ARIA grid is listed with its size, and each has one-click export buttons.

Two things separate the good ones from the frustrating ones:

• Row limits. Several popular tools cap the free tier by rows or put CSV downloads behind a subscription. Check before you commit to a workflow. TableLift's free tier is unlimited rows for CSV and TSV, deliberately.
• Typed output. A CSV of text still needs cleanup: Excel has to guess which columns are numbers and dates, and it guesses wrong on European formats. A typed .xlsx export writes numbers as numbers and dates as dates, so SUM() and sorting work immediately.

The Paginated Table Problem

CRM lists, admin panels, and report screens love to show 50 rows per page. Copying each page into a sheet by hand is the single most tedious version of this job. The workable approach is append-style capture: export page 1, click to page 2, capture again, and keep stitching into one file until you are done. TableLift Pro's Append mode does exactly this.

European Numbers and Day-First Dates

If the table uses 1.234.567,89 formatting or day-first dates like 31/12/2025, a plain paste into a US-locale sheet silently corrupts the data. Look for locale-aware normalization: TableLift Pro converts European-formatted numbers to real values and detects day-first dates per column before writing the workbook.

Which Route Should You Take

• One simple table, once: plain copy-paste.
• Copy-paste mangled it: Inspect, copy the table HTML, use a paste converter.
• Regular exports, big tables, or dashboards: a one-click extension with no row cap.
• Paginated or multi-table pages, or data that must arrive typed: Append mode and typed .xlsx export.