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.SUMskips it without warning. - Dates guessed with your computer’s locale.
02-Sep-2026usually works;05/09/2026becomes 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.
| Trade date | Symbol | Side | Qty | Price | Net amount | Ccy |
|---|---|---|---|---|---|---|
| 02-Sep-2026 | AAPL | BUY | 10 | 228.40 | 2,284.00- | USD |
| 09-Sep-2026 | MSFT | SELL | 5 | 431.15 | 2,155.75 | USD |
| 15-Sep-2026 | EMAAR | BUY | 1,200 | 8.95 | 10,740.00- | AED |
| 30-Sep-2026 | AAPL | DIV | 3.75 | USD |
| Trade date | Symbol | Side | Qty | Price | Net amount | Ccy |
|---|---|---|---|---|---|---|
| 2026-09-02 | AAPL | BUY | 10 | 228.40 | -2284.00 | USD |
| 2026-09-09 | MSFT | SELL | 5 | 431.15 | 2155.75 | USD |
| 2026-09-15 | EMAAR | BUY | 1200 | 8.95 | -10740.00 | AED |
| 2026-09-30 | AAPL | DIV | 3.75 | USD |
- 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
| Method | Works on logged-in pages | Numbers and dates | Where the data goes |
|---|---|---|---|
| Select, copy, paste | Yes | Often text; dates use your locale | Stays on your computer |
| Excel Data → From Web (Power Query) | Usually no: Excel downloads the URL itself, without your browser session | Typed, after you set types in Power Query | Excel fetches the page |
Google Sheets =IMPORTHTML(url, "table", 1) | No: Google’s servers fetch the page | Guessed by the sheet’s locale | Google fetches the page |
| StatementTidy (Chrome extension) | Yes: it reads the tab you already have open | Typed numbers, ISO dates, signed amounts | Stays 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
- Install StatementTidy. Download the free extension and load it in Chrome (chrome://extensions → Developer mode → Load unpacked).
- 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.
- Click the StatementTidy icon. It lists every table on the page. Pick the one you want; the preview is already cleaned.
- 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.