I will clean, deduplicate and standardize your excel or CSV data
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
FAQ
Will you delete rows?
Only according to the agreed rule. Duplicates are removed and listed in the change log so the action is reversible.
Can you split or merge columns?
Yes. Include an example of the current format and the expected format, and I will document the rule in the change log.
Do you keep formulas?
I preserve formulas where possible. For imports I usually deliver values plus a documented formula sheet.
Can you handle multiple files?
Yes. Send them as one file per order, or several files combined into one with a source column.
What about missing data?
Missing values are flagged, not filled with guesses, unless you provide an explicit fill rule.
