I will clean excel or CSV data merge files and remove duplicates
Lead research, spreadsheet cleanup and practical website fixes
About this Gig
Turn messy Excel or CSV files into one clean, usable spreadsheet. I merge compatible files, standardize agreed columns and remove exact duplicates without losing conflicting records or leading zeros in text IDs.
You receive a cleaned CSV or new Excel workbook plus an audit file with row counts, duplicates and conflicts. Your originals stay unchanged.
Basic: 100 rows, 1 file, 3 days.
Standard: 5,000 combined rows, up to 3 files, 4 days.
Premium: 10,000 combined rows, up to 5 files, 5 days.
All include up to 20 columns and one revision under the original rules.
Send your files, desired output columns and the rule that defines a duplicate. If matching IDs contain different values, I flag them for review rather than guess.
This covers values-only tables. Formulas, macros, preserved styling, scans, fuzzy matching and web research need separate review. Message me before ordering if your files may not fit.
See the self-initiated, fictional-data portfolio sample for the cleanup approach.
My Portfolio
FAQ
What happens if two records have the same ID but different values?
I separate conflicting versions for your review rather than choosing an arbitrary winner. We agree on the exact duplicate key before work begins. Fuzzy matching and guessing missing values are not included.
Can you preserve Excel formulas, macros or the original formatting?
This service handles tabular values only and creates a new clean file. Formulas, macros, charts, original styling and scanned documents are excluded. Please send values-only XLSX or CSV files and identify the worksheet to use.

