I will clean and merge excel or csv data with python
Full Stack Developer, Web Scraping, Bots and Automation
About this Gig
Messy spreadsheets slowing you down? I'll clean, merge and transform your Excel or CSV data with Python, quickly and accurately.
What I can do:
- Fix names, casing, spacing, dates, numbers and phone or email formats
- Remove exact and near-duplicate rows
- Merge many files or sheets into one clean dataset
- Split or combine columns, lookups, pivots and calculations
- Flag missing or invalid values instead of silently dropping them
- Handle large files that Excel struggles with
What you get:
- A clean Excel or CSV file, ready for analysis or import
- A short report of every change made
- On request, a Python script you can run again next time
Please send me a message before ordering with a sample of your data and what the final file should look like.
My Portfolio
FAQ
What file types do you accept?
Excel (.xlsx, .xls), CSV, Google Sheets exports and JSON. Other formats are possible, just ask.
How big can my files be?
Python handles files far larger than Excel can open. Check the package limits; larger jobs are welcome as a custom offer.
Will you change my original data?
Never. I work on a copy and report every change. Rows that can't be fixed are flagged, not deleted.
Is my data kept private?
Yes. Your files are used only for your order and deleted after delivery if you ask.
Can I reuse the cleaning later?
Yes. The Reusable Script package includes a Python script that repeats the same cleaning on new files.

