I will do excel data cleaning with python
About this Gig
Send me your messy Excel or CSV file. You get it back clean within 24 hours, with a report of every change I made.
Duplicates, mixed date formats, broken characters, names in CAPS, numbers stored as text: I fix them with Python, not by hand.
What you get:
- Duplicates found and merged, even when spacing or capitals differ
- Real Excel dates and numbers instead of text
- Names, emails, phones and countries in one consistent format
- Several files merged into one clean sheet
- PDF tables converted to Excel, with totals checked
- A change report: every fix listed, rows in = rows out
Why me:
I'm a software engineer with 8+ years of experience. I clean data with tested Python scripts, not by hand, so a big file gets the same care as a small one. Nothing is invented: cells I can't read safely stay as they were and are highlighted for you.
How it works:
- Send your file and tell me what "clean" means for you
- I clean it and check the result in Excel
- You get the clean file plus the change report
Your files are deleted after delivery, and I'm happy to sign an NDA.
Not sure which package fits? Send me your file before ordering and I'll tell you.
My Portfolio
FAQ
Which file types do you work with?
Excel (.xlsx, .xls), CSV and Google Sheets (download it as .xlsx or share a copy). For PDFs, the text must be selectable: scanned or photographed pages need OCR, so send one page first and I'll tell you if it works.
What do I get back?
A clean .xlsx file with a frozen header row and filters, plus a change report sheet: how many rows came in and went out, which duplicates were merged, and every cell that was changed. With Premium you also get the Python script, so you can clean the next export yourself.
Will you change my data?
Only its format. Nothing is invented or guessed: if a value can't be read safely (for example an amount in a different currency), it stays as it was and is highlighted yellow for you to check.
What counts as a revision?
Adjusting the agreed cleaning rules, for example a different date format, keeping a column or a different rule for duplicates. New files or new tasks are a new order or an extra.
Is my data safe?
Your files stay on my computer, are never shared, and are deleted once the order is complete. I'm happy to sign your NDA.
How fast is delivery?
Basic is delivered within 24 hours, often sooner. Extra-fast delivery is available. Very large or very messy files may need a bigger package: send me the file before ordering and I'll confirm.

