I will clean, deduplicate and standardize your excel or CSV data

China

I speak English, Chinese

auto

Data extraction and automation specialist. I turn scanned invoices, PDF reports and supplier price lists into validated Excel or CSV with agreed fields, correct units and a clear list of unresolved ro...
About this Gig

Messy spreadsheet? I clean, deduplicate and standardize Excel or CSV files so the data can be filtered, imported or reported on without manual fixes.

What I fix:

  • duplicate rows and near-duplicates
  • inconsistent names, casing and whitespace
  • mixed date formats and currency symbols
  • numbers stored as text
  • missing values, flagged rather than invented
  • inconsistent column order and headers
  • blank rows, merged cells and broken exports

What you receive:

  • cleaned .xlsx or .csv in your column order
  • a short change log: rows before/after, duplicates removed, values normalized
  • an exceptions sheet for records that need your decision

I work from a written rule set agreed before cleanup, so "correct" is defined by you, not guessed. Typical files: customer lists, product catalogs, survey exports, bank/transaction exports, CRM downloads.

Send a sample (10-20 rows), your required columns and the rules you care about. Replies within 12 hours (UTC+8). AI tools assist; every file is reviewed before delivery.

Type:

Convert data

•

Data cleaning

Tool:

Excel

•

Google Sheets

My Portfolio