Your bank hands you statements as PDFs, but you need the numbers in a spreadsheet. On a Mac, the built-in apps feel like they should handle this. In practice, Preview and Numbers were not built to pull a clean table out of a statement PDF. Here is what actually works, what does not, and how to get a usable Excel file without installing anything.
Why Preview and Numbers struggle
Preview is a PDF viewer. You can open a statement, select text, and copy it. The problem is that a PDF stores text as positioned characters, not as rows and columns. When you paste that text into Numbers or Excel, the date, description, amount, and balance often land in one cell or spill across the sheet in the wrong order. Multi-line descriptions make it worse. You end up with a wall of text that needs heavy cleanup.
Numbers has no direct "import table from PDF" feature either. It imports CSV, XLSX, and older Numbers files. A PDF is none of those. So the file type your bank gives you and the file types Numbers accepts do not overlap.
There is one more limit worth knowing up front. If your statement is a scanned image (a photo of paper saved as a PDF), there is no selectable text at all. Copy and paste gives you nothing. That kind of file needs optical character recognition (OCR) first, which is a separate step.
Option 1: Copy and paste by hand
This works, and it costs nothing, but it is slow.
- Open the PDF in Preview.
- Drag to select the transaction rows.
- Copy, then paste into Numbers or Excel.
- Manually split the pasted text into Date, Description, Amount, and Balance columns.
- Fix every row where the paste misaligned.
For a single month with a few transactions, this is fine. For a full year, or several accounts, the manual cleanup takes longer than the rest of your task combined. Errors also creep in when you are retyping amounts, which defeats the point of working in a spreadsheet.
Option 2: Numbers import (unreliable for statements)
Some people try to convert the PDF to a Word or CSV file first using an online tool, then open that in Numbers. This sometimes produces a table, but the results depend entirely on how the original PDF was laid out. Banks use different column spacing, running balances, and wrapped descriptions. A converter that guesses at a generic table structure tends to break on these details. You still spend time re-splitting columns and checking totals. It is not reliable enough to trust without a full manual review.
Option 3: An in-browser converter (no install)
A purpose-built converter reads the statement layout and maps it to real columns. ConvertFin does this in your web browser, so it runs the same way in Safari or Chrome on macOS with nothing to download. You open the site, choose your PDF, and it produces an Excel (.xlsx) or CSV file with four columns: Date, Description, Amount, and Balance.
The part that matters most on a personal machine is where the data goes. ConvertFin runs entirely client-side using pdf.js. Your statement is read inside your own browser and is never uploaded to a server. You can read more about how that works on the security page. For a financial document, keeping the file on your own device removes the main reason people hesitate with online converters.
It reads the PDF layout rather than relying on a fixed template per bank, so it handles Chase, Bank of America, Wells Fargo, Capital One, and hundreds of others. You can check the supported banks list or look at real sample outputs before you try your own file.
One honest caveat: it only works on PDFs that contain real, selectable text. If your file is a scan or a screenshot, there is no text to read, and you will need to run OCR on it first.
Step by step on your Mac
- Download your statement from your bank as a PDF. Most "Download" or "Statements" pages already give you a text-based PDF.
- Confirm it has real text. Open it in Preview and try to select a line of text. If your cursor highlights individual words, you are set. If nothing selects, it is a scan.
- Open the converter in Safari or Chrome.
- Choose your PDF. It is processed locally in the browser.
- Pick your output. Choose Excel for .xlsx or CSV if you plan to import into another tool.
- Open the downloaded file in Numbers or Excel and review the totals against the statement.
Which option to pick
For one short statement, manual copy and paste is acceptable. For anything larger, or when you value your time and your privacy, a browser converter is faster and cleaner. Start with your own file at ConvertFin, check the numbers, and keep the spreadsheet you actually needed.