Format reference
Solana Transaction CSV Format
The Solana transaction CSV generated by ExportMyWallet.com contains 8 columns. Here is exactly what each column means, what the data looks like, and how tax tools use it.
CSV Column Reference
Date (UTC)TimestampThe date and time the transaction was confirmed on-chain, in UTC. Used to determine which tax year a transaction falls in and to calculate holding periods.
Example: 2024-03-15 14:22:05
TypeStringThe transaction category as classified by Helius. Common types include SWAP, TRANSFER, NFT_MINT, NFT_SALE, STAKE, and UNKNOWN for unclassified program interactions.
Example: SWAP, TRANSFER, NFT_SALE
DirectionEnumWhether the asset moved out of your wallet (SENT), into your wallet (RECEIVED), or between accounts not directly tied to your address (TRANSFER).
Example: SENT, RECEIVED, TRANSFER
Token / MintStringThe token symbol for well-known tokens (SOL, USDC), or the mint address for less-common SPL tokens. Use this to identify the asset in each transaction.
Example: SOL, EPjFWdd5...
AmountDecimalThe quantity of the token transferred, in the token's native decimal format. For SOL, this is in SOL (not lamports). For SPL tokens, the raw token amount.
Example: 12.500000000
Fee (SOL)DecimalThe Solana network fee paid for this transaction, in SOL. Typically 0.000005 SOL per signature. In many jurisdictions, fees are deductible as a cost of disposal.
Example: 0.000005000
SourceStringThe program or marketplace that processed the transaction. Helps identify whether a swap happened on Jupiter, a sale happened on Magic Eden, etc.
Example: JUPITER, RAYDIUM, MAGIC_EDEN
Tx SignatureString (base58)The unique on-chain transaction ID. Use this to verify any transaction on Solana Explorer or Solscan. Tax tools use this to deduplicate transactions.
Example: 5UfgJ2...
Sample CSV Output
This is what a typical Solana transaction CSV export looks like when opened in a text editor:
Date (UTC),Type,Direction,Token/Mint,Amount,Fee (SOL),Source,Signature 2024-03-15 14:22:05,SWAP,SENT,SOL,1.500000000,0.000005000,JUPITER,5UfgJ2... 2024-03-15 14:22:05,SWAP,RECEIVED,EPjFWdd5...,245.320000,0.000005000,JUPITER,5UfgJ2... 2024-03-14 09:11:32,TRANSFER,RECEIVED,SOL,10.000000000,0.000005000,SYSTEM_PROGRAM,3KpqR7... 2024-03-13 18:45:10,NFT_SALE,SENT,DezX7...,1.000000,0.000005000,MAGIC_EDEN,9WsxQ1...
Note: A single swap generates two rows - one for the token sent, one for the token received. This is the format expected by Koinly and TaxBit.
Tax Tool Compatibility
Koinly
CompatibleImport via Custom CSV. Map columns to Koinly's date, sent/received, fee fields.
Visit Koinly →TaxBit
CompatibleImport via Generic CSV option. Date and amount columns match TaxBit's expected format.
Visit TaxBit →Google Sheets / Excel
CompatibleOpen directly. The CSV header row provides clean column labels for manual analysis.
Frequently Asked Questions
Why does a single swap show as two rows in the CSV?
A swap involves two transfers: the token you sent and the token you received. Each transfer is its own row. This two-row format is what Koinly and TaxBit expect for swap transactions.
What does 'UNKNOWN' in the Type column mean?
UNKNOWN means the transaction involved a program interaction that couldn't be automatically classified. These are usually DeFi protocol interactions. You may need to manually review and categorise them in your tax tool.
Why are some Token/Mint values a long string instead of a symbol?
Lesser-known SPL tokens don't have a registered symbol, so the mint address is shown instead. You can look up the mint address on Solscan or SolanaFM to identify the token.
What is the Tx Signature column used for?
The transaction signature is the on-chain ID. It lets you verify any row by looking it up on Solana Explorer. Tax tools also use it to detect and remove duplicate entries.
Download Your Solana Transaction CSV
Get the CSV file described above - free, in seconds, no login required.
Export Solana Transactions →Works with Phantom, Solflare, Backpack, and any Solana wallet.