1Four ways out, and which to pick
Explorer 2.0 shows an address's history on screen twenty rows at a time. To work with it elsewhere you want a file. There are four, and they all contain the same rows: one per transaction that changed the address's balance, newest first, dated in UTC.
| You want to | Use | Where it comes from |
|---|---|---|
| Open the history once in Excel, Numbers or a text editor | The CSV button | Built in your browser from the address page |
| Keep a spreadsheet that updates itself, with a price and value per row | The CSV link | Divi's public server, one URL per address |
| Import into CoinTracker for tax | The CoinTracker CSV | Same server, same URL with .cointracker.csv |
| Import into accounting software that reads bank statements | The OFX statement | Same server, ofx/ path |
Everything here reads public data and needs no account, password or wallet. You can export any address, not only your own. This tutorial uses the Divi faucet's testnet address, yJehBfdK9KbrwPRjYrzkrPES9uG5nFLjY4, which had 26 transactions on 2026-10-21; swap in your own mainnet address when you follow along.
3What the columns mean
The first two lines of the faucet address's file on 2026-10-21:
Date,Type,Amount (DIVI),Other Address,TxID,Block Hash 2026-10-21 15:36:16,IN,999.90,y85mC8GS4rc7JUBV428Lw3X7T6ev8yTAdN,8ae89982…,93c22b1c… 2026-10-17 11:15:09,STAKE,166.00,,98591fb5…,caff7e6f…
| Column | Meaning |
|---|---|
| Date | When the block holding the transaction was made, in UTC, as YYYY-MM-DD HH:MM:SS. |
| Type | IN coins arrived; OUT coins left; STAKE the address won a block; SELF the address paid itself. |
| Amount (DIVI) | How much the address's balance changed. Positive for IN and STAKE, negative for OUT. A plain number with no thousands separators, so spreadsheets read it as a number. |
| Other Address | Who the coins came from or went to, when there is one other party. Empty for a stake. |
| TxID | The transaction id. Paste it into the explorer's search box to open the transaction. |
| Block Hash | The id of the block holding the transaction. |
When an address wins a block, the coins it staked go back to the same address with the reward added. The file does not show the whole stake moving; a STAKE row's amount is only what was gained. The faucet address's stakes on testnet are 166 DIVI each; on mainnet the per-block reward has changed over the years (the lottery vault's recent stakes show 415 DIVI, older ones 498 and 581). On the rules see How staking works.
The sum of all Amount values is the address's balance today, which is a quick way to check that a file is complete.
4A CSV link with prices
Divi's public server can build the same file for you, so a spreadsheet can fetch it fresh every time it opens. The address goes into the URL:
# mainnet https://services.divi.domains/api/rpc/csv/<address>.csv # testnet https://services.divi.domains/api/testnet/rpc/csv/<address>.csv
Open the faucet address's link in a new tab and you will see the CSV text itself. The rows are byte for byte what the button produces. The server keeps a copy for ten minutes, so a transaction that confirmed a moment ago may take up to ten minutes to appear.
Add a price and a value to every row
Add ?vs= and a stablecoin name in lower case to the link, and two columns are appended: DIVI's price that day in that currency, and the row's value at that price, which is the figure tax software wants.
https://services.divi.domains/api/rpc/csv/<address>.csv?vs=usdt
Date,Type,Amount (DIVI),Other Address,TxID,Block Hash,Price (USDT),Value (USDT) 2026-10-21 15:36:16,IN,999.90,y85mC8GS…,8ae89982…,93c22b1c…,0.00091783,0.91773426
Accepted names are usdt, usdc, dai, pyusd, fdusd, eurs and usd. Prices go back about a year; older rows leave the two columns blank. Upper case is rejected with the message unknown stablecoin "USDT"; try one of usdt, usdc, ….
The easy way to get the link
On the address page open the Staking Intelligence tab and scroll to Your books may look different. Under it is the full link for the address, valued in whichever currency you picked under Show value in, with a copy button and a Download CSV button.
In Google Sheets, put =IMPORTDATA("…the link…") in a cell and the sheet refetches the history on its own. The step-by-step for Sheets and Excel, with a ready template, is in Staking returns.
5CoinTracker import
Change the end of the link from .csv to .cointracker.csv and the server writes the same rows in the layout CoinTracker's Add wallet or exchange → Import from CSV expects:
https://services.divi.domains/api/rpc/csv/<address>.cointracker.csv
Date,Received Quantity,Received Currency,Sent Quantity,Sent Currency,Fee Amount,Fee Currency,Tag 10/21/2026 15:36:16,999.90,DIVI,,,,, 10/17/2026 11:15:09,166.00,DIVI,,,,,staking
- Dates are month/day/year, in UTC. Coins in fill the Received columns; coins out fill the Sent columns, as a positive number.
- Stake rows carry the tag
staking, which CoinTracker books as income. - The fee columns stay empty: an OUT row already shows the net change, fee included.
- Your browser saves it as
<address>-cointracker.csv. If CoinTracker does not list DIVI, add it as a custom currency before importing.
Tax is its own subject: Staking and taxes.
6OFX for accounting software
OFX is the statement format banks hand to programs such as GnuCash, Quicken and many bookkeeping tools. The server writes the address history as one:
https://services.divi.domains/api/rpc/ofx/<address>.ofx
Your browser saves <address>.ofx. Inside, the "bank" is DIVI, the account number is the address, and each transaction is a STMTTRN entry: CREDIT or DEBIT, the signed DIVI amount, the row type (STAKE, IN, OUT, SELF) as the name, and the other address as the memo. The transaction id is used as the entry id, so importing a later export again only adds what is new. The closing LEDGERBAL is the balance after the last row (12,159.8999 DIVI for the faucet address on 2026-10-21).
A public explorer only sees the chain. It cannot know that an OUT was a move to your own cold wallet, or that an IN was a loan. The one thing it labels with confidence is a stake reward, because the network itself pays it. Annotate the rest in your own spreadsheet or software; a public website should never ask you for those notes.
If something goes wrong
| You see | What it means |
|---|---|
| The CSV button is greyed out | The history is still loading, an export is already running, or the address has no transactions. |
| Invalid address | The link's address is mistyped, or it is on the other network: mainnet addresses start with D, testnet with x or y. |
| No transactions found for this address | The address exists but has never been used. |
| Address has N transactions; … | The history is longer than the server will build (20,000 transactions). Use the CSV button in the browser instead. |
| Backend unavailable | The server's node is restarting. Try again in a minute. |
| The newest transaction is missing | The server caches each address for ten minutes, and an unconfirmed transaction is never exported. Wait and reload. |
| Dates are off by some hours | They are UTC, not your local time. |
Still stuck? Ask the Divi chatbot, or see all tutorials.