Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. 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.