Need to compare, clean or reconcile Excel data from different files?
I will transform your structured Excel or CSV data into a consistent format, match records between sources and identify missing, duplicated or conflicting values.
The base service includes:
• up to 2 Excel or CSV source files
• data cleaning and standardization
• matching records by an agreed key or ID
• comparison of agreed fields and values
• identification of missing and mismatched records
• a clear Excel output with reconciliation results
• one revision within the agreed scope
I use Excel and Power Query for repeatable data transformation and validation. Python may be used when it is more efficient for the task.
Please message me before ordering and send an anonymized sample, approximate data volume and a short description of the expected result.
Larger datasets, complex matching rules, automation across many files or custom workflows can be quoted separately.
