How to Convert PDF to Excel on Mac: Every Method, Matched to Your PDF
PDF to Excel is one of the most searched conversions on the internet, and most of the results are the same thing: upload your file to a website and download a spreadsheet. That works, but it is not the only way, and on a Mac it is often not the best one. This guide is the starting point for the whole topic. It helps you identify your PDF, pick the right method, and check that the numbers survived.
Quick answer: First find out whether the PDF has selectable text (press ⌘F in Preview and search for a word in the table). If it does, copy the table into Excel and clean it, or extract it with the free Tabula tool. If it is an image or a scan, use Data From Picture or OCR. Whatever you choose, compare your totals with the printed ones. Converting a PDF never produces formulas, only values.
Why PDF to Excel is harder than it sounds
A PDF stores where each character sits on a page. It has no concept of rows, columns or cells. Every converter, free or paid, has to guess the table structure from the positions of the text. On a clean table with ruling lines the guess is usually right. On a statement with wrapped descriptions, a table without lines, or a scan, the guess can be wrong in ways that are easy to miss.
That is why the first question is always what kind of PDF you have, and the last step is always a check, not a download.
Step 1: Identify your PDF
Text PDF. Created from software, such as a report, an invoice or a statement downloaded from a website. Text is selectable. Everything below works.
Scanned PDF. A photograph of a page inside a PDF wrapper. No text is selectable. You need OCR.
Image of a table. A screenshot or photo that is not a PDF at all.
Protected PDF. Text selects, but copying is blocked. Respect the restriction and ask for the data in another format.
| Your PDF | Best first method | Then |
|---|---|---|
| Text PDF, one simple table | Copy from Preview, paste into Excel | Clean the pasted data |
| Text PDF, many tables or no ruling lines | Tabula, export CSV | Open the CSV in Excel |
| Image or screenshot of a table | Data From Picture in Excel | Review the preview, check totals |
| Scanned PDF | OCR first, then extract | Verify every number |
| Bank statement | Bank CSV download, or copy and reconcile | Balance check, then categorise |
| Team works in Google Sheets | Paste and split in Sheets, or via Google Docs | Fix text and number types |
| Same layout every month | Windows Excel with Power Query, or a repeatable Tabula selection | Template for cleaning |
Step 2: Use the method that fits
Copy and paste (free, local)
For a single table in a text PDF, this is the fastest approach. Select the table in Preview with ⌥-drag, copy, and paste into Excel. Our guide to copying a table from a PDF into Excel on Mac covers selecting one column at a time and handling tables that run across pages.
Clean the pasted data
Whatever you use, the data arrives as text that needs work: columns to split, numbers stored as text, hidden non-breaking spaces and negative numbers in brackets. Our guide to cleaning PDF data pasted into Excel walks through Text to Columns and the formulas that fix each problem.
Tabula and CSV (free, local)
For many tables or tricky layouts, Tabula extracts tables to CSV on your own Mac. Our guide to converting a PDF to CSV on a Mac explains the steps and the CSV traps around encoding, commas and dates.
Images and screenshots
Excel for Mac with a Microsoft 365 subscription can read a table from a picture. See how to convert an image to Excel with Data From Picture, including the review step that catches OCR errors.
Scanned PDFs
A scan needs text recognition before anything else. Our guide to converting a scanned PDF to Excel on Mac compares the routes from Preview to paid OCR, and explains how to verify results.
Bank statements
These are the highest-stakes conversion, and they have their own guide: converting a bank statement PDF to Excel on Mac, with a balance check that proves the output.
Google Sheets
If your team works in Sheets, there are two straightforward routes, covered in how to convert a PDF to Google Sheets from a Mac.
Step 3: Check the result
| Check | How | Catches |
|---|---|---|
| Totals | Compare a SUM with the figure printed on the PDF | Missing rows, misread digits, lost minus signs |
| Row count | Count rows in Excel and on the PDF | Rows lost at page breaks |
| Types | Numbers right-aligned, dates sort correctly | Text pretending to be numbers |
| Spot checks | First, last and a few middle rows | Column shifts and merged cells |
Do not skip this. A conversion that looks tidy can be wrong, and nothing in Excel warns you. The totals check is the most valuable and takes thirty seconds.
What about the Get Data From PDF command?
Windows Excel has a built-in PDF import with Power Query that refreshes. Microsoft's community answers say the connector is not available on Mac, and the picture is confusing enough that we wrote it up separately in does Excel for Mac have Get Data From PDF. If you need a refreshable import, that guide covers the workarounds.
Do you need a converter?
Sometimes. If you convert scans, handle high volume, or need batch processing, a paid tool is justified. Our guide to the best PDF to Excel converter for Mac gives the decision criteria and a ten-minute test you can run on any tool, rather than a ranking you have to take on trust.
Privacy: where does your file go?
Local methods, copy and paste, Tabula and desktop apps, keep the file on your Mac. Online converters upload it. For public documents that is fine. For statements, payroll, medical or client data, use a local method or read the provider's retention terms very carefully.
Working faster once the data is in Excel
Cleaning is mostly keyboard work: selecting regions, pasting values, filtering and filling down. If you have just moved from Windows, our Mac Excel shortcut cheat sheet lists the Mac equivalents. The Mac Excel Shortcuts app runs Windows-style Excel sequences on a Mac, which some people find helps with repetitive clean-up. It is optional, and nothing in these guides requires it.
The other direction: Excel to PDF
If you need to go the other way, turning a workbook into a PDF, see our guide to saving Excel as PDF on a Mac, which covers page fit, print areas and exporting every sheet.
Common mistakes
Not checking whether the PDF has selectable text before picking a tool.
Uploading sensitive files to the first converter that appears.
Trusting tidy output without a totals check.
Leaving numbers as text.
Expecting formulas back. A PDF holds values only.
Converting a scan with no verification.
Frequently asked questions
What is the easiest way to convert PDF to Excel on a Mac?
If the PDF has selectable text, copy the table in Preview, paste it into Excel and split it with Text to Columns. It is free and keeps the file on your Mac.
Can Excel for Mac open a PDF directly?
Not as a table. Excel for Mac cannot open a PDF as a spreadsheet, so you copy the data in, extract it first, or use image recognition.
Why do my numbers not add up after conversion?
They are probably text, or a digit or minus sign was misread. Convert them to numbers and compare totals with the PDF.
How do I convert a scanned PDF to Excel?
Run OCR first, using Live Text, Data From Picture or an OCR tool, then verify every number against the page.
Is there a free PDF to Excel converter for Mac?
Copy and paste with Preview, Tabula, and Data From Picture if you already have a Microsoft 365 subscription. All three keep the file local.
Does the converted file keep my formatting and formulas?
No. You get values. Formatting must be rebuilt, and there are never formulas in a PDF to recover.