How to convert an invoice PDF to Excel
Line items you can total, VAT you can check and a list of every invoice for the month — without uploading your customers' or suppliers' details anywhere
By Metin Ersoy · Updated November 3, 2026
What you actually want from an invoice in Excel
People rarely need the whole invoice in a spreadsheet. They need one of three things: the line items to compare with an order or a quote, the VAT to check before it goes into the books, or an invoice list — number, date, supplier, net, VAT and total for every invoice in a month. Copying from the PDF gets in the way of all three: the columns run together, numbers arrive as text and the totals refuse to add up.
The PDF to Excel tool reads where each value sits on the page, puts every column of the line-item table into its own cell and writes amounts and rates as real numbers. Below is how to get each of the three results.
Step by step
- Use the PDF the software produced. An invoice downloaded from an e-invoicing portal, a supplier's website or your email contains real text. A scan or a photo does not — see the OCR note further down.
- Combine invoices if you have several. Put the month's invoices into one file with Merge PDF, in the order you want them on the sheet.
- Open PDF to Excel and choose the file.
- Pick the options. Keep "Put each page on its own sheet" ticked for one sheet per invoice page; untick it to get all line items in one long table. Leave "Tables only" unticked if you want the invoice number, date and parties to come along in column A — you need them for an invoice list.
- Convert and download the .xlsx file, then open it in Excel, LibreOffice Calc, Google Sheets or Numbers.
Checking line items and VAT
Once the lines are in cells, the arithmetic is quick to verify. Say quantity is in column C, unit price in D, VAT rate in E and the line amount in F:
- Line total: in a new column,
=C2*D2should equal the amount in F. A difference usually means a discount column you have not included, or a rounding rule. - VAT per line:
=F2*E2gives the VAT for that line, because a rate like 20% is already a percentage in the cell. - Invoice totals:
=SUM(F2:F20)for the net and=SUMPRODUCT(F2:F20,E2:E20)for the VAT. Compare both with the totals printed at the bottom of the invoice.
If the sums match, the conversion lost nothing and the invoice itself is consistent. If they do not, you have found the line to ask the supplier about.
Descriptions on two lines. A long product name often wraps onto a second line. The converter adds such a line to the description above when the number columns next to it are empty. If a stray half-empty row is left over, delete it or move its text up.
Amounts that stay as text. Currency signs and codes are removed for you, so €450.00 and 450.00 EUR both become 450. A number with a unit attached, such as 12 pcs or 3 hrs, is kept as text so nothing is silently lost. Split it with Data → Text to Columns, or remove the unit with Find & Replace, and the cells become numbers.
Building an invoice list for the month
An invoice list is one row per invoice: number, date, supplier or customer, net amount, VAT and total. It is what an accountant usually asks for, and what you use to check that nothing is missing.
- Convert the merged month with "Put each page on its own sheet" ticked, so each invoice is easy to find.
- Add a new sheet called List with the columns Invoice no, Date, Party, Net, VAT, Total.
- For each invoice, copy the number, date and party from column A of its sheet, and the three totals from the bottom of its table. Typing a reference such as
='Page 3'!F21instead of the value keeps the list linked to the converted figures. - Sort the list by date or by invoice number. A gap in a numbered series is the quickest way to spot an invoice that never arrived.
With a few invoices this takes minutes; for hundreds a month, your accounting software's import or an e-invoice XML is the better tool.
A scan, a photo or a locked file
Scanned or photographed invoices contain no text. Make them searchable with OCR PDF first, then convert the result, and always compare the totals with the paper copy.
Password-protected invoices must be unlocked before converting. If you know the password, save a copy without it using Unlock PDF.
Paper receipts and invoices for an expense claim are a different job: there you usually want one PDF to send, not a sheet. See how to combine receipts into one PDF.
Why converting in the browser matters here
An invoice names two businesses or people, their addresses and tax numbers, what was sold and at what price — information that is commercially sensitive for you and personal for your customers. Most PDF to Excel sites upload the file to convert it. PDFVela does the work on your own device: the invoice is not sent anywhere and is cleared from memory when you close the tab. For other tables, see how to copy a table from a PDF to Excel; for statements, how to convert a bank statement PDF to Excel.
Ready to try it? It is free and your file stays on your device.
Open PDF to Excel