To copy an online banking page to Excel, set the date range, load every row onto the screen, select only the transaction list, and paste it as plain text. Then turn the amounts and dates into real numbers and dates. It works for a few weeks of activity, but you lose the statement's balances and its proof.
What an online banking page gives you that a PDF does not
An online banking page gives you transactions that are already text, so there is no PDF to decode and no OCR to check. You also see recent activity before any statement is issued. The trade-off: a web page is a view that can change, not a fixed record.
Copying from the page has real advantages:
- No conversion step. The words and numbers on a web page are text in the browser. Copying them does not depend on fonts inside a file or on reading a scan.
- Current activity. A statement covers a closed period. The web page shows this week's card payments the day they post.
- Your own date range. Many banks let you filter the list by dates or by type, so you can pull exactly the period you need.
It also has limits that the rest of this guide comes back to. The page may not show a running balance on every line. Pending items can sit in the same list as posted ones. Descriptions may be shortened for the screen. And the layout belongs to the bank's website, which can change without notice.
Before you start, look for a download option on the same page. Many online banking sites offer a CSV or spreadsheet export of the transaction list. If yours does, use it; it is cleaner than any copy. Copying the page is for when that option is missing, broken or limited to a short period.
Selecting just the transaction list on an online banking page
Selecting only the transaction list means starting your drag on the first date and ending it on the last amount, not using select-all. Select-all grabs menus, account tiles, adverts and footer links along with the rows, and they all land in your sheet as junk.
The steps that work on most banking sites:
- Scroll to the top of the list so the first transaction row is visible.
- Click just before the first date and hold the mouse button.
- Scroll down while holding, or use Shift and click: click before the first date, scroll to the end, then hold Shift and click just after the last amount.
- Copy with Ctrl+C on Windows or Command+C on a Mac.
If the drag keeps selecting the whole page, the site may draw the list in a way that resists partial selection. Two fallbacks help:
- Copy one screen at a time. Select what is visible, paste it, then scroll and repeat. Overlap by a row or two and remove the duplicates afterwards.
- Use the browser's print preview. Printing the page often strips the side menus and adverts, leaving a simpler layout. You can copy from the preview, or save it as a PDF and work from that.
Watch for column headers that sit outside the list, such as "Date" and "Amount" fixed at the top of the screen. They may not come with your selection. That is fine; you will add your own header row in Excel.
How do you paste online banking rows into Excel cleanly?
Paste online banking rows as plain text, not as web content. A normal paste brings the website's fonts, colours, links and hidden layout cells, which can merge cells, add pictures and split one row across several. Plain text keeps the words and the tab gaps between columns, which Excel turns into cells.
In Excel, click cell A2 (leaving row 1 for headers), then use one of these:
- Paste, then Keep Text Only. After a normal paste, a small Paste Options button appears. Choose Keep Text Only.
- Paste Special. On the Home tab, open the Paste menu, choose Paste Special, and pick Text or Unicode Text.
In Google Sheets, Ctrl+Shift+V on Windows or Command+Shift+V on a Mac pastes values only.
If everything lands in column A, the copied text had no tab gaps between fields, only spaces. Use Data, Text to Columns, and split on a character that always separates the parts, or split on fixed width if the columns line up.
A worked example
Here is an example of four rows as they might paste from a banking page, and the same rows after cleanup. The values are made up.
Before cleanup, straight from the paste:
| A | B | C | D |
|---|---|---|---|
| Mar 14 | CARD PURCHASE GREENLEAF MARKET | -$42.18 | |
| Pending | |||
| Mar 13 | ONLINE TRANSFER FROM SAVINGS | $500.00 | |
| Mar 12 | DIRECT DEBIT CITY WATER | -$61.40 | View details |
After cleanup:
| Date | Description | Amount | Status |
|---|---|---|---|
| 2026-03-14 | CARD PURCHASE GREENLEAF MARKET | -42.18 | Pending |
| 2026-03-13 | ONLINE TRANSFER FROM SAVINGS | 500.00 | Posted |
| 2026-03-12 | DIRECT DEBIT CITY WATER | -61.40 | Posted |
Three things changed. The "Pending" line was a label under the first row, so it moved into a Status column. The "View details" link text was deleted. The dates and amounts became real values, which the section on text cells below explains.
Loading more rows before you copy an online banking page
Most banking pages show only the latest transactions at first and add more when you ask. Before copying, set the date range you want, then press any "Show more" or "Load more" button until the oldest transaction you need is on the page. A row that has not loaded cannot be copied.
Banking sites load older rows in a few different ways:
- A date filter. Set the start and end dates first. This is the most reliable route because the site fetches exactly that period.
- A load-more button. Each press adds another batch at the bottom. Keep pressing until the list reaches your start date.
- Endless scrolling. Rows appear as you scroll down. Scroll slowly to the end and wait for the last batch to finish.
- Page numbers. The list is split into numbered pages. Copy each page in turn and paste them below one another.
Some sites only keep a limited history online, perhaps a few months, while statements go back further. If the oldest row you can load is still newer than the date you need, the web page cannot give you the full period. Use the statement PDF for the older months.
A second check before you copy: some pages draw only the rows that fit on the screen and swap them as you scroll. If a pasted list is much shorter than the one you scrolled through, the page did that. Copy screen by screen, or switch to the print preview or the download option.
Why do pasted online banking amounts and dates turn into text?
Pasted amounts and dates turn into text when they carry characters Excel does not expect: currency signs, plus signs, non-breaking spaces, a trailing "CR", or dates written as "Mar 14" with no year. Excel then stores them as words. A text amount is skipped by SUM, and a text date sorts alphabetically.
You can spot text cells because they sit on the left of the cell by default, while numbers sit on the right. Fix them column by column.
Amounts
- Remove currency signs and commas. Select the amount column, use Find and Replace, find "$" and replace with nothing. Do the same for thousands commas if Excel still treats the cell as text.
- Remove hidden spaces. Web pages often use non-breaking spaces between a sign and a number. In a spare column, use
=VALUE(SUBSTITUTE(C2,CHAR(160),"")), fill down, then paste the results back as values. - Fix the sign. If the page shows money out in a separate column or with a word such as "Debit", turn those into negative numbers so one column holds every amount.
Dates
A date without a year, such as "Mar 14", leaves Excel to guess the year, and it guesses the current one. For a list that runs back past January, that guess is wrong for the older rows. Add the year yourself, either by editing the dates or by using a formula that joins the text date and the right year, then format the column as a date.
If dates come out with day and month swapped, the cause is usually a regional setting rather than the paste. The order Excel expects follows your computer's region, so a page written for another country can be read the wrong way round.
What you lose by skipping the statement PDF
Skipping the statement PDF costs you the parts that make a record trustworthy: an opening and closing balance for a fixed period, a running balance on each line, the bank's full descriptions, and a document others accept as proof. For budgeting, the web page is often enough. For tax, lending or an audit, use the statement.
The gaps in detail:
- No proof of completeness. Without a running balance, you cannot show that no row was skipped between two copies.
- Pending items that later change. A pending card payment may post for a different amount or vanish. A statement lists only posted transactions.
- Short descriptions. The screen may trim the merchant text that the statement prints in full.
- No formal document. A lender or accountant usually wants the statement itself.
When you do go back to the PDF, it may not arrive as a plain statement. A yearly bundle can come as a PDF with separate files packed inside it; how a PDF portfolio hides files inside one PDF explains how to get them out. Some downloaded statements also carry a watermark such as "COPY" across every page, and keeping a PDF watermark out of your Excel cells shows how to stop those letters landing in your rows.
FastBankConvert is getting ready to open for exactly that PDF route: it is built to turn a statement into rows of date, description, amount and balance, and to warn you before download if the balances do not add up. Get started to join. Whichever online tool you use to tidy banking data, know how to remove it afterwards; asking a PDF converter to delete your data covers automatic deletion, account history and what backups may still hold.