I will merge excel files and remove duplicates
About this Gig
Do you have dozens of Excel files that need to become ONE file?
I merge multiple Excel or CSV files into one clean spreadsheet, even when the columns don't match or the headers are named differently.
WHAT YOU GET
- One merged Excel file, ready to use
- A separate file listing every duplicate removed, so you can verify nothing was lost
- A report showing rows per file and how columns were matched
- Three trace columns: source file, source sheet, source row
WHAT I HANDLE
- Different column names: Name / 姓名 / 客户名 treated as the same column
- Different column order, missing or extra columns
- Title rows above the real header row, multiple sheets per workbook
- CSV with wrong encoding (GBK / UTF-8 / BOM)
- Empty rows, extra spaces, full-width characters
- Phone numbers corrupted into 1.38E+10
- Prices like ¥1,234.50 converted to 1234.5
- Dates written three ways normalized to one
- Duplicates inside a file and across files
- A broken file gets skipped and reported, never stopping the job
I test on your actual files before delivering.
Message me before ordering if your files have special rules.
Technology:
Excel
•
Google Sheets
•
Python
Expertise:
Data manipulation
•
Data validation
•
ETL
•
Normalization

