I was asked if it was possible to audit ethereum blockchain data with Excel. The simple answer is yes, but it depends on the scope of the audit. Auditing wallet transactions in Excel is easy enough, but auditing the code of a smart contract created on the ether blockchain requires a little coding knowledge.
In this video, we will look at connecting Excel to the etherscan API. We will look at the etherscan API documentation and creating endpoints to be used in Excel with a Web query