How to Convert a PDF Bank Statement to Excel on a Mac

Mac users get a slightly raw deal when it comes to bank statements. The best built-in tool for pulling tables out of a PDF, Excel’s From PDF connector, is a Windows feature, and the obvious Mac shortcut, copying from Preview, usually produces a mess. You still have good options. This guide walks through each one, explains why some fail, and shows how to end up with a clean .xlsx file that opens properly in Excel or Numbers, with dates that respect your Mac’s region settings.

First, check what kind of PDF you have

Open the statement in Preview and try to select a single line of text.

  • Individual words highlight: it’s a text-based PDF, the kind most banks produce when you download an e-statement. Every method below can work.
  • Nothing highlights, or the whole page selects like a picture: it’s a scanned or photographed statement, and you’ll need OCR. See scanned bank statement to Excel.
  • Preview asks for a password: you’ll need it before anything can read the file. Our page on password-protected bank statements explains how to unlock one without sending it anywhere.

Option 1: Copy and paste from Preview

It’s free and already on your Mac, so it’s the first thing most people try.

  1. Open the PDF in Preview and make sure the Text Selection tool is active.
  2. Drag across the transaction table and press Cmd+C.
  3. Switch to Excel or Numbers, click a cell and paste, as plain text if your app offers the option.

Why the columns come out scrambled

A PDF doesn’t contain a table the way a spreadsheet does. It contains individual fragments of text placed at coordinates on the page, and the ruled lines you see are just drawings. When Preview copies a selection, it has to guess the reading order of those fragments. Typical results:

  • Everything lands in one column, because the gaps between columns are copied as spaces or line breaks rather than tabs.
  • Each value goes on its own line, so one transaction becomes four or five rows.
  • Empty cells disappear. A statement with separate Debit and Credit columns leaves one of them blank on every row. The blank isn’t copied, so after pasting you can’t tell whether 250.00 was money in or money out.
  • Multi-line descriptions split into extra rows with no date or amount.
  • Page headers and footers get mixed in on every page.

You can repair some of this with Data > Text to Columns, which exists in Excel for Mac too, but for anything longer than a page the clean-up takes longer than a proper conversion. Treat copy and paste as a way to grab a few rows, not a whole statement.

Option 2: Numbers

Apple’s Numbers is a capable spreadsheet, but it can’t open a PDF as a table, so it can’t do the conversion itself. Pasting into Numbers gives the same results as pasting into Excel. Where Numbers shines is at the end of the process: once you have an .xlsx or CSV file, it opens it without fuss (more on that below).

Option 3: Excel for Mac

On Windows, Excel for Microsoft 365 can import a PDF through Data > Get Data > From File > From PDF. At the time of writing, that PDF connector isn’t available in Excel for Mac. Microsoft has been adding Power Query features to the Mac version, so this may change, but for now there’s no built-in way to read a PDF statement in Mac Excel.

What Excel for Mac does well is everything after conversion: sorting, filtering, formulas, pivot tables and reconciling against the running balance. So the practical workflow is to convert the PDF to .xlsx with another tool, then open it in Excel.

Option 4: Adobe Acrobat

A paid Acrobat plan can export a PDF to an Excel workbook on a Mac: open the statement, choose Export PDF, pick Spreadsheet > Microsoft Excel Workbook, and save. Acrobat preserves layout faithfully, which is a mixed blessing. Amounts usually land in roughly the right place, but often alongside merged cells, header blocks and page totals mixed into the rows, so budget time for tidying. Adobe’s online PDF-to-Excel tool works by uploading the file to Adobe’s servers.

Option 5: Online uploaders vs in-browser converters

Search for “bank statement to Excel” and you’ll find dozens of websites. They fall into two groups, and the difference matters more than the interface.

  • Server-side converters upload your PDF, process it on their servers and send back a spreadsheet. Many are accurate, but your account number, address and full transaction history then sit on someone else’s infrastructure for whatever retention period their policy sets. Is it safe to upload bank statements online? covers what to check first.
  • In-browser converters send the conversion code to your browser instead, and the PDF is processed inside the Safari or Chrome tab on your Mac. Nothing is uploaded.

pdf2statement is an in-browser converter. It reads the PDF with pdf.js, uses on-device OCR compiled to WebAssembly for scanned pages, and checks each row against the statement’s running balance. It’s free, with no page limit, signup or ads. You can test the no-upload claim by loading the page, turning off Wi-Fi and converting anyway.

