How to export your Solana DEX/wallet history to CSV for a tax spreadsheet

Not tax advice. All numbers, addresses and signatures below are EXAMPLE data. Sources checked 21 October 2026; details may change.

If you trade on Solana through a self-custody wallet, nobody sends you a year-end statement. This guide covers where to get the raw history, how to export it to CSV and how to turn it into clean rows for a spreadsheet. It does not tell you how your country taxes any of it; ask a tax professional about that.

Step 0: Your wallet won't do this for you

Phantom's help center is explicit: "Phantom does not issue tax forms, such as 1099s, hold your funds, or provide tax advice." It points you to blockchain explorers or tax tools, which "only need your public wallet address" (>Phantom: Export your transaction history for taxes). Never paste a seed phrase or private key anywhere.

Step 1: List every public address

Write down every Solana address you traded from (main wallet, burners, extra accounts), each with a label such as main or burner-1. In Phantom, the address is under Receive (>Phantom: View your wallet history on a blockchain explorer).

Step 2: Export from Solscan

Open solscan.io and enter the address. Solscan's guide adds what matters (>Solscan: How to Export CSV Transaction History):

Export works on the Transfers, DeFi Activities and Balance Changes tabs. DeFi Activities covers swaps, staking and liquidity operations, so it is the tab for DEX swaps.
Filters apply to the file. The limit to watch: "The export system is designed to return the latest 1,000 records only (even within the selected filtered range)."

So export in date slices (for example month by month) and check that no file hits 1,000 rows. Name files clearly, e.g. main_defi_2025-01.csv. Export both DeFi Activities and Transfers for every address.

Bar chart of EXAMPLE monthly Solscan export slices; the February slice hits exactly 1,000 records and is flagged for re-export in smaller slices — Example data.

Step 3: Merge and clean the raw export

Paste all slices for one wallet into one sheet and sort by time. Then:

Remove duplicate export records where slices overlapped (same signature, same amounts). Do this before Step 4: there, one swap signature deliberately becomes two trade rows.
Re-export any month with exactly 1,000 rows in smaller slices.
Own-wallet transfers and spam tokens are not buys or sells. Don't make trade rows for them; note them in the Notes column only; a row with just a date, token and note is ignored by the calculations.

Step 4: Turn swaps into buy and sell rows

Log each swap as two rows with the same date and signature: a Sell of what you gave and a Buy of what you received, both at the same value in your reporting currency.

EXAMPLE: on 2025-03-04 you swapped 2 SOL for 1,000,000 EXAMPLETOKEN, with SOL at 150 (EXAMPLE price). Both sides are worth 2 × 150 = 300, so the token price is 300 ÷ 1,000,000 = 0.0003.

Date	Type	Token	Qty	Price (per token)	Fee	Tx hash
2025-03-04	Sell	SOL	2	150	0	EXAMPLE-sig-0002
2025-03-04	Buy	EXAMPLETOKEN	1,000,000	0.0003	0	EXAMPLE-sig-0002

EXAMPLE: one swap in the explorer export becomes two Trade Log rows, a Sell of 2 SOL and a Buy of 1,000,000 EXAMPLETOKEN, with the same date and signature and a value of 300 each — Example data.

Prices: the CSV gives tokens and amounts. Add a price in your reporting currency at the time of each trade and note its source.
Fees: enter the combined fee once per swap, on the token's row, in your reporting currency, and do it the same way all year. Network fees are paid in SOL, so convert them (EXAMPLE: 0.000005 SOL at 150 = 0.00075) and add them to any platform fee. How fees count depends on your jurisdiction; ask your tax advisor.
Earlier holdings: if your first logged trade sells SOL, the spreadsheet has nothing to match it against. Log your earlier SOL buys (or starting holdings at original cost and date) before the first Sell.

Step 5: Keep wallets separate if your rules require it

If you need separate records per wallet or account, keep one sheet per wallet; whether you need that is a question for your tax advisor. Keep the original CSVs unedited next to your cleaned sheet.

Checklist

☐ Public addresses listed (never private keys)
☐ DeFi Activities and Transfers exported per address, no slice at 1,000 rows
☐ Duplicate export records removed before splitting swaps
☐ Transfers and spam in notes only
☐ Swaps split into Sell + Buy with dated prices; combined fee in fiat, once per swap
☐ Earlier buys logged before the first Sell; raw CSVs archived

Related guides

Disclosure: I make a paid template for the spreadsheet part: Nah Crypto Tax Tracker (29 USDC). Log buys and sells (swaps as a sell plus a buy) and get FIFO cost basis, realized gain/loss per year (Summary covers 2024–2030) and current holdings by token. Airdrops are not calculated automatically: you can log them manually as a Buy row at a value you choose (e.g. 0 or fair value; ask an advisor which), as explained in the guide. The workbook accepts only Buy and Sell rows; transfers and staking can only be noted in the Notes column and are not calculated. Selling more than you've logged is flagged OVERSOLD; on the same date, put a token's Buy row above its Sell row. FIFO runs across everything in one file, so keep one copy per wallet if you need per-wallet records. You can do everything above without it. Nah Crypto Tax Tracker

Not tax advice. Rules differ by country and change over time; check with a qualified tax professional. Crypto assets are volatile and you can lose some or all of your money; do your own research. Nah is not affiliated with, endorsed by or sponsored by Phantom, Solscan or Solana; names only describe where data comes from.