Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
This was a nice overview we did a while back for how to use Excel Power Query to automatically catch problems with descriptions between Creo Parametric Models and ERP Cost Data.
Note: Nitro-BOM is used to facilitate the data extraction from Creo .. BUT the principles shown for Excel Power Query would work regardless of how you get the BOM Data.