Step by step: convert a statement on your Mac

  1. Download the original PDF from your bank’s website rather than printing a web page to PDF. Bank-generated PDFs convert far more accurately.
  2. Open the converter in Safari or Chrome and drag one or more statements from Finder onto the page. A whole year of statements can go in at once.
  3. Enter the password if a statement is protected. It’s used locally to unlock the file and isn’t sent anywhere.
  4. Review the preview. Rows that don’t agree with the running balance, and opening or closing balances that don’t tie out, are highlighted. Click any cell to correct it.
  5. Choose your settings: a date format (YYYY-MM-DD, MM/DD/YYYY or DD/MM/YYYY) and either separate Debit and Credit columns or one signed Amount column.
  6. Export to Excel (.xlsx). Safari and Chrome save it to your Downloads folder by default. The workbook has real date cells, numeric amounts, a frozen header row and filters already switched on.

If you convert statements regularly, you can install the site as an app. In Safari on recent versions of macOS, choose File > Add to Dock; in Chrome, look for the install icon at the right-hand end of the address bar. Either way it opens in its own window and works offline after the first visit.

The bank statement to Excel page explains the export options in more detail.

Opening the .xlsx in Numbers

If Excel isn’t installed, double-clicking the file usually opens it in Numbers. If another app grabs it, Control-click the file in Finder and choose Open With > Numbers.

Numbers converts the workbook into its own format as it opens it. A few things to expect:

  • Dates and amounts come through as real dates and numbers, so sorting and sums work straight away.
  • Excel’s filter buttons may not carry over exactly. Numbers has its own sort and filter tools in the Organize sidebar.
  • Saving creates a .numbers file by default. To send the result to someone who uses Excel, choose File > Export To > Excel.

To change how dates are displayed, select the column, open the Format sidebar, click the Cell tab, set Data Format to Date & Time and pick the style you want.

Dates and your Mac’s region settings

Date problems are the most common complaint after converting a statement, and on a Mac they almost always come down to region settings.

Why .xlsx is safer than CSV

An .xlsx file can store a real date: a number that Excel and Numbers display however your region prefers. A CSV stores only text, such as 03/04/2026, and the app opening it has to guess whether that means 3 April or 4 March. It guesses using your Mac’s region. When the guess is wrong you get swapped days and months for dates up to the 12th and unconverted text for the rest, which is a particularly nasty failure because some rows look fine.

Check your Mac’s settings

On recent versions of macOS, open System Settings > General > Language & Region. The Region setting controls the default date order and number format, and recent versions may also offer a separate date format choice. A Mac set to the United States expects the month first; most other regions expect the day first.

Practical tips

  • Exporting .xlsx? Pick whichever date format you like reading. The cells are real dates either way, and you can change the display later with Format Cells (Cmd+1) in Excel or the Format sidebar in Numbers.
  • Exporting CSV? Choose the date order that matches your Mac’s region, or choose YYYY-MM-DD, which most spreadsheet apps recognise whatever the region. See bank statement to CSV for more on CSV settings.
  • Check a sample. In Excel, =ISNUMBER(A2) returns TRUE for a real date. Text dates also tend to sit at the left of the cell, while real dates align right by default.
  • Decimal commas. If your Mac uses a comma as the decimal separator, as much of Europe does, a CSV that also uses commas between fields can split amounts in two. Exporting .xlsx avoids the problem entirely.

Which option should you use?

For two or three rows, copy from Preview and tidy up by hand. If you already pay for Acrobat, its export is worth a try. For whole statements, multi-month batches or anything you’d rather not upload, convert in your browser and open the .xlsx in Excel or Numbers.

If you sometimes need to do this away from your desk, see our guide to converting a bank statement on iPhone or Android. For a comparison of methods across all platforms, read how to convert a PDF bank statement to Excel.

FAQ

Frequently asked questions

Can Excel for Mac import a PDF bank statement directly?

Not at the time of writing. The Get Data > From PDF connector is a feature of Excel for Microsoft 365 on Windows, and Excel for Mac doesn't include it. On a Mac you need to copy and paste, export from Acrobat, or convert the PDF to .xlsx or CSV with a converter first. Excel for Mac opens those files normally.

Can Apple Numbers convert a PDF to a spreadsheet?

No. Numbers can't open a PDF as a table. It opens .xlsx and CSV files well, though, so convert the statement first and then open the result in Numbers. Pasting text copied from Preview into Numbers runs into the same column problems as pasting into Excel.

Why are the dates wrong when I open a converted CSV on my Mac?

A CSV stores dates as plain text, and Excel and Numbers read that text using your Mac's region settings. If the file says 03/04/2026 and your Mac expects the day first, you get 3 April instead of 4 March. Export in your Mac's date order, use the unambiguous YYYY-MM-DD format, or export .xlsx, which stores real dates.

Does pdf2statement work in Safari on a Mac?

Yes. It runs in current versions of Safari, Chrome, Edge and Firefox on macOS. The conversion happens inside the browser tab, so the PDF stays on your Mac, and after the first visit it also works without an internet connection.