Python PDF-Excel Extractor
Budget: ₹1,500 – ₹12,500 INR
I have a set of PDFs where the content I need sits in clearly defined lists; each list represents one invoice. I want a short, reliable Python script that:
• Reads every PDF in a given folder.
• Detects each invoice-style list inside the file (they are plain text, not tables or images).
• Maps specific list items to pre-named columns in an existing Excel workbook.
• Appends each new invoice as a fresh row without disturbing the current data.
The finished deliverable should include:
1. The well-commented .py file built with common libraries such as pdfplumber (or similar), pandas, and openpyxl.
2. A brief README explaining any required installs and how to run the script on my machine.
3. A test run using two sample PDFs that proves every list item lands in the correct column.
Keep the solution lightweight; no GUI is needed—just a command-line script that gets the job done quickly and accurately.
• Reads every PDF in a given folder.
• Detects each invoice-style list inside the file (they are plain text, not tables or images).
• Maps specific list items to pre-named columns in an existing Excel workbook.
• Appends each new invoice as a fresh row without disturbing the current data.
The finished deliverable should include:
1. The well-commented .py file built with common libraries such as pdfplumber (or similar), pandas, and openpyxl.
2. A brief README explaining any required installs and how to run the script on my machine.
3. A test run using two sample PDFs that proves every list item lands in the correct column.
Keep the solution lightweight; no GUI is needed—just a command-line script that gets the job done quickly and accurately.