How to Export Supplier Invoice PDFs to Excel With Acrobat

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for How to Export Supplier Invoice PDFs to Excel With Acrobat.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for How to Export Supplier Invoice PDFs to Excel With Acrobat.

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 now

That 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.

  1. Open the supplier PDF in Acrobat.
  2. Choose the Export PDF tool in the right-hand pane.
  3. Select Spreadsheet as the format, then Microsoft Excel Workbook.
  4. Click Export. If the PDF holds scanned text, Acrobat recognises it automatically as part of the export.
  5. 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.

LineDescriptionQtyUnit priceAmount
1Cable ties 200mm, pack of 100403.20128.00
2Pallet wrap 500mm128.75105.00
3Packing tape, 48mm601.1569.00
4Labels 100x150, roll256.40160.00
5Bubble wrap, 50m roll822.50180.00
6Carton 400x300, flat1500.84126.00
Subtotal768.00
Delivery15.00
Tax (10%)78.30
Total due861.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:

CheckFormula ideaResult for the sample
All amounts are numbersCOUNT of the amount column equals the number of linesPass after cleaning
Lines add to subtotalSUM of amounts minus printed subtotal0.00
Quantity times priceCount of rows flagged CHECK1 before the fix, 0 after
Total rebuiltSubtotal plus delivery plus tax minus printed total0.00
Invoice number newCOUNTIF in the ledger equals 0Pass

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:

ResultWhat happensWho decides
All six checks pass, total under your usual limitPost and schedule paymentThe person who ran the checks
Passes, but a price differs from the last invoiceHold; ask purchasingPurchasing owner
Any maths check failsCompare with the PDF image, correct, re-runThe person who ran the checks
Cannot reconcile after correctingContact the supplier for a corrected invoiceFinance owner
Duplicate invoice numberDo not pay; log and tell the supplierFinance 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:

  1. Export their last three invoices.
  2. Check each with the six checks and note which fail, and why.
  3. Write the supplier's pricing rule in one sentence in the template.
  4. 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

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.

Ready to put AI on the jobs that eat your week?

No data team or big budget needed. In a 1:1 consultation I show small and medium-sized businesses and self-employed people which AI tools they can use, one workflow at a time.

Book a 1:1 call with me