I will extract tables from pdf files into clean excel or csv
Python automation for data, documents and recurring reports
About this Gig
You have a PDF full of tables (reports, invoices, catalogue sheets, statements) and you need the numbers in a spreadsheet, not retyped by hand.
I extract those tables into Excel or CSV and fix the parts that always break: merged header cells, multi page tables split across pages, rows that wrap onto two lines, and columns that shift after the first page.
WHAT I HANDLE
- Text based PDFs, batches of up to 50 files
- Borderless tables detected by whitespace, not just drawn gridlines
- Multi row headers flattened into one clean header row
- Numbers kept as numbers: no stray spaces, no text formatted amounts
- One sheet per file, or everything merged with a source column
WHAT YOU GET
- .xlsx or .csv ready to import into Excel, Sheets, Power BI or your ERP
- A before and after sample from your own file before you accept
- A short list of any table I could not extract reliably, so nothing is silently missing
If your PDF is a scan with no text layer, tell me up front. I price OCR separately and show you a test page first.
Technology:
Excel
•
Google Sheets
•
Python
Expertise:
Data extraction
•
Data manipulation
•
Data validation
My Portfolio
FAQ
Do you sign an NDA?
Yes, always, before any files are shared. I can sign yours or send mine.
Can you do a free sample page?
Yes. Send one page and I return it converted, so you can check accuracy before ordering.
What about scanned PDFs?
Supported through OCR, priced separately, and I always show a test page first.
Do you keep my files?
Files are deleted within 48 hours of delivery and never shared or reused.
Can you automate this monthly?
Yes. I can hand over a small tool you run yourself, or keep running it for you.
