How to Convert Scanned Bank Statements to Excel

There are two very different kinds of PDF bank statements. Digital statements, downloaded from online banking, contain a real text layer — you can highlight and copy the words. Scanned statements are photographs of paper: to a computer they're just pixels, with no text in them at all. The quickest test: open the PDF and try to select a line of text with your mouse. If you can't, you have a scan, and no text-based converter — including ours — can read it directly. It first needs OCR (optical character recognition), which turns the picture of text back into actual text.

First, try to avoid OCR entirely

OCR is always the lossy, error-prone route, so check the alternatives before committing to it. Most banks keep several years of digital statements in online banking — if the period you need is there, download the digital PDF and skip OCR completely. If it's not, many banks will regenerate older statements on request, sometimes for a small fee. Ten minutes with your bank's support chat often beats an hour of OCR cleanup.

Free OCR option 1: Google Drive

1. Upload the scanned PDF to Google Drive.
2. Right-click it → Open with → Google Docs. Google runs OCR automatically and opens a document with the recognized text below an image of each page.
3. Check the recognized text against the original — numbers are where OCR errors hide.
4. Either copy the transaction lines into a spreadsheet directly, or download the Docs file as PDF and run it through our statement converter.

One important caveat, given what this site stands for: uploading a statement to Google Drive is still uploading it to a server. Google's terms are clearer than a random converter site's, but if that trade bothers you, use the offline option below instead.

Free OCR option 2: offline, on your own machine

Windows: Microsoft OneNote (included with Office) can OCR images — paste a screenshot of a statement page into a note, right-click the image, and choose "Copy Text from Picture." macOS: select text directly inside photos and PDFs in Preview on recent versions, or use the free app TextSniper. Both keep the document entirely on your computer, which matches how our converters work.

Expect cleanup — and know when it's not worth it

Even good OCR misreads characters that matter on statements: 0 versus O, 1 versus l, 5 versus S, and misplaced decimal points. After any OCR pass, reconcile the extracted transactions against the statement totals before trusting them — if the debits and credits don't sum to the closing balance, hunt down the misread digits. For a page or two this is fine; for fifty pages of scans, weigh whether requesting digital statements from your bank is simply faster.

Once you have real text

After OCR produces a text-based PDF, the normal workflow applies: drop it into the free statement converter to get Excel or CSV, then follow our QuickBooks import guide if the destination is accounting software.