How to convert a PDF bank statement to Excel

By Kayabyte · Last updated 28 October 2026

You want your bank statement in a spreadsheet so you can sort it, filter it, total a category, or hand it to someone who works in Excel. A PDF looks like a table, but underneath it is just text placed at coordinates on a page, so Excel does not see rows and columns. This guide covers the manual routes, where each one breaks, and a faster way that also checks the numbers.

1. Download the data from your bank

Start here, because it avoids conversion altogether. Most banks let you download transactions from online banking as CSV or sometimes Excel. The exact labels vary by bank, but look for Export or Download on the transactions page.

Open a CSV in Excel by choosing File, Open, or by dragging it onto the app. If the columns all land in one cell, use Text to Columns on the Data tab and pick the comma as the separator. If dates look wrong, import the date column as text first and convert it yourself.

The limit: banks often keep downloadable data for a shorter time than PDF statements, and may cap the range or number of rows per download.

2. Copy from the PDF into a sheet

Open the PDF in Preview, select the table with your mouse and copy.
Paste into a blank Excel sheet.
If all the text sits in column A, use Text to Columns (Data tab). Try Tab as the delimiter first, then Space if needed. Choosing a fixed width sometimes works better when the columns are neatly aligned.
Delete header and footer rows that repeat on each page.

Common problems:

A description with several words splits across columns and pushes amounts out of line.
Descriptions that wrap onto a second line create a row with no date and no amount.
Excel turns some descriptions or reference numbers into dates or scientific notation (a long number like 1234567890123 can become 1.23E+12). Format the column as Text before pasting.
Amounts with a comma as the decimal separator (1.234,56, common in Europe) are read as text or as the wrong number if your Mac is set to a US format.
Minus signs, trailing minus (45.00-) and “DR”/“CR” markers need converting to real positive and negative numbers.

3. Excel’s own PDF import

Some versions of Excel include a Get Data option for PDF files on the Data tab; availability and labels vary by version and platform. If yours has it, you choose the PDF, pick the tables it detects, and load them. It is a real improvement over pasting for clean, text-based statements. You still need to stack tables from several pages, deal with wrapped rows, and fix dates and signs. It cannot read a scan or a photo of a statement.

4. Where Balanced helps

Balanced is a Mac app we make. You open the statement and it builds the table; you review it in a preview; then you export an Excel file (.xlsx) with real dates and real numbers, not text.

Works with text PDFs of any length, scanned PDFs and images (read with Apple’s on-device text recognition), and CSV or TSV files.
Wrapped description lines are kept with their transaction, and page headers and footers are not mixed in.
Column headers and month names are understood in English, Norwegian, Swedish, Danish, German, Dutch, French, Spanish, Italian and Portuguese, so European number and date formats are handled.
In the preview you can reassign columns (date, description, debit, credit, amount, balance), flip day/month versus month/day, and change sign handling if a number came out with the wrong sign. It remembers each bank’s layout for next time.
It checks opening balance plus transactions against the closing balance, and the running balance row by row where the statement has one. If something is off, it names the rows and the difference, and you must choose “Export anyway” to continue.
No AI guessing: every number is copied from your statement and checked.
Statements are processed on your Mac and never leave it.

Download Balanced and convert for free: the free version converts and checks everything, and exports the first 10 transactions per file so you can open the result in Excel and judge it. Pro is USD 59 per year or USD 7.99 per month, for up to 3 Macs, cancel anytime, with a 30-day money-back on the first payment. See pricing.

What to expect

Balanced reads layouts, not magic: results depend on how your statement is built, so look at the preview each time for a new bank. It cannot promise every bank, and badly skewed or low-quality scans can fail. If the PDF is password-protected, unlock the PDF first with the password from your bank. It requires macOS 14 or later and runs on Apple silicon and Intel.