List Unique Tokens in Wallet
I have a CSV of 1000 transactions and need a unique list of all Token Symbols (e.g., ETH, BTC, SOL, USDC) from a specific column to analyze my portfolio diversity, track specific assets, or prepare for tax reporting. Manually sifting through 1000 rows to identify unique tokens is time-consuming and prone to errors.
=UNIQUE(B2:B11) How it works: The UNIQUE function efficiently extracts all distinct values from a specified range. By applying `=UNIQUE(B2:B11)` to the 'Token Symbol' column, Excel processes every entry, identifies all unique token symbols, and returns a clean, de-duplicated list. This eliminates the need for manual sorting and filtering, providing an accurate overview of all assets held or transacted.
Data Setup
| Transaction ID | Token Symbol | Amount |
|---|---|---|
| 1 | ETH | 0.5 |
| 2 | BTC | 0.01 |
| 3 | ETH | 0.2 |
| 4 | SOL | 10 |
| 5 | USDC | 100 |
| 6 | BTC | 0.005 |
| 7 | ETH | 0.1 |
| 8 | SOL | 5 |
| 9 | USDC | 50 |
| 10 | ADA | 20 |
Step-by-Step Guide
Import your transaction CSV into Excel. Ensure your data has headers and token symbols are in a dedicated column (e.g., Column B).
Identify the column containing the Token Symbols. For this example, we assume it's Column B, starting from row 2.
In an empty cell where you want the unique list to appear (e.g., D2), type the formula: `=UNIQUE(B2:B11)` (adjust the range `B2:B11` to cover all your token symbol data, e.g., `B2:B1001` for 1000 transactions).
Press Enter. Excel will automatically spill the unique list of tokens into subsequent cells below the formula cell.