Develop python script to scrape PDF Invoice Data to Excel
Budget: $30 – $250 USD
I have a batch of invoices saved as PDFs, all produced from the same template, and I want their key details funnelled straight into an Excel workbook. I’m looking for a clean Python solution—something I can run locally, point to a folder of files, and receive an .xlsx file with each invoice on its own row.
Because the layout never changes, the script can rely on fixed coordinates, regex patterns, or a table-extraction library (pdfplumber, tabula-py, PyPDF2—whichever you prefer) without having to account for format drift. Pandas and openpyxl for the final write-out to Excel make sense, but I’m open to alternatives if they streamline the job.
Deliverables
• Python script (well-commented)
• Sample Excel output generated from two or three dummy invoices so I can confirm column mapping
• Quick read-me explaining prerequisites and how to run the script from the command line
Acceptance
If the sample run captures all required fields from every test invoice and writes them to the correct Excel columns in one go, the job is done.
Because the layout never changes, the script can rely on fixed coordinates, regex patterns, or a table-extraction library (pdfplumber, tabula-py, PyPDF2—whichever you prefer) without having to account for format drift. Pandas and openpyxl for the final write-out to Excel make sense, but I’m open to alternatives if they streamline the job.
Deliverables
• Python script (well-commented)
• Sample Excel output generated from two or three dummy invoices so I can confirm column mapping
• Quick read-me explaining prerequisites and how to run the script from the command line
Acceptance
If the sample run captures all required fields from every test invoice and writes them to the correct Excel columns in one go, the job is done.