How to Convert a Bank Statement to Excel on a Mac

Short answer: To convert a bank statement to Excel on a Mac, upload the PDF to a bank statement converter, then download an XLSX or CSV file and open it in Excel for Mac or Apple Numbers. This extra step exists because Excel for Mac does not include the Power Query PDF connector, so the Data, Get Data, From PDF path that Windows users rely on is not available on macOS, and Numbers cannot open a PDF at all. Converting the PDF first is the only method on a Mac that keeps every transaction in its own row with the date, description, amount, and running balance in separate columns.

Why you cannot import a PDF into Excel for Mac directly

The PDF import feature in Excel is powered by Power Query, and Microsoft ships the PDF connector only in Excel for Windows on a Microsoft 365 subscription. Excel for Mac does not list PDF as a supported data source, and that has stayed true through 2026 with no announced change. So when a Mac user follows a Windows tutorial and looks for Data, then Get Data, then From File, then From PDF, the option simply is not there. Apple Numbers has the same gap from the other direction: it opens CSV, XLSX, and its own format, but it cannot read a PDF table.

That leaves Mac users with a few real options, and most of them break on the exact statements that matter. Here is how they compare.

How do I convert a bank statement to Excel on a Mac?

Convert the statement to a spreadsheet before you open it. Upload the PDF to a bank statement converter, which reads the transaction table (including scanned and password protected statements), and download an Excel or CSV file. Then double click the downloaded file and it opens straight into Excel for Mac or Numbers, already split into date, description, debit, credit, and running balance columns. There is no Windows machine, no virtual desktop, and no manual cleanup involved. If you want the transactions grouped as they land, the transaction categorization step assigns an income or expense category during the conversion.

The workflow is the same whether you are on an Intel Mac or Apple silicon, and it does not depend on which version of Excel for Mac you run, because the conversion happens before Excel is ever involved. For a step by step walkthrough of the output, the PDF bank statement to Excel converter page shows exactly what the columns look like.

Should I use Excel for Mac or Numbers?

Use whichever you already work in, because the converted file opens cleanly in both. Excel for Mac is the better choice if your accountant or your firm standardizes on XLSX, if you rely on pivot tables, or if you trade files with Windows colleagues. Numbers is fine for a quick personal review and it is free on every Mac, but sharing a Numbers file with a Windows user means exporting back to Excel first, so most bookkeeping work stays in XLSX. If you would rather keep everything in the browser and share a live link, you can also send the data to Google Sheets instead.

Can Excel for Mac import a PDF?

No. Excel for Mac cannot import a PDF because it does not include the Power Query PDF connector, which Microsoft provides only in Excel for Windows. There is no macOS setting or Microsoft 365 add on that enables it, so the practical answer is to convert the PDF to XLSX or CSV outside Excel and then open that file. This is a platform limitation, not a licensing one, so upgrading your Microsoft 365 plan will not add the feature on a Mac.

Can Apple Numbers open a PDF bank statement?

No. Numbers can open CSV, Excel, and Numbers files, but it cannot open or import a PDF. If you drag a PDF onto Numbers, nothing usable happens. Convert the statement to CSV or XLSX first, and then Numbers reads it as a normal spreadsheet with each transaction on its own row.

Can I convert a bank statement to Excel on an iPhone or iPad?

Yes. Because the conversion runs in the browser, you can upload the PDF from Safari on an iPhone or iPad and download the spreadsheet to Files, then open it in Excel or Numbers on the same device. This is handy when the statement arrives as an email attachment on your phone and you do not want to move it to a computer first.

What about scanned or password protected statements?

Scanned statements are exactly where the copy and paste and Get Data routes fail, because there is no selectable text to grab. A converter that reads the image handles those, and it also opens password protected PDFs once you enter the password. Many banks deliver statements as encrypted files, so this matters more than it first seems. The end result on a Mac is the same clean spreadsheet you would get from a text based PDF.

The bottom line for Mac users

The Get Data from PDF trick that Windows tutorials show does not exist in Excel for Mac, and Numbers cannot read a PDF either, so the dependable path on macOS is to convert the statement to XLSX or CSV first and then open it in whichever app you prefer. It takes under a minute per statement, keeps the running balance that copy and paste destroys, and works on scanned files. When the document you need in a spreadsheet is a general business PDF rather than a bank statement, a broader PDF to Excel converter covers invoices, reports, and other tables the same way.