Extracting data from the material libraries’

Hi we have several custom material libraries’ the problem is that they have not been audited in a long time. I would like to extract the data that I need to check using a excel power query. I know this is more of an Excel question, but I am hoping that someone has had this problem before.