Why your bank statement PDF won't paste into Excel (and how to fix it)

You select the statement, copy, paste into Excel — and get a mess: everything in column A, amounts glued to descriptions, some rows split in two. It is not you. It is how PDFs work.

The technical reason

A PDF stores text as positioned fragments on a page, not as a table with rows and columns. The columns you see are an illusion created by coordinates. When you copy, you get the text in reading order with the visual structure stripped — so Excel has no columns to rebuild.

What does not reliably work

• Copy-paste: collapses everything into one column.
• "Export to Excel" in a PDF reader: often keeps the visual mess.
• Generic OCR: better, but drops or merges rows on multi-column and multi-page layouts.

What works

You need a tool that knows bank-statement structure: where the date, description and amount columns sit for a given bank, how to handle wrapped descriptions and page breaks, and how to verify nothing was lost against the printed balance. That is what a dedicated converter does — bankpdf supports 80+ banks and exports clean Excel/CSV, free for the first few statements.