I will clean, deduplicate and format your messy excel or CSV data
Python Data Automation, Excel and CSV Cleaning
About this Gig
Got a spreadsheet that's a mess? Send it over and I'll get it back to you clean and ready to use, usually within a couple of days.
I clean up Excel and CSV files: removing duplicates, fixing inconsistent formatting, standardizing columns, and merging lists that don't line up. I work in Python instead of fixing rows by hand, so it's fast, it stays consistent across thousands of rows, and it won't choke on big files the way Excel does.
Stuff I handle a lot:
- Duplicates, and merging multiple lists into one
- Messy formatting, extra spaces, random capitalization
- Dates, phone numbers, and columns that need standardizing
- Turning unstructured or copy-pasted data into a proper table
- (Premium) I'll send you the Python script too, so you can re-run it on future files yourself
I check every file before it goes back to you: row counts, a spot-check of the output. I'm based in the US, I keep you updated(can respond fast), and I don't keep your data after the job's done.
Not sure which package you need? Message me with your file and I'll tell you what's doable and what it'll cost. Happy to take a look.
Technology:
Excel
•
Python
FAQ
What file types can you work with?
Excel (.xlsx and .xls), CSV, and Google Sheets.
Will you delete my data after the job?
Yes. Once you've got your file and you're happy with it, I delete my copy. I don't hold onto anyone's data.

