I will clean, merge and deduplicate your excel files
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

