I will merge and clean excel or csv files with power query

India

I speak Hindi, Marathi, English

Excel VBA, Power Query and Python reporting automation

Monthly reports that take a day of copy-paste? I turn them into a tested tool you run in one click. I'm a Process Analyst at Mindful Automations (Mysuru), building RPA, Excel automation and OCR data e...
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:

  1. Send 2-3 sample files (dummy or masked data is fine) and tell me the output you want
  2. 2. I confirm the expected result in writing before starting
  3. 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

Expertise:

Data extraction

•

Data manipulation

•

Data validation

•

ETL

Other Data Processing Services I Offer