I will clean and consolidate CSV files using excel power query
Financial SubLedger and Data Automation Specialist
About this Gig
Are you spending too much time cleaning and combining CSV files in Excel?
I can help you turn messy transaction data into a clean, standardized Excel workbook using Microsoft Power Query.
My services include:
CSV file consolidation
Excel data cleaning and standardization
Inconsistent column header correction
Vendor name standardization and mapping
Date and amount formatting
Duplicate identification
Exception reporting
Refreshable Power Query workflows
I can build a reusable process that helps you handle recurring data preparation tasks more consistently.
Depending on your selected package, you will receive a cleaned Excel file, a Power Query workbook, or a reusable workflow with refresh instructions.
I work with clearly defined requirements and provide written updates throughout the project.
Please contact me before ordering if your files have complex structures or changing column headers.
Let's make your Excel data preparation simpler and more repeatable.
Platform:
Excel
•
Microsoft Office
•
Outlook
Development technology:
Power Query
•
Excel
•
VLOOKUP
My Portfolio
FAQ
What files do you accept?
I accept CSV and Excel files. Please describe the file structure before ordering.
Can you handle different column headers?
Yes. I can standardize different column headers into a consistent structure, depending on the file formats provided.
Will the workbook refresh automatically?
The Power Query workbook can be designed to refresh when new files are added to the designated source folder, subject to the agreed file structure.
Do you work with confidential data?
I can work with client-provided files and follow agreed confidentiality requirements. Please avoid sharing unnecessary sensitive information.
What if my files are more complex than expected?
Please contact me before ordering so I can review the requirements and confirm the scope.

