Skip to content
Blogguide

GUIDE

How to convert PDF invoices to Excel and review line items

Turn supplier invoice PDFs and scans into a workbook you can actually work with. Check the original alongside the extracted data, correct the proposal, and export Excel.

By Kaliits · Reviewed · Editorial standards

Download the example ↓

How to convert an invoice PDF to Excel

Kaliits OCR is built for invoices. It does not reconstruct arbitrary PDF reports, charts or page formatting inside Excel. If you only need the words in a document, use the PDF to text tool instead.

  1. Upload one permitted PDF or invoice image to preview your result free. Create a verified account to export.
  2. Open the document and compare the proposed fields and line items with the original.
  3. Correct missing or misplaced values. Check the currency and invoice totals.
  4. Choose Excel. Open the downloaded XLSX and use its separate invoice and line-item sheets.

What the Excel workbook contains

The export separates an invoice record from its repeated line items. That lets you filter invoices without duplicating their totals for every product row. Join the two sheets using document_id when you need a detailed report.

Amounts and quantities are numeric cells. Identifiers remain text so a reference such as 000042 survives export. The workbook is a data export, not a visual copy of the invoice.

Sheet

Purpose

Invoices

One invoice record with party names, dates and amounts in the selected export columns.

Line items

One row per extracted item, with document ID, invoice number, description, quantity, unit price, tax rate and amount.

Manifest

Included and excluded document status, error code and user confirmation state.

A short review that protects the spreadsheet

Check the supplier and customer separately, then the invoice reference, date and currency. Compare each line with the original. A correct total does not prove that the descriptions or quantities are right.

Keep invoice IDs as text, including leading zeros. Check decimal separators and date conventions before combining files from different countries. Missing values need attention; a blank field is more useful than an invented value.

  • Compare row count and continuation pages.
  • Check quantities, unit prices and line amounts.
  • Check subtotal, discounts, charges, tax and total.
  • Export a copy and retain your source in your own archive.

When Excel itself may be enough

For a digital PDF with a regular table, a supported Excel installation can import tables through Power Query. Microsoft documents Data > Get Data > From File > From PDF. Availability depends on the Excel edition and platform. Inspect the imported table before using it.

Use a field-based invoice workflow when you need invoice numbers, supplier names and line items mapped across different layouts. Test several suppliers before relying on any extractor. A scanned image and a selectable-text PDF are different inputs.

Current invoice pilot availability

Preview your first invoice result without an account. Verify your email to export. The free pilot includes 30 pages per month and a seven-day account history. Uploads accept PDF, JPG and PNG, up to 10 MB per file. PDFs can contain up to 30 pages, with a maximum of 10 pages per invoice.

English and French typed invoices are the supported focus. Handwriting and Arabic are not reliable supported cases. Review is part of the workflow. Read the privacy and availability page before uploading: the current free AI-assisted pilot accepts only invented or appropriately redacted, non-sensitive documents and is unavailable in the EEA, UK and Switzerland. The browser text extractors included in these guides do not send your files for AI processing.

Sources and further reading