I will merge excel or CSV lists and flag duplicate records
About this Gig
Merge two Excel/CSV lists and flag duplicates or price differences.
Scope: up to 2 supplied XLSX/CSV files, 100 source rows total and 6 columns per table. Before ordering, we confirm headers, code/price columns and checking rules.
I trim leading/trailing spaces in text, preserve leading zeros in text codes, merge into one XLSX, and flag exact duplicates and conflicting unit prices for the same code.
All source records and numeric zeros stay. No automatic deleting, summarizing, changing prices or guessing missing data.
Deliverables: organized XLSX, original data with row sources, and notes on issues.
7 days, 1 revision within agreed rules. Processing errors are corrected against original files.
No scans/OCR, handwriting, complex formulas/macros, web data collection, financial audits or ongoing automation.
AI-assisted work with script checks and source comparisons. Fictional demo data.
Please message with a small redacted sample first. Remove names, contact details, addresses, bank and identity information. No passwords needed.
FAQ
Will you delete duplicates or choose a price?
I flag matching records and keep all source rows. Conflicting unit prices for the same agreed code are marked for your review. I do not choose a price, delete records or guess missing values.
Which files and data are included?
Up to 2 editable XLSX or CSV files, 100 source rows total and 6 columns per table. We confirm the headers, comparison columns and rules first. No scans, OCR, handwriting, complex formulas, macros, web scraping or ongoing automation.
Will leading zeros, zero values and original data stay?
Text codes keep their existing leading zeros. Numeric zero stays zero; blanks stay blank and are flagged when required. Original values and row sources are retained. Digits already missing from a source file cannot be guessed or restored automatically.

