I will clean and deduplicate your messy spreadsheet

China

I speak Chinese, English

AI Automation Data Structuring Specialist

I build order out of messy data. Data extraction: PDFs, scans, websites and spreadsheets turned into clean, searchable Excel or CSV. Automation: Python, Google Apps Script and Sheets workflows that ...
About this Gig

Messy spreadsheet? I clean it up so you can actually use it.


I've merged 160,000 product records from two e-commerce sites into

one clean file 98.6% of fields complete, and the missing 1.4%

documented rather than filled in with guesses.


WHAT YOU GET


· Duplicates removed exact ones deleted, near-matches flagged

in a separate column so you decide, not me

· Formats standardized dates to one format, phone numbers to one

format, names to consistent case, trailing spaces gone

· Clean .xlsx or CSV out, plus a change log of every field I touched


HOW I WORK

1. You send one file Excel, CSV, a Google Sheets export, or a

scanned PDF. If it's a scan, send one page first so I can tell

you what accuracy to expect.

2. I clean it, then check my own output against your original:

row count before and after, what was removed, what was fixed.

You get that report with the file.


WHAT I WON'T DO

I won't invent a value I can't verify. If a field is genuinely

missing, you get a list of exactly which rows, and you decide.

I won't touch formulas, macros or pivot tables unless you tell me to.

I won't promise 100% accuracy no one honestly can. What I do

promise is that every problem I find gets report

My Portfolio