I will clean, transform, and automate your excel data using power query etl
About this Gig
Are messy Excel files, inconsistent CSV exports, or repetitive data tasks slowing down your reporting? I clean, merge, restructure, and transform raw datasets using Excel and Power Query.My services include duplicate removal, date and text standardization, multi-file consolidation, unpivoting cross-tab reports, and automated ETL workflows. Beyond one-time cleaning, I build reusable Power Query steps to simplify recurring tasks and improve consistency.Whether you need analysis ready data, consolidated reports, or refreshable workflows, I tailor each solution to your data structure and reporting needs, delivering organized, reliable results ready for your next steps.
Excel & CSV Data Cleaning
- Remove duplicates & unwanted records
- Standardize dates, text, and values
- Fix column structures and formatting
- Handle blanks and irregular layouts
Power Query ETL & Automation
- Build reusable Power Query workflows
- Automate data preparation
- Merge and append files
- Refresh reports easily
Data Restructuring
- Convert reports into structured tables
- Combine data across worksheets
- Standardize inconsistent tables
- Prepare data for Excel and Power BI
Message me to discuss your Excel and Power Query needs
Technology:
Excel
•
Google Sheets
•
Python
•
VBA
•
Zapier
•
Alteryx
FAQ
What types of Excel and CSV data problems can you fix?
I can remove duplicates, standardize dates and text, correct inconsistent values, fix irregular tables, combine datasets, and restructure raw data for reporting and analysis
Can you combine multiple Excel or CSV files into one dataset?
Yes. I can consolidate multiple files or worksheets, align matching columns, and organize the combined data into a consistent structure.
Can you automate recurring data cleaning with Power Query?
Yes. I can build reusable Power Query steps to automate repetitive transformations and make future updates easier through data refreshes.
Can you restructure cross-tab reports into analysis ready tables?
Yes. I can unpivot cross tab reports, reorganize columns, and convert wide or inconsistent layouts into structured tables suitable for analysis.
What file formats do you accept and deliver?
I work with Excel workbooks (XLSX) and CSV files. Power Query workflows and M code can also be included when supported by your selected package.
What do you need from me before starting?
Please provide your source files, explain the data issues you want fixed, and describe your desired output. If available, include an example of the expected result.
Can you handle large datasets or complex Power Query tasks?
Yes, depending on the file size, data structure, and complexity. Please message me with a sample file and your requirements so I can assess the task before you order.

