From AnalogDigital Engineering:
Refinate will put a wider variety of documents into Excel using scripts provided to you, or using scripts you create automatically as you click options describing your intention. And Refinate can be used to: auto-arrange existing or new information into orderly records, manipulate data items, make comparisons and report about each difference, find duplications and present them for editing, list uniques, determine accurate item counts. See details on the Features page. Worksheets can be organized any way you like. Simply select the area you want to operate on and click.
Refinate is an Excel Add-in originally developed to play a critical role in the creation and verification of bill of materials (BOM) for designers and manufacturers of printed circuit boards. Designers and manufacturers will appreciate Refinate's ability to handle reference designators within the generic and ubiquitous environment of Excel. Refinate will inspect the integrity of BOM by checking for a duplication of any part number, any part value, any part description, any reference designator.