If you switched from Windows or just bought a MacBook, the first surprise is that Excel for Mac cannot open a PDF the way the Windows version can. There is no Data > Get Data > From PDF button on macOS, even with a paid Microsoft 365 subscription. So the usual advice you find online simply does not apply, and you end up copying numbers by hand or staring at a single column of mashed-together text. This guide walks through every reliable way to convert a PDF to Excel on a Mac, what each method costs you in time, and how to handle scanned statements that the free tricks cannot touch.
The fastest route is the converter at the top of this page: it runs in your browser, so it works the same on a MacBook Air, a MacBook Pro, an iMac, or a Mac Studio, with no install and no Windows machine required. Upload the PDF, get a clean .xlsx with the rows and columns intact, and the numbers come back as real numbers you can sum. Below are the manual options too, so you can pick the one that fits the document.
Why can't Excel for Mac open a PDF directly?
Excel for Mac has no native PDF import feature. The From PDF connector that converts a PDF to a table lives only in Excel for Windows and is missing from the Mac build, even on Microsoft 365, which is why Mac users have to use a converter, Numbers, or copy and paste instead. Apple's own Preview and Numbers apps can help, but only with clean, native-text tables. For anything scanned or complex you need a real converter with OCR.
How do I convert a PDF to Excel on a Mac for free?
The free built-in path on a Mac is to open the PDF in Preview, select the table, copy it, and paste it into Apple Numbers, then export that sheet to Excel format with File > Export To > Excel. It keeps your data off the internet and costs nothing, but it is manual: pasted tables often land in one column, dates and amounts arrive as text, and it does not work on scanned PDFs. For one short table it is fine. For monthly statements it gets tedious fast.
If you want to stay inside Apple's apps, here is the full sequence:
- Open the PDF in Preview (double-click it on a Mac and Preview is the default).
- Drag to select the table text, then press Command+C to copy.
- Open Numbers, click a cell, and press Command+V to paste.
- Use the column divider handles or Table > Split into columns to fix any data that landed in a single column.
- Retype any dates or amounts that came in as text so formulas work.
- Choose File > Export To > Excel to save a .xlsx you can open anywhere.
Can I convert a PDF to Excel using Preview on Mac?
Preview can copy text out of a native PDF, but it cannot convert a PDF to Excel on its own. Preview has no spreadsheet output, so the most it does is let you select and copy table text, which you then paste into Numbers or Excel for Mac. Preview also cannot read scanned or image-only PDFs, because there is no live text to select. For those you need optical character recognition, which Preview does not have.
Does Excel for Mac have a Get Data From PDF option?
No. Excel for Mac does not include the Get Data > From PDF connector that Excel for Windows has, and Microsoft has not added it to the Mac version as of 2026. This is the single biggest reason Windows tutorials fail on a Mac. Your working options are an online converter, Apple Numbers as a middle step, or copy and paste, none of which depend on that missing button.
How do I convert a scanned PDF to Excel on a Mac?
A scanned PDF is an image, so copy and paste and Numbers cannot read it; you need a converter with built-in OCR. Upload the scanned file to a tool that runs optical character recognition, and it reads the printed numbers off the image and rebuilds them as spreadsheet cells. The converter on this page does this automatically, which is the main thing the free Mac tricks cannot do. If your bank or brokerage statement is a scan rather than a downloaded native PDF, this is the only path that will not have you typing every figure by hand. See our guide on converting a scanned PDF to an editable Excel file for the details.
How do I keep the columns and numbers correct when converting on a Mac?
Use a converter that detects the table grid instead of copy and paste, so each value lands in its own cell as a real number. The grid problem is the same on every platform: a PDF stores text positions, not an actual table, so pasting dumps everything into one column. A proper converter reconstructs the columns and keeps amounts numeric, including negatives in parentheses, so totals and SUM formulas work right away. If you do paste manually, expect to run a text-to-columns cleanup and to fix numbers that arrive as text and dates stored as text afterward.
Can I convert a PDF to Excel on an iPhone or iPad too?
Yes. Because a browser converter does the work on the server, you can do it from Safari on an iPhone or iPad the same way you would on a Mac: open the page, upload the PDF from Files or iCloud, and download the Excel file. There is no app to install. This is handy when a statement arrives by email on your phone and you want it in a spreadsheet before you get back to your desk.
What is the fastest way to convert a PDF to Excel on a Mac?
The fastest way is a browser-based converter: upload the PDF, download a clean .xlsx, and skip the manual cleanup entirely. The Preview-to-Numbers route is free but slow and breaks on scans, and Excel for Mac cannot import a PDF at all. For accountants, bookkeepers, and finance teams on Mac who do this monthly across many documents, the converter on this page plus batch conversion turns a half-day of retyping into a few minutes. If you work mostly with statements, our PDF to Excel for accountants page covers the full workflow.
A quick checklist for Mac users
- Native PDF, one small table: Preview to Numbers, then export to Excel.
- Native PDF, many pages or you want numbers correct: use the converter on this page.
- Scanned PDF or photo of a statement: you need OCR, so use the converter, not copy and paste.
- On the go: Safari on iPhone or iPad works the same as on the Mac.
Mac users have lived without a one-click PDF import in Excel for years, but you do not have to retype anything. Pick the method that matches your document, lean on the converter for scans and volume, and keep your spreadsheets accurate from the first paste. If your converted data is headed for accounting software next, a Mac user can take a bank statement straight to QuickBooks Online with a bank statement to QuickBooks converter, or digitize receipts for the books with receipt OCR once the spreadsheet is in hand.