To export a supplier invoice PDF to Excel with Acrobat, open it, choose the Export PDF tool, pick Spreadsheet and then Microsoft Excel Workbook, and save. Acrobat runs text recognition automatically on scanned pages. The result is a draft: check each line's quantity times price, the subtotal against the sum of the lines, and the invoice total before posting.
The Complete Excel Course with AI Integration
From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.
By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner
Buy nowThat checking is the part most guides skip. Exports go wrong in quiet ways: a number stored as text that SUM ignores, a description wrapped onto its own row, a scanned 6 read as an 8. The export saves the typing, and six short checks protect the money.
Which Acrobat plan exports tables to Excel
Adobe's pricing page lists "Export PDFs to Word, Excel, and PowerPoint files" as a feature of all three individual plans: Acrobat Standard, Acrobat Pro and Acrobat Studio. At the time of writing, Adobe's pricing page showed (prices vary by country) Standard at $14.99 a month on an annual plan billed monthly, Pro at $19.99 and Studio at $24.99, with higher month-to-month prices ($24.99, $29.99 and $34.99). Only Studio includes the AI Assistant. Cancellation fees apply to annual plans, so check Adobe's terms before committing.
For this job, the export itself needs nothing above Standard. If a team already pays for Studio, the Assistant is a second route covered later. The wider upgrade decision is in Acrobat Studio vs Pro: is the AI Assistant worth the upgrade.
How do you export a supplier invoice PDF to Excel in Acrobat?
Exporting a supplier invoice PDF to Excel in Acrobat is a short routine through the Export PDF tool, and the result is a draft rather than a finished sheet.
- Open the supplier PDF in Acrobat.
- Choose the Export PDF tool in the right-hand pane.
- Select Spreadsheet as the format, then Microsoft Excel Workbook.
- Click Export. If the PDF holds scanned text, Acrobat recognises it automatically as part of the export.
- Name the file with the supplier and invoice number, and save it somewhere that is not your Downloads folder.
If you only need one table from a longer document, select just that part of the page first so you do not get a workbook full of terms and conditions. Adobe's page says columns, layouts and formatting carry over, which is true often enough to be useful and false often enough to need the checks below.
Scans and OCR
OCR (optical character recognition) means software reading the picture of a page and turning it into text. A photo of an invoice taken at an angle, a faint fax, or a document scanned at low resolution gives it more to guess at. The most useful thing you can do is give it a better scan: flat, well lit, straight, and at a resolution that keeps small digits clean. If you scan regularly, the guide to Acrobat OCR for scanned receipts and contracts shows how to prepare the file before export.
The worked example: one distributor's invoice
Say a wholesale distributor receives this invoice from a packaging supplier as a PDF. It is illustrative, with figures chosen so that the sums work.
| Line | Description | Qty | Unit price | Amount |
|---|---|---|---|---|
| 1 | Cable ties 200mm, pack of 100 | 40 | 3.20 | 128.00 |
| 2 | Pallet wrap 500mm | 12 | 8.75 | 105.00 |
| 3 | Packing tape, 48mm | 60 | 1.15 | 69.00 |
| 4 | Labels 100x150, roll | 25 | 6.40 | 160.00 |
| 5 | Bubble wrap, 50m roll | 8 | 22.50 | 180.00 |
| 6 | Carton 400x300, flat | 150 | 0.84 | 126.00 |
| Subtotal | 768.00 | |||
| Delivery | 15.00 | |||
| Tax (10%) | 78.30 | |||
| Total due | 861.30 |
The tax is 10 per cent of 783.00 (the subtotal plus delivery), which is 78.30. Those are the numbers you will test the export against. What actually comes out of Acrobat may look like this in Excel, with the changes marked.
A B C D E F
1 Cable ties 200mm, pack of 100 40 $3.20 128.00 (left-aligned)
2 Pallet wrap 500mm 12 $8.75 105.00
3 Packing tape, 48mm 60 $1.15 89.00 (was 69.00 in the scan)
4 Labels 100x150, roll 25 $6.40 160.00
5 Bubble wrap, 50m roll 8 $22.50 180.00
6 Carton 400x300, (qty and amounts on next row)
7 flat 150 $0.84 126.00
8 Subtotal 768.00
9 Delivery 15.00
10 Tax (10%) 78.30
11 Total due 861.30
Three faults sit in this sample. The unit prices carry a dollar sign, so they arrive as text. Line 3's amount has been misread. Line 6's description wrapped, so the line's numbers landed on the row below. Everything looks plausible at a glance, which is exactly why a check is needed.
Which six checks catch Acrobat export errors?
Six checks catch Acrobat export errors: make numbers numeric, repair wrapped rows, check line maths, compare the line sum with the subtotal, recompute tax and total, and compare the header with your records.
1. Make every number a number
Numbers stored as text are left-aligned, and SUM ignores them. Add a helper column for each numeric column. For a unit price in D2:
=VALUE(SUBSTITUTE(SUBSTITUTE(TRIM(D2),"$",""),",",""))
TRIM removes stray spaces, and the two SUBSTITUTEs remove the currency symbol and any thousands comma. If a number has a non-breaking space, which looks like a space but is not one, add SUBSTITUTE(D2,CHAR(160),"") too. Test =ISNUMBER(F2) afterwards: it must say TRUE for every row.
2. Repair wrapped rows before maths
Scan the description column for a row that has text but no quantity or amount, and the row below it with numbers but a fragment of text. Join the text (=A6&" "&A7), keep the numbers on one row and delete the spare row. It is a manual step, and it takes a minute per invoice at most. If your supplier does this every month, ask whether they can send a CSV or an invoice without wrapped descriptions.
3. Check each line's maths
In a new column, compare quantity times unit price with the amount:
=ROUND(C2*D2,2)-E2
Anything other than zero is a line to look at. In the sample, line 3 gives 60 times 1.15 equals 69.00, minus 89.00, which is -20.00, and the misread is found. You may see tiny differences if the supplier rounds per line differently, so use =IF(ABS(ROUND(C2*D2,2)-E2)>0.01,"CHECK","ok") to ignore a cent.
4. Add the lines and compare with the subtotal
Sum the repaired amount column and subtract the subtotal shown on the invoice. With line 3 corrected to 69.00, the sample sums to 128 + 105 + 69 + 160 + 180 + 126 = 768.00, which matches. With the misread 89.00 it would sum to 788.00, 20.00 over, which is the same fault caught a second way.
5. Recompute tax and total
Do not trust the printed totals, rebuild them: subtotal 768.00 plus delivery 15.00 is 783.00, and 10 per cent of that is 78.30, so the total is 861.30. If the supplier applies tax only to goods, not to delivery, the arithmetic changes, so work out which rule the invoice follows and use it consistently. A difference you cannot explain is a reason to ring the supplier, not to adjust the number.
6. Compare the header with your records
Supplier name, invoice number, invoice date, currency and purchase order reference should match what you expect. Search your ledger for the invoice number: a duplicate is far more common than fraud. The tutorial on catching duplicate invoices and payment fraud with AI goes further on that side.
How do you turn the checks into a reusable template?
A reusable invoice-check template is a workbook with an Import sheet and a Checks sheet, built once for each supplier you receive from regularly. Paste the export into Import and let the Checks sheet carry the formulas. A result block like the following gives a quick pass or fail:
| Check | Formula idea | Result for the sample |
|---|---|---|
| All amounts are numbers | COUNT of the amount column equals the number of lines | Pass after cleaning |
| Lines add to subtotal | SUM of amounts minus printed subtotal | 0.00 |
| Quantity times price | Count of rows flagged CHECK | 1 before the fix, 0 after |
| Total rebuilt | Subtotal plus delivery plus tax minus printed total | 0.00 |
| Invoice number new | COUNTIF in the ledger equals 0 | Pass |
Colour the result cell green when everything is zero or TRUE and red otherwise. Keep it dull and visible. If you want to build more of this with AI help, the ChatGPT for Excel guide shows how to ask for formulas, and you should still test each one on a known invoice.
If the checks sheet is the slow part, The Complete Excel Course with AI Integration on Coding Liquids covers the spreadsheet side.
How do you handle a scanned or photographed supplier invoice?
A scanned or photographed supplier invoice follows the same export process but needs a stricter rule: check every digit of the total, and every line over a set value, against the image. Some suppliers are small and send a phone photo of a printed invoice, so expect more faults. A small courier firm might say "anything over $500 is read against the PDF by a second person". The point is proportionate care: heavier checks for larger sums, lighter for a $40 stationery order.
Can the Acrobat AI Assistant extract invoice lines instead?
The Acrobat AI Assistant, included with Acrobat Studio, can list an invoice's line items when asked, but it is not a shortcut around the six checks. You can ask it questions about an open PDF, and a prompt such as the one below asks for the line items in a form you can paste:
List every line item on this invoice as a table with columns:
description, quantity, unit price, line amount. Then give the subtotal,
delivery, tax and total exactly as printed. Do not calculate anything.
The reply can be quicker for an odd layout, and it can handle a wrapped description gracefully. It is also a language model reading the document, so it can still misread a digit or silently fix an inconsistency it thinks is a typo. "Do not calculate" is there to stop that. Whichever route you use, the six checks stay the same, and I would run them without exception on anything that reaches payment. Questions about where documents go when the Assistant reads them are in Acrobat AI Assistant privacy: is your client data used for training. For the general weakness of AI on sums, why AI is bad at maths and what to check in quotes and invoices explains it.
How do you fix formatting problems after an Acrobat export?
Common formatting problems after an Acrobat export are merged cells, invoices split across sheets, dates read as text or swapped, credit lines, junk columns and stray letters in numbers, each with a short fix.
- Merged cells. Acrobat sometimes merges cells to hold a heading. Unmerge them before sorting or filtering, or Excel refuses.
- One invoice split across sheets. A multi-page invoice can become several sheets. Copy the line items onto one sheet and keep the page footers out.
- Dates read as text or swapped. A date such as 03/04/2026 may be read as March or April depending on your computer's settings. Compare with the invoice's own wording ("3 April") and convert with
=DATE(year,month,day)if needed. - Credit lines. Brackets mean negative. Excel often reads "(45.00)" as -45 through VALUE; test one before relying on it, and check credit notes against their own total.
- Junk columns. Blank columns from page margins can be deleted. Do it after the checks, not before, so you do not cut a real column.
- Letters in numbers. The letter O for a zero, or a lowercase l for a one, shows up in poor scans.
=SUMPRODUCT(--ISERROR(VALUE(E2:E7)))counts how many cells still fail conversion.
A small-manufacturer example with a credit note and a short delivery
Say a small manufacturer's month-end batch has an invoice for 24 steel brackets at 4.50 (108.00), a credit note of (13.50) for three that arrived bent, and a delivery charge of 9.00. The printed total reads 103.50. Rebuilding: 108.00 minus 13.50 plus 9.00 is 103.50, so the total matches. But the export shows the credit as 13.50 without the brackets, and SUM gives 130.50. The checks catch it because the rebuilt total and the printed total disagree. The fix is to re-enter the credit as a negative, then re-run the checks. The lesson: sign errors are invisible unless you compare against a printed total.
A software reseller's invoice with a trap in the quantities
Take a B2B software reseller whose supplier bills licences by the user per month. One line reads "Cloud backup, 25 users, 12 months, 3.80 per user per month, 1,140.00". The export gives the quantity column as "25", a period column as "12" and the amount as "1,140.00", with a comma. Line maths now needs three factors: 25 times 3.80 times 12 is 1,140.00. A check built only on quantity times unit price flags it as wrong (25 times 3.80 is 95.00), and a tired accounts clerk might "fix" the amount to 95.00.
The lesson is that the line-maths formula must follow the supplier's pricing rule, not a universal one. Before you build the template, read one invoice and write the rule in words: "amount = users x monthly price x months". Then add a column for months, and the formula becomes =ROUND(C2*D2*F2,2)-E2. If you cannot state the rule, you cannot check the line, and that is a question for the supplier.
How do you stack a month of invoice exports into one list?
Stacking a month of invoice exports into one list works once each invoice is clean: keep the same column order every time, with a first column for the invoice number so every row knows where it came from. Paste each cleaned import under the last, then sort by supplier. A pivot table (Insert, then PivotTable) gives total spend by supplier and by product in a minute. Sums at that level are a second reconciliation: the pivot's grand total should equal the sum of invoice totals on your payables list. A difference of a few cents is rounding, a difference of $20.00 is a misread digit you missed.
Illustrative month: 14 invoices from five suppliers, 96 lines in total. Lines flagged by the maths check: 5 (three misreads on a faded scan, one wrapped description, one price change from the supplier that nobody had told purchasing about). The last one is a business finding, not an export error, and it is the reason these checks are worth having even when the export is perfect.
Who should approve an invoice after the checks?
Who may approve an invoice depends on what the six checks show, and the result must change what happens next. A short rule table keeps that from being a habit of the person who happens to be at their desk:
| Result | What happens | Who decides |
|---|---|---|
| All six checks pass, total under your usual limit | Post and schedule payment | The person who ran the checks |
| Passes, but a price differs from the last invoice | Hold; ask purchasing | Purchasing owner |
| Any maths check fails | Compare with the PDF image, correct, re-run | The person who ran the checks |
| Cannot reconcile after correcting | Contact the supplier for a corrected invoice | Finance owner |
| Duplicate invoice number | Do not pay; log and tell the supplier | Finance owner |
Set the "usual limit" for the size of your business. A firm paying $200 invoices has a different tolerance from one paying $20,000 ones, and a second pair of eyes on the larger ones costs little.
How long this takes, and what it saves
An illustrative before and after for a courier firm with 40 supplier invoices a month. Retyping each one takes about six minutes, 240 minutes in all, and nobody checks the typing. Exporting takes about one minute each, cleaning and checking about three, so 160 minutes in total, with every invoice checked. The saving in time is modest. The saving in confidence is bigger: errors are found before payment, not when the supplier statement does not match. Measure your own: time five invoices each way before deciding.
Before you trust a new supplier's layout
Run this short routine for every new supplier, one time:
- Export their last three invoices.
- Check each with the six checks and note which fail, and why.
- Write the supplier's pricing rule in one sentence in the template.
- Decide whether the export is trustworthy enough, or whether to ask the supplier for a spreadsheet instead.
Three clean passes mean the layout is stable. Any failure is information: a supplier with a layout that changes each month is one you will keep checking by eye.
What to keep, and when to stop doing this by hand
Keep the PDF, the raw export and the cleaned file together, named by supplier and invoice number, so that anyone auditing later can see what changed. If you handle more than a few dozen invoices a month, the hand-cleaning is where time goes, and that is the point at which dedicated invoice-capture tools or an accounting package's own import start to pay. The overview in outgrowing spreadsheets: when to replace manual Excel with AI helps you judge. If you would like someone to look at your intake with you, that is part of what my AI implementation consultation covers: get in touch.
Acrobat PDF to Excel for invoices: questions answered
Does Acrobat export scanned invoices to Excel?
Yes. Adobe's own page says Acrobat runs text recognition (OCR) automatically when the PDF contains scanned text. Scans are the riskier case, because a smudged 8 can become a 3. Run the number checks in this tutorial on every scanned invoice, and consider rescanning at a higher quality first.
Do I need the AI Assistant to export tables?
No. The Export PDF tool is listed on all three individual plans, Standard, Pro and Studio, while the AI Assistant is only included with Studio. Export to Excel is a conversion feature. The Assistant is a separate way to ask questions about the document.
Why do some numbers arrive left-aligned and won't add up?
They were imported as text, often because of a currency symbol, a thousands comma, trailing spaces or a stray character, so Excel treats them like words. Convert them with a helper column using VALUE, or use Text to Columns, then check that SUM matches the invoice.
Should I trust the export for payments?
No, not without checking it. Treat the export as a draft: check line maths, the subtotal and the invoice total against the PDF, and compare supplier, date and invoice number with your records. Payments on numbers nobody reconciled are how a misread digit becomes a real loss, so keep a human approval step.
Can I export many invoices at once?
Yes, with care. Acrobat can process several files, but multi-file exports tend to give you one workbook per file, and layout differences between suppliers make blind batching risky. Start with one supplier at a time, build the checks once, and reuse them as a template.
How do I convert a supplier invoice PDF to Excel with Acrobat?
Open the PDF in Acrobat, choose the Export PDF tool, pick Spreadsheet and then Microsoft Excel Workbook, and save. Acrobat runs text recognition automatically on scanned pages. Treat the result as a draft and check each line's quantity times price, the subtotal against the sum of the lines, and the invoice total before posting.
Further reads
- How Freelancers Use AI for Invoices, Proposals and Chasers — The sending side: invoices, proposals and polite chasers.
- How to Build a Job Costing Sheet in Excel With AI Help — Use clean invoice data in a job-costing sheet.
- Chasing Unpaid Invoices With AI: Polite Reminders for Trades — Chase unpaid invoices politely once your own are tidy.
- AI Email Triage for Shared Inboxes: Sales, Support, and Invoices — Sort invoices from sales and support in a shared inbox.
- Can ChatGPT Read PDFs, Spreadsheets and Photos? What Breaks — See where a chat tool misreads documents and tables.
- What Should a Goods Received Note Include? Match It With AI — What a goods received note should record, a template to copy, and how AI turns a delivery photo into a matched, flagged table.
Browse all AI-for-business tutorials
Sources: Adobe Acrobat PDF to Excel page (Export PDF steps, automatic text recognition for scans), Adobe Acrobat pricing page (Standard, Pro and Studio plans, AI Assistant in Studio). Check Adobe's current plan details before buying.
