I will convert PDF or CSV exports into a clean excel report with python
Data Science and AI Bachelor Data Analyst
About this Gig
Stuck retyping tables from PDF or CSV exports into Excel? I will convert them into a clean, validated Excel report.
I build Python tools that read system-generated PDFs (text you can select, exported from an ERP, billing or similar system) and messy CSV exports, then deliver one tidy Excel table you can filter, sum and reuse.
What I can do:
- Extract tables from multi-page documents, removing repeated headers
- Merge many files into one sheet, with source file and page
- Fix number, date and currency formats (e.g. 1.234,56 to 1234.56)
- Add a validation sheet that checks item counts and totals
- Deliver Power BI-ready tables (clean columns, one row per record)
Stack: Python, pdfplumber, pandas, openpyxl.
Only system-generated files with selectable text are accepted. Scanned or photographed files are not part of these packages.
Delivery includes the source code, a short run guide and the Excel output built from your files. Message me with a sample file (dummy data is fine) before ordering so I can confirm scope.
Custom work is yours; reusable base code is licensed to you for unlimited internal use.
Technology:
Excel
•
Python
Expertise:
Data extraction
•
Data manipulation
•
Data validation
FAQ
Can you convert scanned PDFs?
Not in these packages, which accept only system-generated PDFs (selectable text). For scanned PDFs, send a sample first; if it is workable, I will quote it as a custom offer.
Do you have an example I can see?
Yes, a demo project with fictional data: 4 sample documents (6 pages) turned into one Excel table with 172 items, plus a validation sheet that checks counts and totals against each file. See the gallery.
How do I know the numbers are correct?
When your file has control totals, I add a validation sheet that compares item counts and sums per file and flags any difference. Without totals, I check a sample of rows.
Can I reuse it for next month's files?
Yes, if the layout stays the same. Standard and Premium deliver a script you run again on new files.
Can we have a call?
All communication is written, through Fiverr messages. You get clear written updates at each step, and every question gets a written answer, so nothing is lost and you can check it later.

