I will build a CSV comparison tool to find changes between files


About this gig
See what changed between two CSV files without checking every row by hand. I will build a reusable local browser tool that reports added, removed and changed rows, plus missing or duplicate key exceptions.
STARTER: One key, up to 5 compared fields and 1,000 rows per file. Delivery in 3 days with 1 revision.
STANDARD: A key made from up to 2 fields, 10 compared fields, one absolute numeric tolerance and 10,000 rows per file.
PREMIUM: Three reusable settings files and up to 20 compared fields, with the same row limit. Every run compares two files. Each settings file uses one tolerance for all numeric fields.
Files must be comma separated UTF8 CSVs with matching names for the key and compared columns. Text and keys match exactly, preserving spaces, case and leading zeros.
You supply anonymized samples and expected results. I deliver editable source, checked sample reports and a usage guide. Account connections, data correction and ongoing maintenance are outside this offer.
Commercial use is included. I may reuse my generic framework components. Send your samples through Fiverr before ordering so I can confirm the scope.
Get to know John H
Practical Business Calculators, Spreadsheets and SOPs
- FromUnited States
- Member sinceApr 2023
Languages
English
My Portfolio
Other Software Development Services I Offer
FAQ
What counts as a match key?
A match key identifies the same record in both files, such as an item ID. Standard and Premium can combine up to two fields. Both files need the same key header names. Key values preserve spaces, case and leading zeros.
How are duplicate or missing keys handled?
Missing keys are listed as invalid results. If a key is duplicated in either file, all rows with that key in both files are listed as duplicate exceptions. The tool does not choose or merge an ambiguous match.
Can the tool compare Excel or PDF files?
These packages accept comma separated UTF8 CSV files. Export spreadsheet data to CSV first. The key and compared columns must have matching header names. Native Excel and PDF parsing require a separate scope.
What do numeric tolerances mean?
Standard and Premium use one absolute tolerance shared by all numeric fields in each settings file. A difference equal to the tolerance is accepted. Blank remains different from zero. Text fields always match exactly.
How do I run the tool?
Open the delivered HTML file in the agreed desktop browser and choose the two CSV files. The delivery includes usage instructions and editable source. Hosting and account integrations are outside the offer.
What rights and revisions are included?
Commercial use and editable source are included. Existing generic framework components remain reusable by me. A revision is one consolidated set of changes within the approved columns and supported rules.
What does the Starter package cover?
Two agreed CSV layouts with matching names for the key and compared columns, one key field, up to five compared fields and up to 1,000 rows in each file. You receive a reusable local browser tool, editable source, checked sample reports, instructions and one revision.

