PDF to Excel Sales Report
A Python script that turns messy sales PDFs into a usable spreadsheet, with fuzzy matching for inconsistent product names.
A small internal tool: it reads sales reports exported as PDF and writes them into an existing Excel workbook, matching each line back to the right product row.
The interesting part is not the parsing — it is that product names in the PDF never quite match the names in the spreadsheet. Extra spaces, different abbreviations, inconsistent capitalisation. Exact string matching fails almost immediately, so names are normalised first and then matched with fuzzy string similarity, with anything below the confidence threshold written to a separate warnings file for a human to check rather than silently guessed.
Not a product, and not meant to be. It replaced an afternoon of manual copying every month, which was the entire point.
Stack
Python · pdfplumber · pandas · openpyxl · RapidFuzz