Bought Pro? Your keys are in your account. Sign in

Guide · StatementTidy

How to copy a table from a website to Excel (and keep the numbers as numbers)

Short answer

Select the table and paste it, use Excel’s Data → From Web, Google Sheets’ IMPORTHTML, or a browser extension. The first three often give you numbers stored as text, dates in the wrong order and stray header rows. StatementTidy reads the table in your open tab, cleans it locally and copies typed numbers and ISO dates that paste straight into Excel.

Last updated · by Mumshad Jawad

Why this happens

A table on a web page is HTML: each cell is text, styled to look like a number. When you copy it, Excel or Google Sheets has to guess what each piece of text means. That guess fails in predictable ways:

  • Numbers stored as text. A trailing minus (2,284.00-), a currency code, a non-breaking space or a thousands separator from another locale keeps the cell as text. SUM skips it without warning.
  • Dates guessed with your computer’s locale. 02-Sep-2026 usually works; 05/09/2026 becomes 9 May on a US-English machine.
  • Formatting comes along. Pasting HTML brings fonts, links, merged cells and hidden columns.
  • Logged-in pages can’t be fetched. Tools that download the page themselves (Power Query, IMPORTHTML) only see public pages, never your online banking or broker account.

Real example: before and after

The rows below are fictional. The “after” table is not a mock-up: this page ran them through StatementTidy’s cleaning engine (the same clean.js the extension uses, v1.0.1) with its default options, and shows exactly what you would export.

Before As copied from the web page
Trade dateSymbolSideQtyPriceNet amountCcy
02-Sep-2026AAPLBUY10228.402,284.00-USD
09-Sep-2026MSFTSELL5431.152,155.75USD
15-Sep-2026EMAARBUY1,2008.9510,740.00-AED
30-Sep-2026AAPLDIV  3.75USD
After Cleaned by StatementTidy
Trade dateSymbolSideQtyPriceNet amountCcy
2026-09-02AAPLBUY10228.40-2284.00USD
2026-09-09MSFTSELL5431.152155.75USD
2026-09-15EMAARBUY12008.95-10740.00AED
2026-09-30AAPLDIV3.75USD
  • Date column converted to ISO YYYY-MM-DD
  • 2 negative amounts as real negative numbers

Open this example in the live demoEdit the rows, paste your own table, toggle options. Nothing is uploaded.

The options compared

Ways to get a web table into a spreadsheet
MethodWorks on logged-in pagesNumbers and datesWhere the data goes
Select, copy, pasteYesOften text; dates use your localeStays on your computer
Excel Data → From Web (Power Query)Usually no: Excel downloads the URL itself, without your browser sessionTyped, after you set types in Power QueryExcel fetches the page
Google Sheets =IMPORTHTML(url, "table", 1)No: Google’s servers fetch the pageGuessed by the sheet’s localeGoogle fetches the page
StatementTidy (Chrome extension)Yes: it reads the tab you already have openTyped numbers, ISO dates, signed amountsStays in your browser

How to fix it by hand in Excel

Paste without the formatting

In Excel, right-click the destination cell and choose Paste Special → Text (or Keep Text Only). In Google Sheets use Ctrl+Shift+V. This drops fonts and links but does not fix numbers or dates.

Turn text into numbers

Select the column, then Data → Text to Columns → Finish. Excel re-reads every cell with your regional settings. For a trailing minus, click Next twice, then Advanced… and tick Trailing minus for negative numbers.

Public pages only: Power Query

Data → From Web, paste the URL, pick the table in the Navigator and click Transform Data to set each column’s type. It refreshes later with one click, which is great for public price tables and useless for a statement behind a login.

How to fix it in one click with StatementTidy

  1. Install StatementTidy. Download the free extension and load it in Chrome (chrome://extensions → Developer mode → Load unpacked).
  2. Open the page with the table. Any page: a broker trade history, an invoice list, a statement. Being signed in is fine; nothing leaves your browser.
  3. Click the StatementTidy icon. It lists every table on the page. Pick the one you want; the preview is already cleaned.
  4. Copy for Excel. Click Copy for Excel and paste into Excel or Google Sheets. Numbers arrive as numbers and dates as YYYY-MM-DD. Or click CSV to download a file.

Get StatementTidy free for ChromeTry it on a sample statement

Questions

Why does Excel show a green triangle on numbers I pasted?

The green triangle means “number stored as text”. The cell held something Excel could not read as a number in your locale, such as a trailing minus, a currency code or a non-breaking space. Text cells are ignored by SUM and break sorting.

Can Power Query or IMPORTHTML read my online banking?

Normally no. Both download the page themselves, without the login session in your browser, so they see a sign-in page instead of your statement. A browser extension reads the page you already have open.

Does StatementTidy work on tables built with divs?

The free version reads real HTML tables and accessible grids (role="grid"). For portals that draw tables with plain <div>s, Pro’s “Select a region” rebuilds rows and columns from the on-screen layout.