The Scenario
You're a DeFi analytics researcher building a token reference database. Your reports pull contract addresses constantly — VLOOKUP against a master list to find the right ERC-20 for a given symbol on a given network. The problem is that master list lives in your head and a dozen browser bookmarks, not in a workbook. A new analyst joined the team last week and has already asked you for contract addresses four times. You need the full Poof supported token list in an Excel workbook so anyone on the team can use it.
The bad version:
- Open the Poof documentation or API explorer, manually copy contract addresses and token names for Ethereum one by one.
- Repeat for Polygon. Repeat for Avalanche.
- Realize mid-way through that the formatting is inconsistent across networks and you need to normalize it before the workbook is usable as a VLOOKUP reference.
- Finish three hours later with a list that's already slightly out of date because new tokens were added while you were doing this.
A token reference database built by hand is a database that's wrong the moment it's finished.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It understands your request, connects to Poof through its built-in integration, and pulls the complete supported token list across all networks into a structured worksheet — with the columns you need for VLOOKUP queries.
Pull the complete list of supported Poof tokens into my Excel workbook, then split them into three separate tabs — one each for Ethereum, Polygon, and Avalanche.
What You Get
- Three worksheets created — Ethereum, Polygon, and Avalanche — each containing the supported tokens for that network.
- Columns for token name, symbol, and contract address in each worksheet — ready for VLOOKUP or XLOOKUP queries.
- If Poof returns a partial list for a network, that network's worksheet includes a note at the top so you know coverage is incomplete.
- Existing data in the workbook is untouched.
What If the Data Is Not Quite Ready
You need all tokens in one flat worksheet rather than split by network
A single worksheet is easier to query with VLOOKUP when your reports don't need network-level isolation.
Fetch all supported ERC-20 smart contracts from Poof across all networks and import them into a worksheet called 'Token Contracts' with columns for token name, symbol, contract address, and network.
Some token symbols appear on multiple networks and you need a dedup view
The same symbol like USDC appears on Ethereum, Polygon, and Avalanche with different contract addresses, which breaks a naive VLOOKUP.
Fetch all supported tokens from Poof and import them into a 'Token Contracts' worksheet. Then create a second worksheet called 'Symbol Index' that lists each unique symbol once, with one column per network showing the contract address for that network (or blank if the token isn't on that network).
You need to cross-reference against your existing position data
Your 'Portfolio' worksheet has token symbols in column A and you want a VLOOKUP formula populated that pulls the contract address from the token reference worksheet.
Fetch all supported Poof tokens and import them into a 'Token Contracts' worksheet with columns for symbol, contract address, and network. Then in my 'Portfolio' worksheet, add a VLOOKUP formula in column E that pulls the Ethereum contract address from 'Token Contracts' for each symbol in column A.
The full import-plus-validate kill chain
You want the full token list imported, duplicates across networks normalized into a single symbol index, and any symbols in your 'Portfolio' worksheet that aren't in the Poof list flagged.
Fetch all supported Poof tokens across all networks and import them into a 'Token Contracts' worksheet with columns for name, symbol, address, and network. Create a 'Symbol Index' worksheet that deduplicates by symbol with one column per network. Then check every symbol in column A of my 'Portfolio' worksheet against the Symbol Index and write 'Not in Poof' into column F for any symbol that doesn't appear in the index.
Running the import, the dedup, and the validation in one prompt gives you a complete reference database with gap analysis in one step.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you need a structured token reference table — whether you want a single flat list or network-split worksheets with a dedup index — and ask it to pull the Poof supported contract list in one pass. You can also see how SheetXAI handles refreshing live crypto prices in an Excel portfolio tracker or return to the full Poof integration overview for Excel.