Bank Statement PDF Won't Paste into Excel? How to Fix the Columns

Last updated July 2026.

When you copy a bank statement out of a PDF and paste it into Excel, the whole block usually lands in a single column, the amounts come in as text that will not add up, and multi line descriptions push transactions out of alignment. That happens because a PDF stores text by its position on a printed page, not in rows and columns, so Excel has no grid to drop the data into. You can repair it with Text to Columns and a couple of formulas, but the cleanup gets slow on a long statement. Below are the reasons it breaks and three fixes, from the manual repair to the one that skips the problem entirely.

Why won't a bank statement PDF paste into Excel correctly?

A bank statement is a printed layout, not a spreadsheet, so pasting it into Excel loses the structure four ways. First, the date, description, and amount collapse into one cell per line because the PDF has no column boundaries. Second, amounts arrive as text with stray dollar signs and commas, so SUM returns zero. Third, a description that wraps onto a second line breaks a single transaction into two rows. Fourth, repeated page headers, footers, and the running balance scatter through the data instead of sitting in a tidy column. Each of these is fixable, but together they are why a plain paste never just works.

Fix 1: split one column with Text to Columns

If your pasted data landed in one column but the fields are separated by spaces or tabs, Text to Columns can break it apart. Select the column, go to the Data tab, click Text to Columns, choose Delimited, and tick Space or Tab as the delimiter. This works best when every transaction has the same shape. It falls apart when descriptions contain spaces of their own, because Excel treats each space as a new column and a two word merchant name splits into two fields. On a real statement you usually end up nudging rows back into place by hand.

Fix 2: turn text amounts back into numbers

Numbers pasted from a PDF are often stored as text, which is why Excel will not total them. Select the amount column and look for the small green triangle in the corner of each cell, then use the warning menu to Convert to Number. If that does not appear, put =VALUE(CLEAN(SUBSTITUTE(A2,"$",""))) in a helper column to strip the dollar sign and force a real number, then paste the result back as values. Do the same for the date column with DATEVALUE if your dates refuse to sort. Once the amounts are true numbers, SUM and pivot tables work again.

Fix 3: clean out the repeated headers

Multi page statements repeat the bank name, page number, and column titles on every page, and those rows land in the middle of your data after a paste. Sort the sheet by the amount column so the non transaction rows group together, delete them, then sort back by date. Watch for the opening and closing balance lines, which you want to keep as reference but not count as transactions. This step is quick on a two page statement and tedious on a twenty page one, which is the point where most people stop pasting and start converting.

Which Excel paste option actually helps?

People often assume there is a hidden paste setting that fixes the columns. There is not, but the option you pick does change how much cleanup you face. When you copy from a PDF reader and paste into Excel, try right clicking the target cell and reviewing the Paste Special choices before you commit. Here is what each one does with statement text.

The pattern is clear: the best paste option only reduces the cleanup, it never removes it, because none of them can invent the column boundaries the PDF never had. That is the ceiling on any paste based approach.

The reliable fix: convert the PDF instead of pasting

Every fix above is a workaround for the same root problem: a paste throws away the table structure, and you rebuild it by hand. A converter reads the transaction table straight from the PDF and writes each field into its own column, so you never paste at all. Upload the statement to a bank statement PDF to Excel converter and you get back a clean workbook with date, description, debit, credit, and running balance columns, amounts already stored as real numbers, and every page stitched into one sheet. It also reads scanned statements and phone photos, which cannot be copied at all. For a single clean page the manual fixes are fine; past that, converting is faster and less error prone.

What to do once the columns are clean

With the statement sitting in proper columns, format the range as a table, total the debit and credit columns, and confirm your ending figure matches the balance on the statement. From there you can sort by vendor, tag each line, or push the data into your books. Our guide on how to categorize transactions from a bank statement covers a repeatable way to sort each line into income and expense buckets, and if your books live in QuickBooks you can skip the spreadsheet and send the statement straight through a QuickBooks statement converter. Either way, the goal is the same: stop retyping and paste less, not more.