I will merge excel files and match ids with an exception report
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
FAQ
Will 001 be treated as 1?
No. IDs are matched as text. If a source file has already lost its leading zeros, please provide the intended format; I will not invent missing digits.
What happens to duplicate or missing IDs?
I keep the affected main-table rows and mark them for review. I do not choose an arbitrary match or fill an unknown value.
Do you change the original files?
I return separate output files. Source workbook styling, images and macros are not reproduced by these packages.
Can you handle formulas or complex layouts?
Please send a sample first. These packages use saved values and do not recalculate formulas. Merged headings, multi-row headers and fuzzy matching need a separate scope.
Are the gallery examples client projects?
They are original demonstrations made with simulated records. They show the matching rules and the kind of exception report you will receive.
