Pulling transaction Data in an excel / google sheets

Hi All,

I currently have a list of wallets in excel and I am trying to get the last transaction date for each of the wallets to see if its still active. Does anybody know any easy ways to accomplish this?