I will merge excel files and match ids with an exception report

China

I speak Chinese

Spreadsheet processing and small web tools

I build small tools for repetitive spreadsheet tasks, including combining files, matching records by ID, and checking missing or duplicate keys. My original demo projects show how I preserve identifie...
About this Gig

Need several spreadsheets combined, or product IDs matched to a reference list?


I will process your XLSX or CSV files and return a checked result with a separate list of records that need attention.


Choose a file merge, an exact ID match, or both. For a merge, columns are aligned by their names and source details are included. For matching, I preserve IDs such as 001, keep your main-table rows, and flag duplicate keys, missing keys and unmatched records instead of guessing.


You receive the result, an exception list where applicable, and a short note explaining the agreed rules and record counts.


Please send an anonymized sample and your desired output before ordering. Files need a single header row and one table per sheet. Up to 50 columns; 5 MB per file and 20 MB total. Formula recalculation, original workbook styling, macros, OCR, fuzzy matching and dashboards are outside these packages.


The gallery uses original simulated data, not customer records. One revision covers adjustments within the agreed scope.

My Portfolio