To copy transactions from online banking to Excel, open the account's activity page in a browser, show the date range you need, drag to select the transaction list, copy it, and paste into a blank sheet as plain text. Then delete the icons and status columns, split any merged cells, and turn text amounts into numbers.
Should you copy online banking transactions or download a CSV?
Look for a download button before you copy anything. Many online banking sites offer an export of the activity list as a CSV or spreadsheet file, which gives clean columns with no cleanup. Copying from the page is the fallback when there is no export, when it is broken, or when you need only a few rows.
The export is usually on the account's activity or transactions page, under a name such as Download, Export or a small arrow icon. It often asks for a date range and a file type. If it offers CSV, take it: a CSV opens straight in Excel with one column per field.
Copying from the page still has a place:
- No export exists. Some smaller banks and credit unions show activity online but offer only PDF statements.
- The export misbehaves. It may give a format your spreadsheet cannot read, or cap the date range.
- You need a handful of rows. Selecting six lines is quicker than downloading a file and deleting most of it.
- The rows you want are recent. Activity pages show transactions days or weeks before they appear on a monthly statement.
The rest of this post assumes you are copying. Before you start, set the activity page to show the full date range you need on one screen if the site allows it, because paged lists are the commonest cause of missing rows.
Selecting the online banking activity list in a browser
Select the activity list by clicking just before the first transaction's date and dragging down to the last transaction's amount or balance. Selecting from inside the list, not from the page header, keeps navigation menus and account summaries out of the paste. On a long list, click at the start, scroll, then Shift-click at the end.
The Shift-click method is the one to learn. Dragging past the bottom of the window makes the browser scroll at its own pace, and it is easy to overshoot into the footer or stop a row short.
The steps
- Open the account's activity page and set the date range.
- Expand the list so every transaction shows, using any "show more" or "load all" control.
- Click once just to the left of the first date.
- Scroll to the last transaction you need.
- Hold Shift and click just after its last figure.
- Press Ctrl+C, or Cmd+C on a Mac.
If clicking inside the list opens a transaction's details instead of placing the cursor, start your selection in the empty space just above the first row. Some sites draw each transaction as a clickable card, and a click on the card itself opens it.
Check the selection before you copy. The highlight should start at a date and end at an amount. If it includes a search box, filter buttons or a running summary at the top, start again a little lower.
Pasting online banking activity into Excel as clean rows
Paste online banking activity as plain text, not as web content, so that links, icons, fonts and hidden page elements stay behind. In Excel, use Paste Special and choose Text or Unicode Text. In Google Sheets, use Paste values only. Each transaction should then arrive on its own row.
A normal paste brings the page's formatting with it. Rows can arrive with images of the bank's logo, coloured cells, links on every description, and merged cells that break sorting. Plain text strips all of that.
What to expect after the paste
Pasted activity lists come out in one of three shapes, depending on how the bank built the page:
- One row per transaction, one column per field. The page used a proper table. You are nearly done.
- One row per transaction, everything in column A. The page used a layout without table cells. Split it with Text to Columns, choosing Delimited and Tab first, since many pages separate fields with tabs even when they look like spaces.
- Several rows per transaction. The page showed each transaction as a card, with the date on one line, the payee on the next and the amount on a third. This needs restacking, covered below.
Restacking card layouts
If every transaction takes exactly three rows, a formula can line them up. In a new sheet, put this in A1 and copy it across three columns and down:
=INDEX(Sheet1!$A:$A,(ROW()-1)*3+COLUMN())
Each row of the new sheet then reads three cells from the paste: date, payee and amount. If some transactions take four rows because they show an extra note, the pattern breaks, and you will have to fix those few rows by hand.
Fixing the extra columns online banking pages add
Online banking pages add columns a spreadsheet does not need: icons, status labels, categories the bank guessed, and "view details" links. Delete those after the paste, and split any column that holds two fields. Keep date, description, amount and balance, and any reference number you rely on for matching.
Here is an example of what a pasted activity list might contain and what to do with each column. The column names vary from bank to bank.
| Pasted column (example) | Example content | What to do |
|---|---|---|
| Icon or logo | (blank, or an image name) | Delete |
| Date | Mar 14, 2026 | Keep, convert to a real date |
| Description | CORNER GROCER #212 Debit card purchase | Keep, optionally split the type off |
| Category | Groceries | Keep only if you trust it |
| Status | Posted | Use to filter, then delete |
| Amount | -$64.18 | Keep, convert to a number |
| Balance | $2,315.40 | Keep for checking |
| Action link | View details | Delete |
Dates that arrive as text
A date such as "Mar 14, 2026" may land as text. Test one by changing its format to a number: a real date turns into a serial number, text stays as it was. To convert a text column, select it, open Data, Text to Columns, step through to the last page, choose Date with the order your bank uses, and finish.
Descriptions with the transaction type attached
Some banks append the transaction type to the payee, as in "Debit card purchase" in the example. If you sort by payee, those suffixes get in the way. Find and Replace can remove a fixed suffix across the whole column in one pass.
Why do pasted online banking amounts not add up?
Pasted amounts fail to add up for three reasons: they came across as text, the signs are not what you expect, or the list mixes pending and posted rows. Each one gives a wrong SUM that looks plausible. Fix the format first, then the signs, then the pending rows, and check against the page's balance.
Text amounts. A dollar sign, a minus sign in the wrong place, or a non-breaking space from the web page can make Excel treat an amount as text, and SUM skips text. Select the amount column, then use Find and Replace to remove the dollar sign. If the numbers still sit to the left of their cells, use Data, Text to Columns, Finish on that column, which forces Excel to read the cell again.
Sign conventions. Some pages show debits as negative numbers, some show them in red with no sign, and some use separate money-in and money-out columns. Red text loses its meaning in a plain-text paste, so a page that relied on colour gives you all positive numbers. Compare a few rows with the page and fix the signs before you trust a total.
Pending items. Pending transactions can appear at the top of the list and later change amount, change date or vanish. Including them makes your total disagree with the posted balance.
The balance check
Take the balance shown after the oldest transaction you copied, add every signed amount after it, and compare the result with the latest posted balance on the page. If they match, the copy is complete. A gap equal to one amount means a row was missed. Other gaps usually come from sign errors.
Copying is not the only way to get these rows wrong. Typing them introduces its own errors, and double key data entry explains how firms catch typing errors by entering the same data twice and comparing.
Online banking copy edge case: pending items and paged lists
Pending items and paged lists are the two traps that make a copied activity list incomplete or temporary. Pending rows can change after you copy them, and a list split across pages silently drops whatever is on the pages you did not open. Filter out pending rows and make sure the whole date range is on screen.
Pending rows
A pending transaction is one the bank has seen but not yet settled. Card purchases at restaurants and fuel stations often show a first amount and settle at a different one, for example after a tip is added. If you copy the pending amount, your sheet will disagree with next month's statement.
Treat pending rows as not yet real. Either leave them out of the copy, or keep the status column long enough to filter them out, then delete it. Copy them again in a few days, once they have posted.
Paged and lazy-loading lists
Some activity pages show 25 or 50 rows, then a "next page" button. Others load more rows only as you scroll. Either way, a single copy captures only what has loaded. Signs that a copy is incomplete:
- The oldest date in the paste is later than the start of the range you set.
- The balance check is off by a large amount, not a single row.
- The row count is a round number such as 25 or 50.
The fix is to load everything before selecting, or to copy each page in turn and paste each below the last, then sort by date and remove any duplicate rows at the joins.
When copying from online banking is not an option
Copying fails when the rows are no longer online. Banks show a limited history on the activity page, and once an account is closed, online access to it usually ends. In both cases the only record is the statement, which arrives as a PDF or on paper, and the job becomes copying or converting a statement instead.
For older history on an open account, the statements section of online banking usually goes back further than the activity page. Download the PDFs for the months you need. For a closed account, you may need to ask the bank, and getting bank statements from a closed account covers how to request them.
Once you have the PDFs, two free routes remain. You can copy the text out of the PDF and repair the paste, following how to copy a PDF into Excel and fix the paste. Or you can type the rows, which takes longest. If the volume is large, paying someone is a third route, and the cost of hiring a data entry clerk puts numbers on it.
For a text-based PDF statement, a converter gives the same columns this post builds by hand: date, description, amount and balance. CheapBankConvert is in early access and plans to charge per statement with a free two-page preview, as listed on the homepage. Whichever route you take, finish with a running balance check, since it works on rows from any source.