You will get your spreadsheets merged, cleaned, and de-duplicated
Project details
Got the same data spread across messy files? I'll combine them into one clean master sheet - duplicates removed (exact and fuzzy matches), formatting standardized, columns aligned, blanks and errors fixed. Perfect for mailing lists, CRM exports, and contact databases. Delivered with a short note on every rule applied, so the result is reproducible and you can trust it. Just send the files and tell me how you want them combined.
Data Tool
Microsoft ExcelWhat's included
| Service Tiers |
Starter
$15
|
Standard
$35
|
Advanced
$70
|
|---|---|---|---|
| Delivery Time | 1 day | 2 days | 3 days |
Number of Revisions | 1 | 2 | 3 |
About William King
Data & Automation Expert | Excel, Google Sheets, Dashboards & Python
San Francisco, United States - 8:05 pm local time
Technical freelancer with a Management Information Systems degree (Ateneo de Manila) and 7+ years in product management, technical pre-sales, and software delivery at fintech and IT firms - including GCash / Globe Fintech (Mynt). I have shipped real products end to end, so I focus on your goal, not just the task.
WHAT I DO BEST
- Excel & Google Sheets automation - dashboards, formulas (VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIFS), pivot tables, auto-calculating templates, and reporting
- Data cleaning & entry - accurate, fast, de-duplicated, and consistently formatted
- Merge, clean & de-duplicate spreadsheets - turn messy multi-file data into one reliable master sheet
- Google Apps Script automation - auto-emails, scheduled triggers, PDF generation, sheet-to-sheet sync
- Custom Python scripts - process or convert data, organize files, collect data into CSVs, and small automations
- Live crypto & stock trackers in Google Sheets - watchlists, portfolio profit/loss, and trading journals (I am an active trader)
- PDF / image to clean Excel or Word - typed and checked by hand, not just auto-converted
- Lead lists & web research - verified, sourced, ready-to-use spreadsheets
- Website features & fixes - contact forms, maps, chat buttons, landing pages, plus speed & mobile fixes (HTML/CSS/JS, React/Next.js)
WHY CLIENTS WORK WITH ME
- Business + technical background - I translate a real-world need into a working solution
- Clear communication and fast replies - I confirm anything unclear before guessing
- Detail-oriented - every entry, formula, and result is double-checked
- Reliable delivery - on time, with a short how-it-works note so you can run it yourself
BACKGROUND & CERTIFICATIONS
BS Management Information Systems (Ateneo de Manila). Product Manager at Mynt / GCash. Technical Pre-Sales Engineer. ITIL Foundation certified. Most recently, Project Director of iCASH - I-Remit's e-wallet - leading development, marketing, and partnerships from concept to production launch, reporting directly to the President.
Available 30+ hrs/week and responsive across time zones. Tell me the task, the source, and the result you want - and I will take it from there.
Send me a message with what you need and I will reply with a clear plan and timeline.
Steps for completing your project
After purchasing the project, send requirements so William King can start the project.
Delivery time starts when William King receives requirements from you.
William King works on your project following the steps below.
Revisions may occur after the delivery date.
Share the files
Send your files and the match/keep rules; I confirm scope and timing.
I merge & clean
I combine the files, remove duplicates (exact and fuzzy), and standardize formatting.