Illustration: The invoice line items as an Excel spreadsheet on a laptop.
Invoice to Excel — Extract Invoice Image Tables — extract invoice line items from a photo into Excel — After
Invoice to Excel — Extract Invoice Image Tables — extract invoice line items from a photo into Excel — Before

Illustrative preview

Image to Excel

Invoice to Excel — Extract Invoice Image Tables

Choose an invoice image with the complete line-item table

Convert an invoice photo or scan image into an Excel line-item table. Verify item codes, quantities, tax and totals before downloading the XLSX workbook.

  • Purchase-order comparison
  • Project cost allocation

Upload

Drop a file here, or click to browse

All image formats (JPG, PNG, WEBP, HEIC, TIFF…) · PDF

Invoice to Excel: check billed items against the order or PO

This invoice to Excel page reads an invoice photo or scan into an editable grid and saves the billed items as an .xlsx workbook. It is for the checking that comes before payment: do the quantities match the order, does quantity times price equal each line, and does the total add up. Signed-in accounts can also keep checked invoices in History and combine a period into one workbook.

Run three checks in the worksheet

Three checks cover most invoices: quantities against the order, quantity times unit price against each line amount, and the sum of the lines against the printed total. The file stores every value as text, so convert the Quantity, Unit price and Amount columns to numbers first. Add a column that multiplies quantity by unit price and subtracts the printed amount. Any non-zero difference is a misread digit or a billing error.

Remove the rows that are not billed items

Address blocks, bank details and payment terms arrive as single-cell rows, and a tax summary can look like a line item. Delete them with the trash icon so the Amount column holds billed items only. When two item tables appear in one image, they are stacked with a blank row between them, which is a good place to split the sheet in Excel.

Save invoices by supplier and see daily totals

Under History, create one collection per supplier or per project and enter one currency. Choose the Amount column, set the Document date to the invoice date, and review Rows that look like totals: Total, Subtotal and Amount due lines are left out by default, while a tax line is listed so you choose whether to count it. Tick the checked box and save. The chart shows a daily total, and the combined workbook adds Document date and Source file to every row.

  1. Convert the invoice and delete address and payment-term rows.
  2. Open History and choose a supplier collection.
  3. Pick the Amount column and enter the invoice date.
  4. Tick the checked box and choose Save to history.

Spot the misreads that change what you pay

Item codes that mix letters and numbers, such as 5 and S or 0 and O, are the first misreads, so compare each code with the invoice. Unit prices are another: a lost decimal point turns 12.50 into 1250. Cells the reader doubted are shaded amber, but a clean cell can be wrong too, so tie out the printed total as a final test before you mark the invoice as checked.

Before you approve an invoice from the workbook

  • Keep the invoice image or PDF with the workbook as the source record.
  • Use one currency in each collection.
  • For plain rows an import expects, save the same table as CSV.
  • If the invoice is a PDF file, use PDF to Excel instead.

Compare billed items without retyping the invoice table

Extract an invoice's line-item table from a photograph or scanned image for checking against an order. Review quantity, unit price and amount columns separately; surrounding address blocks and payment instructions are not invoice rows.

Purchase-order comparison

Move supplier quantities and prices into a worksheet and compare them with your own order records after confirming the transcription.

Project cost allocation

Prepare a reviewed list of billed items before adding project codes or splitting costs across your existing budget workbook.

Prepare invoice rows for your own reconciliation

  1. Select a readable invoice image and keep all item-column headings visible.
  2. Review extracted item codes, quantities, unit prices and line totals against the source.
  3. Remove non-item text from the grid and export XLSX for your own reconciliation.

Invoice PDFs, tax formulas and purchase-order matching

Does invoice to Excel accept an existing PDF invoice?
This page accepts images. Use PDF to Excel for a PDF file, or upload a screenshot of the specific invoice table you need.
Are invoice tax calculations recreated as formulas?
The converter reads displayed values. Check the invoice's calculation method and add any required Excel formulas yourself.
Can I match the extracted invoice to a purchase order here?
The result provides table data for review. Matching against purchase orders or an accounting system takes place in your own workflow.
How should invoices with several item tables be handled?
Extract and review one clearly bounded table at a time. Do not assume separate tax summaries or continuation sections will be combined correctly.
How do I check that quantity times price equals each line amount?
Convert the three columns to numbers in Excel, then add a column that multiplies quantity by unit price and subtracts the printed amount. Rows where the result is not zero are misreads or billing differences. The workbook keeps no formulas of its own, so this check is yours to add.
Can I keep invoices from one supplier together?
Yes, for signed-in accounts. Create a collection in History named for the supplier, keep one currency in it, and save each checked invoice there. The panel then lists the saved invoices by date and can build a combined workbook for any period.
Why is the History chart counting my invoice total twice?
The chart adds up the amount column you chose, so a total row left in the table doubles the invoice. Total, Subtotal and Amount due rows are suggested for leaving out by default, but tax summary rows are only listed. Delete or untick them, and read the Counted rows line.
Are item codes with leading zeros kept in the workbook?
Yes. Every cell is written as text, so 000812 stays 000812 and a code made of digits is not turned into a number. Compare a few codes with the invoice, because similar characters such as 5 and S are the usual misreads.
What does an invoice with a handwritten amendment give me?
Handwriting is less reliable than print, so a corrected quantity or a handwritten price may be skipped or misread. Treat any amended line as unverified and type the right value into the grid yourself before you save the invoice as checked.
Can I process a stack of invoice photos at once?
Batch mode, a Premium option, converts many images with the same settings and returns a ZIP of workbooks, one per image, without a review step. For invoices you want to check, use single-file mode so the grid appears before the workbook is made.

Convert an image to an Excel table you can check

For a photographed stock list, keep the column headings, product codes and units in the frame. A clear grid gives you a better starting point for an editable workbook.

  1. Upload a sharp, straight-on image and select its language. Run the table reader, then review the extracted rows.
  2. Check that product code, description, quantity and price occupy separate columns. Compare the first and last rows with the photograph to catch missing records.
  3. Download the XLSX and open it in your spreadsheet app. Keep identifiers such as 00128 as text, quantities as numbers and uncertain cells marked for review.

A blank cell is not necessarily zero. If headings merge or a decimal is unclear, check the source or retake the photo before placing an order. The image contains displayed values, not the original spreadsheet formulas.

Check stock-list columns and leading zeros
Free to use · No signup required · Without watermarkUploads are encrypted in transitRemoved under our retention policy

Watch each transformation land

Every photo crosses the slash untouched and comes out the other side finished.