I will audit excel and CSV data for missing duplicates and conflicts
Data Analysis and Automation Specialist
About this Gig
I will audit your Excel or CSV data to identify missing records, duplicates, conflicting values, and other inconsistencies.
This service is ideal when two business exports should match but do not, such as order data, inventory records, ERP exports, fulfillment data, product lists, or operational reports.
I can check for:
Missing and unmatched records
Duplicate records
Conflicting field values
Quantity, price, status, date, SKU or ID differences
Custom validation rules
You will receive:
A structured exception report
Clearly identified records requiring review
A summary of detected issues
Clean, review-ready Excel/CSV output
Package limits refer to the maximum dataset size I will audit. Items Cleaned refers to the number of detected items that can be corrected or processed within the package.
Please contact me before ordering if your project involves databases, APIs, PDFs, OCR, web scraping, or unusually complex business rules.
FAQ
1. What file formats do you accept?
I accept Excel (.xlsx/.xls) and CSV files. Please contact me before ordering if your data is in another format.
2. What types of data issues can you detect?
I can identify missing records, duplicates, unmatched IDs, conflicting field values, quantity or price differences, status or date inconsistencies, and custom rule violations.
3. What if I do not know which fields should be used to match records?
Send the files and explain what each dataset represents. I can review the structure and recommend a suitable matching key.
4. Is my business data kept confidential?
Yes. Your files are used only to complete the order and will not be published as portfolio examples. Public samples use simulated data.

