Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. 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.