An HTML bank statement is a web page, not a PDF, so getting an HTML bank statement to Excel is often easier than converting a PDF. Excel can open a saved page and read its tables directly, and a table in an email can be pasted. Print to PDF first only when the page layout breaks the table apart.
What counts as an HTML bank statement?
An HTML bank statement is any statement whose transactions arrive as a web page rather than a PDF. That covers a statement emailed in the body of a message, an attachment ending in .htm or .html, a statement page you saved from online banking, and the printable view some banks open in a browser tab.
You can usually tell by the file or the window:
- An attachment ending in .htm, .html or .mht. It opens in a browser, not a PDF reader.
- An email whose body is the statement. The table of transactions sits in the message itself, with no attachment.
- A "printable statement" page. The browser shows the statement in a tab, with your bank's address in the bar.
- A saved web page. You used the browser's save option and now have an .html file, often with a folder of images beside it.
Each of these holds the transactions as text in a table structure, which is good news for a spreadsheet. A web table already knows where its rows and cells are. A PDF only knows where its characters sit on the page, which is why PDF conversion has to work out the columns and a web table does not.
The catch is that not every HTML page that looks like a table is built as one. Some bank pages lay out transactions with styled blocks instead of table cells. Those paste as a single column of text, and the sections below cover what to do then.
Opening a saved HTML bank statement table in Excel
A saved HTML bank statement can be opened in Excel directly. Use File, then Open, and pick the .html or .htm file. Excel reads the page's tables into cells, with each table row as a sheet row. For a statement page that is still online, Excel's From Web option lists the tables on the page and lets you pick one.
Follow these steps for a saved file:
- Save the statement page from your browser or email as an .html file, into a folder you can find.
- Open Excel and choose File, then Open, then browse to the file. If the file does not show, change the file type filter to all files.
- Find the transaction table on the sheet. Headers, logos and account details usually come in above it.
- Delete the rows above and below the transactions, keeping one header row.
- Save as a workbook with File, Save As, choosing the Excel workbook type. Otherwise Excel may keep saving back to HTML.
For a page you can reach by address, Excel's Data tab has a From Web option. Microsoft's guide to the Power Query Web connector describes the Navigator window that follows: you select a table to load, and a Web View tab shows the whole page with each detected table highlighted. There is also an Add table using examples button for pages where no table is detected, which lets you type sample values for the data you want.
From Web has a limit for online banking. The connector's sign-in choices are anonymous access, Windows credentials, a basic user name and password, an API key, or an organizational account. A bank's own sign-in page, with its security steps, is not among them, so From Web usually cannot reach a statement behind your bank login. Save the page from your signed-in browser and open the saved file instead.
Copying an emailed statement table into a spreadsheet
An emailed statement table copies best when you select only the transaction rows and paste them into an empty sheet. Excel and Google Sheets both keep the table cells from an email as separate cells. Selecting the header row through the last transaction, then pasting, usually gives a clean grid.
Some habits make the paste cleaner:
- Paste into cell A1 of a new sheet. Pasting next to existing data can push columns into the wrong place.
- Select from the inside out. Start the selection in the first transaction cell and drag to the last, rather than selecting the whole email. That leaves the greeting and footer behind.
- Try paste as text if formatting comes along. Email styling such as colours and fonts can follow the paste. Pasting as values or plain text drops it, though plain text may put a whole row in one cell.
- Open the email in a browser if the mail app mangles it. Many mail apps can show a message in a browser, where the selection behaves like a web page.
A long statement in an email can also be saved as a file. Most mail apps can save or download a message, and some save it in a web format. That file can then go through the File, Open route above, which avoids selecting hundreds of rows by hand.
Will dates and amounts from an HTML statement work as numbers?
Dates and amounts from an HTML statement often arrive as text rather than numbers, because the page stores them as characters with formatting attached. Currency symbols, non-breaking spaces, a trailing "CR" or "DR", or a minus sign in an unusual character can each stop Excel from treating a cell as a number.
Check the amount column straight away. Real numbers align to the right in a General cell, and a SUM over the column gives a total. If the values sit on the left, or the SUM is zero, they are text.
The usual culprits in web tables are:
- Currency symbols and codes. "$1,250.00" or "USD 1,250.00" may stay as text.
- Non-breaking spaces. Web pages often use a special space character between a number and a symbol. TRIM does not remove it, but SUBSTITUTE with CHAR(160) does.
- Credit and debit markers. A trailing "CR" or "DR" keeps the cell as text and also hides the sign.
- Dates in the bank's own style. A date such as "14 Mar 2026" may convert, or may stay text, depending on your regional settings.
A helper column fixes most of these. For example, =VALUE(SUBSTITUTE(SUBSTITUTE(B2,"$",""),CHAR(160),"")) removes a dollar sign and non-breaking spaces before turning the cell into a number. Add one SUBSTITUTE per symbol your bank uses. For dates, DATEVALUE handles many text formats, and Text to Columns with a chosen date order handles the rest.
When to print an HTML bank statement to PDF first
Print an HTML bank statement to PDF first when the page will not open or paste as a clean table. Pages built from styled blocks instead of table cells, statements spread over many browser pages, and email clients that scramble the layout all convert more reliably as a PDF. Printing fixes the layout so a statement converter can read it.
Printing to PDF has its own traps, and it pays to check the result before converting:
- Blank pages. Web pages often print with an empty last page, or a page holding only a footer. Removing blank pages from a PDF before converting shows how to drop them without losing a real page.
- Pages out of order. If you print several months or several browser pages into separate files and then combine them, the order can slip. Putting PDF pages back in order covers the free tools for fixing that.
- Cut-off columns. A wide table can lose its right-hand column at the page edge. Print in landscape, or choose a fit-to-page scaling option.
- Text turned to images. Most browsers print web pages as real text, but check by selecting a line in the new PDF before you rely on it.
Once you have a good PDF, the conversion is the same as for any statement. Converting a PDF to an Excel sheet walks through the steps and the checks afterwards. FastBankConvert takes a statement PDF and is built to return each transaction as a row with its date, description, amount and balance, and you can get started with FastBankConvert to be told when trial conversions open.
Here is a short way to choose between the routes. It is a rule of thumb, not a guarantee.
| What you have | First route to try | Switch to print to PDF if |
|---|---|---|
| A saved .html file | Excel, File, Open | The transactions land in one column |
| A statement page you can reach without signing in | Excel, Data, From Web | Navigator shows no usable table |
| A table in an email body | Select rows and paste | Cells merge or rows break apart |
| A page behind your bank login | Save the page, then File, Open | The saved page shows no transactions |
HTML statement parts that should stay out of the sheet
Several parts of an HTML statement should stay out of the sheet, because they look like data but are not transactions. Layout tables, summary boxes, pending items and repeated headers all come through when Excel opens a page. Removing them before you sort or total keeps the transaction list honest.
Watch for these:
- Layout tables. Many web pages and emails use tables just to place the logo, address and footer. Excel opens them as extra blocks of cells above and below the transactions.
- Summary boxes. Opening balance, total debits, total credits and closing balance often sit in their own small table. Keep them for checking, but not inside the transaction list, or a SUM will count them twice.
- Pending transactions. A web statement page may show pending items above posted ones. Pending amounts can change or disappear, so leave them out of a record of the period.
- Repeated headers. A long page split into sections can repeat the column headers. A filter on the date column finds them.
- Hidden content. Some pages hold hidden rows or tables that do not show in the browser but do appear in Excel. Scan the sheet for anything you did not see on screen.
When the list is clean, check it against the summary box: opening balance plus credits minus debits should equal the closing balance. A match tells you no row was left behind or counted twice.