How to find holders of your NFT collection
Links: Telegram | Discord | Membership NFT
Related Articles
This article will cover the following:
- How to find the Proton accounts of NFT owners for a particular collection.
- How to use & process API data into a digestible form in Excel.
Find Proton Account Owners of NFTs from Collection
1. ProtonMint
- Navigate to your collection on https://protonmint.com/ by searching in the search bar, or clicking your username in the top-right and going to My NFTs.
- Scroll down and find the greyed-out Holders tab. Click it.
- Download the CSV of your holders and manipulate in Excel.
Excel document gives Proton account name and # of NFTs from collection owned.
2. Soon.Market
- From Soon.Market search in search bar and open collection page.
- Click the people icon on the collection page.
- There is no csv export, and copy/paste is not viable due to formatting.
3. API Query
This site made by pink.network has tons of data available.
https://proton.api.atomicassets.io/docs/#/accounts/get_atomicassets_v1_accounts
Each section is straight-forward. “Collections” returns collection data. “Accounts” returns account data, and so on.
To find holders of a particular collection, go to Accounts > Get Accounts which own atomicassets NFTs.
Enter in collection ID and click Execute (blue bar) at the bottom.
If you don’t know your collection ID, find it from Proton Mint or Soon.Market.
Processing API Data in Excel.
You may be asking why we’re doing this if we can just pull it from ProtonMint.
There isn’t really a great reason, although some may feel it’s a more raw data source and more trustworthy. It may be useful to know how to parse some of this data in Excel in case you use it for more than just holders accounts.
- Create an Excel Worksheet
- In Column A (API) paste your holders API data. It looks like the following:
3. In Column B (Accounts), copy the first account data from the API, and paste in B2. From B3 and down, use the following formula.
=OFFSET($A$6,ROW(B1)*4,0)
4. In Column C (# of assets), copy the first account’s # of assets from the API and put in C2. In C3, use the following formula and copy it down.
=OFFSET($A$7,ROW(C1)*4,0)
5. In Column D (Holders, clean list), use Find & Replace.
- Find and Replace: “assets”:
- Find and Replace: “
- Note there may be spaces you will need to include in the Find and Replace string
6. In Column E (Holder’s # of assets), do the same as above.
Final Product
Hopefully that helps you in other cases where you need to parse some of this data!
See our Related Articles
Cheers,
Blake | The Community DAO & Proton Skulls
