I will convert PDF to excel and check every total against the PDF
Mail merge, Excel templates, PDF to Excel and Python automation
About this Gig
Need a PDF converted to Excel? Send me the PDF (invoice, price list, order or report) and get back a clean Excel file: real numbers, one row per line, split tables joined. Every total is checked against the PDF.
Recent project (an Excel-to-Word tool for a UK property company), 5-star review: "making a very tedious job into an easy fix".
What makes it hold up on real documents: tables that break across pages with the header repeating (the repeats are dropped), subtotal lines sitting in the middle of the document (separated from real line items), numbers written as 1 234 567,89 or 1,234,567.89 (both read correctly), and long item names wrapping inside a cell (kept together).
It also checks its own work: the sum of the extracted rows is compared against the total printed in the PDF, and quantity x price is recomputed for every line. Anything that disagrees is marked in the file, so you see it now, not a month later.
Same kind of PDF every month? Premium adds a converter you rerun yourself.
Not sure it fits? Send one page before you order. I'll reply with the first rows in Excel, free, and tell you whether it's text or scanned.
Convert from:
Convert to:
XLS, XLSX
My Portfolio
FAQ
What if my PDF layout changes next month?
The script maps columns by name, not by position, so small changes usually survive. A completely new layout needs a small update - that is what the Standard package with 3 layouts is for.
Do I need to install anything?
No. Basic and Standard deliver the Excel file only. Premium adds a converter: Python is installed once with a step-by-step guide for Windows, then one line per run. On a Mac, ask me before ordering.
What if a number comes out wrong?
Every total in the PDF is compared with the sum of the extracted rows, and quantity x price is recomputed for each line. Anything that doesn't match is marked in the file, and I fix it within your revisions.
Can you do scanned PDFs?
Sometimes. A scan is a photo of paper, so the text has to be recognised and checked. Send me one page first and I'll tell you honestly whether the result will be reliable, before you pay anything.

