You will get your messy spreadsheet cleaned, formatted, and de-duplicated
Project details
Send me your messy export and I'll return clean, consistent, analysis-ready data - duplicates removed, dates and text standardized, numbers fixed, and blanks resolved by a clear rule (nothing guessed). I work on a copy of your data, never the original, and deliver a short note on every change so the result is reproducible and trustworthy. Excel or Google Sheets, any size. Perfect prep before reporting, analysis, a CRM import, or a mail merge.
Data Tool
Microsoft ExcelWhat's included
| Service Tiers |
Starter
$25
|
Standard
$55
|
Advanced
$110
|
|---|---|---|---|
| Delivery Time | 2 days | 3 days | 5 days |
Number of Revisions | 2 | 3 | 5 |
Number of Pages Mined/Scraped | 1000 | 10000 | 50000 |
Number of Sources Mined/Scraped | 1 | 1 | 1 |
About William King
Data & Automation Expert | Excel, Google Sheets, Dashboards & Python
San Francisco, United States - 5:30 am 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.
Send your file
Share the spreadsheet (or a sample) and any cleaning rules you have in mind.
I clean & standardize
I dedup, standardize formats, fix text-numbers, and resolve blanks by a clear rule.