I will merge and clean excel or csv files with power query
Excel VBA, Power Query and Python reporting automation
About this Gig
Monthly, branch or vendor files arriving in different shapes? Copy-pasting them into one file wastes hours and hides errors.
I build a tool that merges your Excel or CSV files into one clean, checked workbook:
- Every row keeps its source file name, so you can trace any number back
- - Different column headers are mapped to one standard layout
- - Totals are checked against the input files (PASS/FAIL)
- - Blanks, duplicates and text-in-number-columns are listed on an Issues sheet instead of slipping through
- - Premium: a one-click rerun tool, so next month takes seconds
Built with Excel Power Query, VBA or Python (pandas), whichever fits how your team works.
How it works:
- Send 2-3 sample files (dummy or masked data is fine) and tell me the output you want
- 2. I confirm the expected result in writing before starting
- 3. I build, test against your totals and deliver with a short guide
All communication is in writing, so every requirement is documented. Please message me before ordering if your files are unusual.
Technology:
Excel
•
Python
•
VBA
Other Data Processing Services I Offer
FAQ
Is my data safe? Can I send dummy data?
Yes. Dummy or masked files with the same layout are enough to build and test the tool. I never share your files and delete them after delivery on request.
Which Excel version do I need?
Power Query and VBA tools work in Excel 2016 or Microsoft 365 on Windows. Tell me your version before ordering; for an older version or a Mac, I can build a Python version instead.
