I will merge excel files and remove duplicates

China

I speak English

Excel Data Processing Specialist

I turn messy spreadsheets into one clean file you can use. Most of my work is merging Excel/CSV files: different column names, missing columns, broken encoding, phone numbers turned into 1.38E+10, da...
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