I will clean and automate excel CSV files with python
About this Gig
Are you dealing with messy Excel or CSV files that take too much time to clean manually?
I can help you clean, organize, and automate your spreadsheet data so it is ready to use.
What I can do:
- Remove duplicate rows
- Fix inconsistent column names
- Standardize dates, prices, product names, and categories
- Clean empty rows, extra spaces, and formatting issues
- Merge or split CSV and Excel files
- Create a simple summary report
- Build a reusable Python script for repeated cleanup tasks
You will receive a cleaned file and clear notes about what was changed. For automation packages, I can also provide a simple script with usage instructions.
Please send a sample file and tell me what result you want before ordering if your data is complex.
My Portfolio
FAQ
What should I send before ordering?
Please send your Excel or CSV file, the columns you want cleaned, the rules to follow, and the output format you need.
Can you build a reusable cleaning script?
Yes. For the automation package, I can provide a Python script and simple instructions so you can run the same cleanup on future files.
Do you work with large or complex files?
Yes, but please message me first for files with many columns, very large row counts, or unusual rules so I can confirm scope and timeline.
