I will clean, merge and automate csv and excel files with python
About this Gig
Exports from different tools never match: different delimiters, date formats, prices stored as text, duplicates and typos. I write a Python script that fixes all of it and merges everything into one clean table - and you can run it again next month with one command.
What you get:
- A tested Python script (pandas / openpyxl)
- Clean output as CSV or formatted Excel
- A log of what was fixed (duplicates, empty rows, formats)
- Short instructions to run it yourself
Supported formats: CSV, XLSX, XLS, TXT and JSON.
Every script is tested with your files before delivery. Not sure which package fits? Send me 1-3 sample files and I'll confirm what's possible and the exact price before you order.
My Portfolio
FAQ
Do I need to install Python?
Only if you want to run the script yourself - I include simple setup steps. You always get the cleaned file as well.
Is my data safe?
I only use your files for your order and delete them once the order is completed. You can also send anonymized sample data.
My files are bigger than 10,000 rows. Is that a problem?
No. Python handles large files easily. Message me with the size and a sample and I'll send you a custom offer.
Can I run the script again next month?
Yes. You get the script with short instructions. As long as new files have the same structure, one command processes them again.
Which output formats can I get?
CSV or a formatted Excel file (XLSX), plus a short log of what was fixed. Another format such as JSON on request.

