I will clean, merge, and transform messy excel data
Modern Excel and Automation Specialist
About this Gig
Data Cleaning & ETL Services:
Are you dealing with messy, unformatted, or duplicate data spread across multiple files and sheets?
Manually cleaning spreadsheets takes hours and introduces costly human errors. I will build an automated Power Query ETL pipeline that cleans, formats, and transforms your raw data into a pristine, structured dataset with just one click.
What I Can Do For You:
- Automated Cleaning: Remove duplicates, unpivot columns, fix formatting mismatches, and remove empty rows.
- Data Merging & Combination: Combine multiple CSV, Excel, or web files into a single unified table.
- Power Query Workflows: Build reusable, automated ETL queries that run seamlessly on new data refreshes.
- Data Structuring: Convert raw text/strings into standardized fields (dates, currencies, clean text).
FAQ
Will I need to re-run the cleaning steps manually when I get new data?
No! Power Query saves all transformation steps. You only need to paste new data into your source file/folder and click Data > Refresh All.
Do I need Excel 365, or does this work on Excel 2016?
Power Query works natively on both Excel 2016 and Excel 365 (as well as Power BI).
What file formats can you clean and combine?
I can process .xlsx, .csv, .txt, JSON, or web exports and combine them into a single clean table.

