I will clean and consolidate CSV files using excel power query

Canada

I speak Chinese, English

Financial SubLedger and Data Automation Specialist

I am an accounting-trained data specialist with a diploma from SAIT. Unlike generic programmers, I deeply understand financial sub-ledgers, bank reconciliations, and e-commerce payouts. I use Excel ...
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

Expertise:

Formatting

•

Pivot tables

•

Power Query

•

Cleaning

My Portfolio