How to convert a PDF to Excel on Mac
Tables out of a report and into a spreadsheet — with a realistic account of what to check afterwards.
Financial statements, price lists, survey results, timetables — a great deal of data arrives as a PDF and needs to be in a spreadsheet before anyone can do anything with it. The alternative is retyping it, which is slower and less accurate.
Exporting to Excel is part of Premium, so it carries a small lock in the document actions panel and in the menu bar. The lock is a label rather than a barrier — you can open the feature and see what it does before deciding to unlock it. Reading and every page operation stay free.
Convert, step by step
-
Check the document has real text
Selecting a line is the test. A scanned table converts to a picture unless you run Make Searchable first.
-
Export to Excel
From the document actions panel, under Protect & Share.
-
Open the result
Look at the shape of the sheet before looking at any number: are the columns where you expect, is the header row intact, did each row of the original become one row?
-
Check the numbers
Spot-check against the PDF. Totals are the most useful check there is: if a column sums to the printed total, the column came across.
-
Fix the formats
Numbers arriving as text is the most common issue. Dates and currency are the usual culprits, and a column that will not sum is the giveaway.
What to check, specifically
| Check | Why |
|---|---|
| Do the totals match? | The single most valuable check. A column that sums to the printed total is almost certainly right. |
| Are numbers numbers? | A number stored as text sums to zero and sorts alphabetically. Check by summing a column. |
| Did merged cells survive? | Merged headers in the original often become a single value with blanks beside it. |
| Are negative numbers still negative? | Accounting brackets — (1,234) — are sometimes read as text rather than as a negative. |
| Did a table split across pages come back as one? | Repeated header rows in the middle of the data are the sign that it did not. |
| Are the decimal and thousands separators right? | A document produced in another locale can flip the two. |
Table conversion is genuinely useful and genuinely imperfect. A number that came across wrong looks exactly like a number that came across right. If a decision depends on the figures, reconcile them against the source before acting on them.
Tables that convert well, and tables that do not
A plain grid with a single header row, consistent columns and no merged cells converts very well. What causes trouble is everything that makes a table nice to look at: merged headers, nested groupings, cells spanning columns, rows without borders, footnote markers in cells, and tables that run across a page break.
If a particular table refuses to convert usefully, extracting the text from that region and pasting it into a spreadsheet is often faster than fighting it.
Converting a scanned table
Recognition reads the characters but does not rebuild the grid, so a recognised scan converts to text in approximately the right positions rather than to a clean table. It is usually still faster than retyping, and it always needs checking.
Frequently asked questions
How do I convert a PDF table to Excel on a Mac?
Export the document to Excel from the document actions panel. The conversion runs on your Mac.
Why are my numbers not adding up after conversion?
They are almost certainly stored as text. Summing a column is the quickest way to spot it — a text column sums to zero.
Will a complex table convert cleanly?
Plain grids convert very well. Merged headers, nested groupings, cells spanning columns and tables split across pages all need checking and sometimes fixing.
Can I convert a scanned table?
Run Make Searchable first. Recognition reads the characters but does not rebuild the grid, so expect text in positions rather than a clean table.
How do I check the conversion worked?
Compare the totals. A column that sums to the printed total came across correctly.
Does the document get uploaded?
No. Conversion happens on your Mac.