I will extract data from PDF invoices to excel, json or csv with python
Python Automation and PDF Data Extraction
About this Gig
Still copying invoice data from PDFs into Excel by hand?
I build a Python tool that reads a whole folder of PDF invoices, statements or purchase orders and turns them into a clean, formatted Excel file (plus JSON and CSV) in seconds.
What makes it different: every document is VALIDATED. The tool checks that quantity x price matches each line amount, that the lines add up to the subtotal, and that subtotal + tax matches the printed total. Anything that does not add up is flagged for review instead of silently entering your books.
You get source code with a clear README and automated tests, an Excel file with Invoices, Line Items and Validation sheets, support for multiple vendor layouts, currencies and number formats (1.249,00 EUR or $1,249.00), and normalised dates and amounts without rounding errors.
Typical result: 200 invoices a month = 13+ hours of manual typing saved every month.
Please send 3-5 sample documents (you can blur sensitive data) before ordering so I can confirm the right package. Demo project available on request.
Technology:
Excel
•
Google Sheets
•
Python
Expertise:
Data extraction
•
Data validation
•
ETL
•
Transformation
FAQ
Do you work with scanned PDFs or photos?
Yes, with OCR in the Premium package. Accuracy depends on scan quality, and the validation report flags anything uncertain.
What if my vendor changes the invoice layout?
Adding or updating a layout is a small extra, or it is included if you take monthly maintenance.
Is my data safe?
Your documents are used only to build and test your tool and are deleted after delivery. You can also send anonymised samples.

