All Collections
Etherscan tutorials
Etherscan data in Excel & Googlesheets using Cryptosheets
Etherscan data in Excel & Googlesheets using Cryptosheets

How to pull Etherscan data into Excel to analyze a Bitfinex ETH exchange wallet

Written by Chris Ware
Updated over a week ago

Using Etherscan data in Cryptosheets

This article demonstrates two examples of how to pull Etherscan data into your spreadsheet using the side panel console  and custom functions .

You can currently pull 15 endpoints from Etherscan into Cryptosheets including: 

Address balance, Addresses Balance, Address normal transactions, Address internal transactions, Internal transactions by hash, ERC20 token transfers, Blocks mined by address, Contract execution status, Transaction receipt status, Block & Uncle rewards, ERC20 token supply by address, ERC20 token contract balance, Total supply of Ether, ETH last price, Ethereum nodes size

Explore more Etherscan endpoints here

Although Etherscan has 15 available endpoints, we will use ERC20 token transfers as our example.


Get a list of "ERC20 - Token Transfer Events" by Address

Example data returned:

  • blockNumber     

  • timeStamp     

  • hash     

  • nonce     

  • blockHash     

  • from     

  • contractAddress     

  • value     

  • tokenName     

  • tokenSymbol     

  • tokenDecimal     

  • transactionIndex     

  • gas     

  • gasPrice     

  • gasUsed     

  • cumulativeGasUsed     

  • input     

  • confirmations   



  1. Install the Cryptosheets add-in from Microsoft AppSource Store
  2. Make sure you are logged into your Cryptosheets account


Using the console

  1. From the Cryptosheets ribbon click data
  2. Type in type in "Etherscan..." then click on ERC20 token transfers
  3. Scroll through the console parameters and input your values
  4. Select the cell you want to place the data into
  5. Click make request


Using custom functions

  1. In any cell type the following:
=CS.QUERY("Etherscan","ERC20 token transfers",{"action","tokentx";"address","0x742d35cc6634c0532925a3b844bc454e4438f44e";"apikey","YourApiKeyToken";"startblock","0";"endblock","5525612";"module","account";"sort","asc"})

If you need help remembering the exact parameters for any function, you can always just type in any cell:
=CS.PARAMETERS("Etherscan","ERC20 token transfers")

*Note: you must have one of the supported versions of Microsoft Office or Excel for custom functions to work

Helpful Resources:

Visit the API documentation for Etherscan here

Troubleshooting: please reference the following troubleshooting code: PAR-1292-489
Learn more here
Tags: ether,explorer, Etherscan, bitfinex, exchange, wallet,excel, googlesheets, spreadsheet 

Did this answer your question?