Sortlumo
Back to blog
How-to··8 min read

How to convert a bank statement PDF to Excel (3 ways)

Three ways to turn a bank statement PDF into a clean Excel spreadsheet — copy-paste, Excel's own import, and automatic parsing — with the tradeoffs of each and how to keep your data private.

A bank statement PDF is easy to read and impossible to work with. The moment you want to total your spending, filter by merchant, or hand the numbers to a spreadsheet, the PDF fights you. This guide covers the three realistic ways to convert a bank statement PDF to Excel — from fully manual to fully automatic — and the tradeoff each one asks you to make.

Method 1: Copy and paste (free, tedious, error-prone)

The zero-tools approach: open the PDF, select the transaction table, copy, and paste into Excel. It sometimes works for a single short statement.

  1. Open the PDF and select the transaction rows. Drag to highlight just the date/description/amount table, not the header or marketing footer.
  2. Paste into Excel. Use Paste Special → Text to avoid importing formatting garbage.
  3. Split the columns.Everything usually lands in one column, so you'll need Data → Text to Columns to break out date, description, and amount.
  4. Fix the wrecked rows by hand. Multi-line descriptions, wrapped merchants, and negative amounts in parentheses all break the alignment.
Copy-paste breaks down fast on real statements. Most bank PDFs use absolute text positioning, so a clean-looking table often pastes as a jumbled single column with amounts detached from their descriptions. Fine for 10 rows; miserable for 200.

Method 2: Excel's built-in PDF import (Power Query)

Modern Excel (Microsoft 365) can import a PDF directly through Power Query, which is a real step up from copy-paste.

  1. Go to Data → Get Data → From File → From PDF and pick your statement.
  2. In the Navigator, choose the table Power Query detected for the transaction pages. Statements often split across several tables — one per page.
  3. Click Transform Data to clean it: remove header rows, set data types, and append the per-page tables into one.
  4. Load the result into a worksheet.

This is the best free option if you already have Microsoft 365 and don't mind learning Power Query. Its weaknesses: it only detects tables it can see (scanned or oddly-formatted statements defeat it), it does nothing to clean up cryptic merchant names, and you get raw rows — no categories, no subscription detection, no merging across months.

Method 3: Automatic parsing (fastest, and it categorizes)

A purpose-built converter reads the statement structure for you and returns a clean table in seconds. This is what Sortlumo does: you drop in the PDF and it extracts every transaction, normalizes the merchant, assigns a category, and lets you export straight to Excel.

  • No column-splitting. Date, description, merchant, amount, and running balance come out already separated.
  • Merchants are readable. SQ*TARTINE becomes Tartine Bakery; AMZN MKTP US becomes Amazon.
  • Categories are applied. Every row lands in one of 22 spending categories, consistently across statements.
  • Months merge. Upload a year of statements and export one chronological spreadsheet.

There are step-by-step download guides for the big issuers — Chase, Bank of America, American Express, and more on the converter page.

Which method should you use?

  • One statement, one time → Copy-paste, or Power Query if you have 365.
  • Recurring, and you want it clean → An automatic converter. The time saved on the second statement already pays for it.
  • You want spending insight, not just rows → A converter that categorizes and detects subscriptions, so the spreadsheet answers questions instead of just holding data.

A note on privacy

Plenty of free "PDF to Excel" websites will happily accept your bank statement — and you've just uploaded every transaction to an anonymous server. Before you paste a statement anywhere, check where the file goes. Sortlumo never asks you to link a bank account; your PDF stays encrypted in your account and is deletable at any time. That's the whole reason to prefer a tool built for financial documents over a generic converter.