Community Tip - You can Bookmark boards, posts or articles that you'd like to access again 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.