Got a PDF table stuck on your Mac and need it in Excel? I’ve spent the last two weeks testing every method available on macOS – from built-in tools to online converters to dedicated apps. Some worked well. Most didn’t. Here’s exactly what I found.
If you’re looking for a full roundup of free PDF tools, check out our guide to the best free PDF editors – it covers editing, converting, and more. But right now, let’s focus specifically on getting those PDF tables into Excel on a Mac.
Quick Comparison: Mac PDF-to-Excel Methods
| Method | Cost | Formatting Quality | Batch Support | File Size Limit | Best For |
|---|---|---|---|---|---|
| Preview + Numbers (built-in) | Free | Poor | No | None | Simple single-column data |
| Google Docs | Free | Fair | No | 15 MB | Quick one-off conversions |
| Smallpdf | Free (2/day) | Good | No (free) | 5 MB (free) | Occasional use |
| ILovePDF | Free (1/day) | Good | No (free) | 25 MB (free) | Larger PDFs, good accuracy |
| PDF2Go | Free | Fair | No | 50 MB | Big files, no signup |
| LibreOffice Draw | Free | Fair | No | None | Offline, privacy-focused |
| Tabula | Free (open source) | Very Good | Yes | None | Data extraction, technical users |
| Adobe Acrobat Online | Free (limited) | Very Good | No | 100 MB | Complex multi-table PDFs |
Method 1: Preview + Apple Numbers (Already on Your Mac)
This is what most people try first. And honestly, it barely works for anything beyond the simplest layouts.
Open your PDF in Preview. Select the table data by clicking and dragging. Copy it (Cmd+C). Open Numbers or Excel and paste (Cmd+V).
Here’s the thing – Preview doesn’t understand table structure. It copies text line by line. A 4-column table turns into a single column of jumbled text. I tested this with a financial report that had 6 columns and 40 rows. The result was unusable. Every row merged into one cell.
Where it actually works: single-column lists, simple two-column key-value pairs, and PDFs where the text is already arranged left-to-right without complex spacing. That’s about it.
Method 2: Google Docs (Free, Decent for Simple Tables)
Upload your PDF to Google Drive. Right-click it and choose “Open with Google Docs.” Google will OCR the text and attempt to rebuild the layout. Then copy the table content into Google Sheets and download as .xlsx.
I tested this with 8 different PDFs. Results:
- Simple invoice with 4 columns: preserved structure, minor spacing issues. Took about 2 minutes of cleanup.
- Bank statement with merged cells: failed badly. Columns shifted, numbers ended up in wrong rows.
- Government form (scanned): OCR picked up ~85% of text correctly but table structure was gone.
The 15 MB file limit is rarely a problem since most PDFs people need to convert are under 5 MB. But the formatting quality tops out at “okay” for anything complex.
Method 3: Smallpdf (Best for Quick One-Off Conversions)
Go to smallpdf.com/pdf-to-excel. Drop your file. Wait 10-15 seconds. Download the .xlsx.
The free tier gives you 2 conversions per day with a 5 MB file size cap. No account needed for those 2 free ones. After that, they want $12/month.
Formatting accuracy was noticeably better than Google Docs. I ran the same bank statement through it – 4 out of 6 columns mapped correctly. The date column split weirdly, and one merged-cell header caused a row offset. But the numbers themselves were accurate.
One thing I appreciated: Smallpdf processes files on their servers and deletes them after 1 hour. They say this on their privacy page. Whether you trust that is up to you, but at least they’re transparent.
Method 4: ILovePDF (Larger Files, Good Accuracy)
ILovePDF handles files up to 25 MB on the free plan and gives you 1 free conversion per day. The conversion engine is surprisingly solid.
I threw a 47-page product catalog at it (12 MB). The tables came through with correct column alignment on 38 of the 47 pages. The pages that failed had tables spanning two columns with images between them – no free tool handled those well.
The output .xlsx file opened cleanly in both Excel and Numbers. Column widths were preserved, which saved me manual formatting time. That’s a small detail but it matters when you’re converting 50-row tables.
Method 5: PDF2Go (No Signup, Big File Support)
PDF2Go accepts files up to 50 MB without creating an account. The conversion process takes longer – about 30-45 seconds for a 10 MB file – but the results are acceptable.
Accuracy was middle-of-the-road. Comparable to Google Docs for simple tables, worse than Smallpdf or ILovePDF for complex ones. Where PDF2Go wins is convenience: no daily limits that I could find, no account wall, and the largest free file size limit in this roundup.
The site is ad-heavy though. If you’re using Safari without an ad blocker, expect popups.
Method 6: LibreOffice Draw (Offline, Free, Open Source)
Download LibreOffice (free, about 300 MB). Open the PDF in LibreOffice Draw. It imports the PDF as an editable document. Then you can select table content and paste it into LibreOffice Calc, which saves as .xlsx.
The big advantage: everything stays on your Mac. No uploading sensitive financial data to random servers. For accountants and lawyers dealing with confidential documents, this matters.
Downsides: LibreOffice’s PDF import isn’t great at recognizing table boundaries. It treats each text element as a separate object. Reconstructing a table from these fragments takes manual work. For a 20-row table, expect about 5 minutes of copy-paste-rearrange. For anything bigger, use Tabula instead.
Method 7: Tabula (Best for Data Extraction – Technical Users)
Tabula is a free, open-source tool built specifically for extracting tables from PDFs. It runs locally on your Mac through a browser interface (localhost). Download from tabula.technology, double-click to launch, and it opens in Safari or Chrome automatically.
How it works: upload your PDF, draw a box around the table you want to extract, hit “Preview & Export Data.” It outputs CSV or TSV that opens perfectly in Excel.
I tested Tabula with the same 8 PDFs I used for every other method. Results were the best of any free tool – 5 out of 8 converted with zero errors. The remaining 3 had minor issues with multi-line cell content (text wrapping inside cells gets split across rows).
Tabula also supports batch extraction. If you have 20 PDFs with identically structured tables, you can set up a template and run them all. Saved me about 45 minutes on a real project last week.
The catch: Tabula only works with text-based PDFs, not scanned images. If your PDF is a scan, you need OCR first (see the best free PDF editors guide for OCR options).
Method 8: Adobe Acrobat Online (Best Quality, Limited Free Use)
Adobe’s online converter at adobe.com/acrobat/online/pdf-to-excel.html gives you a handful of free conversions before requiring a Creative Cloud login. After that, it pushes you toward the $12.99/month Acrobat Pro subscription.
But those free conversions? They’re genuinely the best quality I tested. Multi-table layouts, merged cells, nested headers – Adobe handled things that made every other tool choke. One 28-page financial report with complex formatting came through with only 2 cells needing manual correction.
If you need this once or twice and accuracy is the priority, start here. If you need regular conversions, the subscription cost is hard to justify when Tabula does nearly as well for free.
What About Apple Numbers Directly?
Numbers can’t open PDFs. Full stop. I mention this because I’ve seen forums suggesting it as an option. It’s not. Numbers handles .xlsx, .csv, and its own .numbers format. If someone tells you to “just open the PDF in Numbers,” they’re confused.
You need an intermediate conversion step – which is what this entire guide covers.
My Recommendation Based on Use Case
For a quick single conversion with simple tables: Smallpdf. Upload, convert, download. Under 30 seconds.
For regular conversions with privacy requirements: Tabula. Everything stays local, open source, and the accuracy is the second best behind Adobe.
For large or complex PDFs where accuracy matters most: Adobe Acrobat Online for the free conversions, then switch to Tabula when those run out.
For scanned PDFs: none of the free Mac tools handle this well. You’ll need OCR first. Google Docs does basic OCR during import but table structure gets destroyed. Honestly, scanned PDF-to-Excel is the one scenario where a paid tool (Adobe Acrobat Pro or ABBYY FineReader) saves real time. We cover more about this in our guide to converting PDF to Excel for free.
Step-by-Step: Converting PDF to Excel Using Tabula on Mac
Since Tabula gave the best results for most users, here’s the full walkthrough:
1. Download and Install Tabula
Go to tabula.technology. Download the Mac version (it’s a .zip file, about 30 MB). Unzip it and drag Tabula to your Applications folder. If macOS blocks it on first launch, go to System Preferences > Security & Privacy and click “Open Anyway.”
2. Launch and Import Your PDF
Double-click Tabula. Your default browser opens with the Tabula interface at 127.0.0.1:8080. Click “Browse” and select your PDF. Hit “Import.” Tabula processes the file – a 20-page PDF takes about 5 seconds.
3. Select the Table Area
Click and drag to draw a green box around the table you want to extract. You can select multiple areas on the same page. For multi-page tables, check “Repeat this selection” and it applies the same selection coordinates to all pages.
4. Choose Detection Method
Tabula offers two modes: “Stream” (for tables without cell borders) and “Lattice” (for tables with visible grid lines). Try Lattice first. If the preview looks wrong, switch to Stream. Most PDFs with proper table formatting work with Lattice.
5. Export and Open in Excel
Click “Preview & Export Data.” Check the preview. If it looks right, click “Export” and choose CSV. Open the CSV in Excel or Numbers. Save as .xlsx if needed.
Common Issues and Fixes
Columns are merged or shifted
This usually happens with PDFs that use spaces instead of actual table cells for alignment. Switch Tabula to “Stream” mode. In online tools, try ILovePDF instead of Smallpdf – ILovePDF handles space-aligned tables better.
Numbers show as text in Excel
After conversion, Excel sometimes treats numbers as text (you’ll see a green triangle in the corner of cells). Select the column, go to Data > Text to Columns > Finish. This forces Excel to reparse the values as numbers.
Scanned PDF gives blank output
The PDF contains images, not searchable text. You need OCR before conversion. On Mac, the quickest free path: upload to Google Docs (it auto-OCRs), download as .docx, then copy tables into Excel. Quality varies wildly depending on scan resolution and font clarity.
Multi-page table splits into separate tables
Most free tools treat each page independently. In Tabula, use “Repeat this selection” across pages, then combine the CSV outputs manually in Excel. In Smallpdf and ILovePDF, you might need to merge sheets after conversion.
FAQ
Can I convert PDF to Excel on Mac without installing anything?
Yes. Online tools like Smallpdf, ILovePDF, and Adobe Acrobat Online all work in Safari or Chrome without installing software. You upload the PDF, the conversion happens on their servers, and you download the .xlsx file. The tradeoff is privacy – your file gets uploaded to a third-party server.
Is there a completely free way to convert PDF to Excel on Mac with no limits?
Tabula is 100% free, open source, and has no conversion limits. It runs locally on your Mac, so there’s no file size restriction and no daily cap. The downside is that it requires a quick installation and doesn’t handle scanned (image-based) PDFs.
Does Apple Preview convert PDF to Excel?
No. Preview can display PDFs and do basic annotations, but it has no export-to-Excel feature. You can copy text from Preview and paste it into Numbers or Excel, but the table structure won’t be preserved. It copies as plain text, which means all column alignment is lost.
What’s the most accurate free method for complex PDF tables on Mac?
Adobe Acrobat Online offers the highest accuracy for free (with limited conversions). For unlimited free use, Tabula is the best option – especially for tables with clear borders. For scanned PDFs with complex layouts, no free tool on Mac handles this reliably; you’ll get the best results with a paid tool like Adobe Acrobat Pro ($12.99/month).
Can I batch convert multiple PDFs to Excel on Mac for free?
Tabula supports batch processing through its template feature. Set up extraction coordinates on one PDF, then apply the same template to a batch of similarly structured PDFs. No other free Mac tool offers true batch conversion – online converters process one file at a time on free tiers.