OmniDocExtract Invoice Data from PDF to Excel
Learn how to move invoice line items from a PDF into Excel with columns intact, including scanned invoices, and how to check the totals afterward.
Invoice line items are the part of a PDF that people often need in a spreadsheet: quantity, description, unit price, tax and amount, one row per item. Retyping them is slow, and a single misread digit can throw off your totals for the whole month. If you are reconciling vendor bills, preparing expense reports or loading invoices into an accounting workbook, you need the table to land in Excel with its columns still in order.
This guide shows you how to extract data from a PDF invoice to Excel with OmniDoc, check the result, and fix the problems that usually show up. It also covers scanned invoices, which need a text-recognition step before anything can be exported. You will finish with a spreadsheet you can total and trust, plus a simple check that tells you when something went wrong.
How do you get invoice line items from a PDF into Excel? The short answer
Start by checking whether the PDF has selectable text, then export it to Excel from the OmniDoc PDF editor and verify the output against the invoice total. If the invoice is a scan, run OCR first. Use the table below to pick the right path.
| Your situation | What to do | Why |
|---|---|---|
| The PDF was generated by accounting software and you can select the item text | Export the PDF to Excel in the PDF editor, then review the rows | Selectable text gives a direct result for the line items |
| The invoice is a scan or a photo saved as PDF | Run OCR in the PDF editor, then export to Excel | Without OCR, the text is only an image and cannot be read as cells |
| You only need a few numbers, such as the total and tax | Export the whole invoice, then copy the values you need | Checking a small set of fields is faster than cleaning a full table |
| You have many invoices from the same vendor | Process one invoice first, fix the column pattern, then repeat the same check on each file | Repeating a verified method reduces surprises across the batch |
| The invoice contains notes, stamps or handwriting | Export the typed items, then enter handwritten amounts manually and mark them | Handwriting and stamps are not reliably read as table data |
Before you start
Gather these items so you can check the output properly:
- The original PDF. Keep an untouched copy. You will compare the spreadsheet against it line by line, and you may need it again if an edit goes wrong.
- The invoice total, subtotal and tax. Write these down from the PDF before you export. They are your reference for the final check.
- A way to tell whether the PDF is scanned. Open the file and try to select a line of item text with your cursor. If the text highlights and can be copied, the PDF has a text layer. If the selection box covers the whole page as one image, it is scanned.
- Desktop client or web access. The PDF editor is part of the OmniDoc desktop client, which you can download at download.omnidoc.top. Install it first if you plan to work with OCR and export there.
- A rough sense of the column layout. Note which columns matter (item, quantity, unit price, amount) so you know what to look for after export.
Extracting invoice line items to Excel, step by step
- Open the invoice in the OmniDoc PDF editor. Load the file so you can see the table and check whether its text is selectable before you export anything.
- Run OCR if the invoice is scanned. Scanned PDFs contain pictures of text, so OCR must convert them into readable text first. Do this on a copy so the original stays untouched.
- Review the table on screen. Scroll through the line items and confirm that every row is visible on the page and that no item is cut off at a page break. Fixing a gap now is cheaper than finding it after export.
- Export the PDF to Excel. Use the export to Excel option in the PDF editor and save the file to a folder you can find again. Keep the original invoice number in the file name so the spreadsheet is easy to match later.
- Open the spreadsheet and find the header row. Look for the item, quantity, price and amount labels. Check that each label sits above the values it describes. If the headers and numbers are offset, the column structure did not come through correctly.
- Clean up the line items. Split any description that was merged into the quantity or price column, and convert the number columns to numeric format so sums work. Do this once per invoice layout, then reuse the same steps for similar invoices.
- Add a total row and compare it with the invoice. Use a SUM formula over the amount column and compare the result with the subtotal and total printed on the PDF. Any difference points to a row you missed or a value that was misread.
- Save a clean copy with a clear name. Store the finished workbook alongside the original PDF, using the vendor name, invoice number and date. A consistent name makes it easy to trace each figure back to its source.
Check the result
Do not treat the export as finished until you have checked it against the invoice. Machine-read text can drop characters, merge cells or misplace decimal points, and these errors look normal at a glance.
| Check | How to see it | If it's wrong |
|---|---|---|
| Row count | Count the item rows in the PDF and compare with the spreadsheet | Look for rows that were skipped at a page break and copy them in by hand |
| Column alignment | Confirm each value sits under its header, especially in the price and amount columns | Cut and paste the shifted values into the correct column, then recheck the row |
| Totals | Compare your SUM formula with the subtotal, tax and total on the invoice | Find the row where the difference starts and verify its quantity, price and amount against the PDF |
| Decimal and currency values | Look for misplaced decimal points, thousands separators and missing digits | Retype the value from the original PDF and reapply number formatting |
| Descriptions | Read each item name against the PDF | Correct any wrapped or truncated text and make sure no line merged into the one above |
Machine-read output still needs your review, especially for totals and amounts that feed into payments or tax records. Treat the PDF as the source of truth and the spreadsheet as the working copy.
❓ FAQ
1. Why does my Excel file show all invoice text in one column?
This usually means the export treated the table as a block of text rather than separate cells. Check the header row first, then split the text into columns with Excel's text-to-columns feature, using the spaces or tabs that separate your fields.
2. What if the scanned invoice comes out with wrong numbers?
OCR can misread similar characters, such as 1 and 7 or 0 and 8. Compare every amount with the printed invoice and correct any mismatch. Your subtotal check in Excel will flag many of these, but not all, so review the amount column even when the total matches.
3. Can I extract only the total and tax without the full table?
Yes. Export the invoice as you normally would, then copy only the total and tax cells into your working file. This works well when you just need figures for a monthly summary.
4. How do I handle invoices from different vendors with different layouts?
Each layout needs its own check, because column order and headers change between companies. Process one invoice from each vendor, note how its columns line up, and use that pattern as your checklist for later invoices from the same source.
📝 Summary
Extracting invoice line items to Excel works well when you first confirm whether the PDF has selectable text, run OCR on scanned invoices, and export the table from the OmniDoc PDF editor. The result is only trustworthy after you match the row count, column alignment and totals against the original invoice.
