I will compare two excel or CSV files and report changed records
About this Gig
Need to see what changed between two spreadsheet exports? I will compare two Excel (.xlsx) or CSV files using one matching ID column and deliver a clear Excel report of added records, removed records and changed cell values, plus a short summary.
Basic scope: two files, one sheet each, up to 500 data rows per file and 20 columns. Please specify the ID column, old/new file order and columns to compare. Text comparisons are exact unless we agree on simple trimming rules.
Missing or duplicate IDs are flagged for review, never silently matched. Originals are preserved. Includes one revision correcting the agreed comparison; new files or additional scope require a separate order.
This is a one-time report, not a live integration, financial audit or fuzzy product-matching service. No macros, password-protected files or sensitive personal, medical or payment information.
I use Python and AI-assisted tools with validation checks. Please message first if the structure is unusual. Delivery: three days after complete requirements.
Technology:
Excel
•
Python
Expertise:
Data manipulation
•
Data validation
