I will clean, merge and deduplicate your excel files

Taiwan

I speak Chinese, English

Data cleaning, web scraping and automation

I am an electrical engineering student based in Taiwan. I build small, reliable tools for data work: cleaning and merging messy spreadsheets, extracting publicly available web data into tidy CSV or Ex...
About this Gig

Send me your spreadsheet and I will return a clean, consistent file you can actually work with.


What I handle:

- Duplicate rows, exact and near-duplicates

- Merging several sheets or files into one table

- Inconsistent dates, numbers, casing and stray spaces

- Splitting or joining columns such as names and addresses

- Flagging rows that break a rule so you can decide


How it works:

1. You send the file and tell me what "clean" means to you.

2. I confirm the scope and a fixed price before starting.

3. You get the finished file plus a short note on every change.


I work with .xlsx, .xls, .csv and Google Sheets exports. I never share your files with anyone.


------------------------


【中文說明】


把表格交給我,回傳一份乾淨、格式一致、可以直接使用的檔案。


常接的工作:

・移除重複列(完全相同與近似重複)

・多個工作表或檔案合併成一張欄位對齊的表

・統一日期的寫法、數字格式、大小寫與多餘空白

・拆分或合併欄位(姓名、地址、編號)

・標出不符合規則的列,讓你自己決定怎麼處理


流程:

1. 你傳來檔案,告訴我「乾淨」對你來說是什麼樣。

2. 我先確認範圍並報固定價格,開始後不加價。

3. 你收到完成的檔案,附上簡短的修改說明。


支援 .xlsx、.xls、.csv 與 Google Sheets 匯出檔,檔案不外流。

Technology:

Excel

•

Python

•

VBA

Expertise:

Data manipulation

•

Data validation

•

ETL

•

Normalization