PDFVela — pdfvela.com

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 · 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

  1. 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.
  2. 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.
  3. Open PDF to Excel and choose the file.
  4. 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.
  5. 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*D2 should equal the amount in F. A difference usually means a discount column you have not included, or a rounding rule.
  • VAT per line: =F2*E2 gives 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.

  1. Convert the merged month with "Put each page on its own sheet" ticked, so each invoice is easy to find.
  2. Add a new sheet called List with the columns Invoice no, Date, Party, Net, VAT, Total.
  3. 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'!F21 instead of the value keeps the list linked to the converted figures.
  4. 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

Questions about invoices and Excel

Will the invoice number, date and supplier name end up in their own columns?

They come through as text, usually in the first column above the line items, because on most invoices they are labels rather than a table. Line items — description, quantity, unit price, VAT and amount — are recognised as a table and split into cells. For an invoice list, copy the few header fields into a separate sheet, one row per invoice.

Are prices and VAT rates written as numbers?

Yes. Amounts with thousand separators, decimal commas or points, currency signs or codes such as EUR, and minus signs or brackets become numbers, and rates such as 20% become percentages, so you can total and recalculate them. Values with extra letters next to them stay as text.

Can I convert a month of invoices in one go?

Combine them first with Merge PDF, then convert the merged file. Leave "Put each page on its own sheet" ticked to keep each invoice page on its own sheet, or untick it to get every line item in one long table.

My e-invoice also came with an XML file. Which one should I use?

If your accounting software can import the XML, use it — it holds the data in a structured form and is the official record. The PDF route is for when you only have the PDF, or when you just need the lines in a spreadsheet for checking or reporting.

The invoice is a scan or a phone photo. Will it convert?

Not directly, because a scan has no text, only a picture. Run it through OCR PDF first and convert the searchable copy. Check the totals afterwards, because OCR can misread a digit, and on an invoice one digit matters.

Is it safe to convert invoices online?

Invoices carry names, addresses, tax numbers and prices you may not want anyone else to see. Most converters upload the file to their server. PDFVela converts it inside your browser, so the invoice never leaves your device.