I will automate excel csv json data processing and cleaning with python
Python Automation and Data Developer
About this Gig
Tired of manually cleaning, merging, formatting, or processing the same data files again and again?
I build Python data automation solutions for Excel, CSV, JSON, and other structured files.
I can help you with:
- Excel and CSV data processing
- Data cleaning and formatting
- Removing duplicates and missing values
- Merging or splitting multiple files
- Filtering, sorting, and transforming data
- CSV, Excel, and JSON conversion
- Data validation and normalization
- Automated calculations and report-ready outputs
- Bulk file processing
- Reusable Python scripts using Pandas and OpenPyXL
Instead of fixing the same files manually every time, I can turn your rules into a repeatable Python workflow.
You will receive clean output files, tested source code, and setup instructions based on your selected package.
Please message me before ordering if your dataset is very large or requires complex custom processing rules.
Technology:
Excel
•
Google Sheets
•
Python
My Portfolio
FAQ
Which file formats can you work with?
I primarily work with Excel, CSV and JSON files. I can also handle other structured file formats when they can be processed reliably with Python.
Can you clean messy Excel or CSV data?
Yes. I can remove duplicates, handle missing values, standardize formats, clean columns, filter records and apply custom business rules.
Can you merge multiple files automatically?
Yes. I can create reusable Python workflows that combine multiple Excel or CSV files based on your required structure and matching rules.
Can you convert between Excel, CSV and JSON?
Yes. I can transform and convert structured data between these formats while preserving the fields and structure you require.
Will I receive the Python source code?
Yes. Source code is included so the automation can be reused for future files.
Can you automate a task I currently perform manually every week or month?
Yes. If the process follows repeatable rules, I can usually turn those steps into a reusable Python workflow.
Can you handle confidential business data?
Yes, but you should anonymize sensitive personal or confidential information whenever possible before sharing sample files.

