Excel/CSV data cleaning and validation

Turn a messy Excel or CSV file into a clear, reviewable table. The base service covers one file and one data sheet, up to 2,000 rows and 20 columns, with consistent formatting, missing-value checks and up to 5 agreed validation rules.

Duplicates are reviewed using your chosen key. Only identical copies or cases covered by your approved rule are removed. Conflicting records are flagged for review; missing values are not invented. The original file is preserved.

Deliverables: an editable cleaned XLSX workbook, a CSV copy of the table, a CSV audit report, and a TXT summary of the rules, changes and before/after row counts.

Included revisions: one (1) revision to correct or clarify the work within the agreed file and validation rules. Additional files or new rules require extra scope. Delivery: 3 days after receiving the file and confirming the rules.

Optional extras: merge up to 3 files with identical columns, up to 5,000 rows in total; or receive a PY Python script, JSON configuration and TXT instructions to repeat the same cleaning locally on a CSV file with the same structure. Python is required; system integrations and APIs are excluded. Large manual data entry, damaged-file recovery and OCR are outside scope. Attached examples use fictional demo data.