Browse categories
Explore
Fiverr Pro
English
$
USD
I will write a python script to clean, merge and convert CSV or excel files
Finance, Accounting, Excel, Power BI Python automation for small businesses
I turn messy spreadsheets into dashboards and automations that save hours every week. With a finance and data background and 16 years of hands-on experience in Excel, Power Query, Power BI, and Python...
About this Gig
Messy exports from different systems? I write Python scripts that clean, merge and convert your files into one tidy dataset, every time, with a log of exactly what was fixed.
WHAT THE SCRIPT CAN DO
- Merge files with different column names, delimiters and date formats
- Fix currency text, units, spacing and capitalisation
- Remove duplicates and blank rows, and flag bad records with a reason
- Output clean CSV and a formatted Excel report
- Run with a double-click on Windows; optional schedule and email or Telegram alerts
YOU RECEIVE
Commented source code, a one-click run file, a README, a PDF data quality report and a test run on your sample files.
Message me with 2-3 sample files and the output you need before ordering
Technology:
Excel
•
Google Sheets
•
Python
•
VBA
Other Data Processing Services I Offer
FAQ
Do I need to send my real data?
No. A sample or anonymised file is enough to scope the work. You can remove sensitive values before delivery testing.
Will it work on my version of Excel?
Tell me your version (Microsoft 365, 2019, Mac or Google Sheets) and I'll build for it
Can you update it later?
Yes. Small changes within 14 days of delivery are free; bigger changes can be a new order.
