Excel & spreadsheet guide
Export Solana Transactions to Excel
The Solana transaction export from ExportMyWallet.com is a standard CSV file that opens directly in Microsoft Excel, Google Sheets, LibreOffice Calc, or any other spreadsheet application. No special software required.
How to Export Solana Transactions to Excel
- 1
Copy your Solana wallet address
Open Phantom, Solflare, or any Solana wallet and copy your public wallet address.
- 2
Paste into ExportMyWallet.com
Go to ExportMyWallet.com, paste your address into the input field, and click Export Solana Transactions.
- 3
Download the CSV file
The file saves to your Downloads folder as a standard .csv file.
- 4
Open in Excel
Open Excel. Go to File > Open, select the CSV file. The data loads automatically with columns in separate cells — no formatting steps needed.
Opening in Google Sheets
- 1
Create a new sheet
Go to sheets.google.com and create a new blank spreadsheet.
- 2
Import your file
Go to File > Import > Upload and select your downloaded CSV file from your Downloads folder.
- 3
Set the separator
Choose "Comma" as the separator type. Your Solana transactions load into the sheet with columns: Date, Type, Direction, Token, Amount, Fee, Source, Tx Signature.
What the Columns Mean
Four key columns cover most analysis needs. For the full reference, see the Solana transaction CSV format guide.
Useful Excel / Google Sheets Analysis
Filter by type
Use Excel's filter feature on the Type column to separate SWAPs from TRANSFERs and see just the activity you want.
Calculate total fees
Use SUM on the Fee (SOL) column to see total network fees paid — potentially tax-deductible depending on your jurisdiction.
Sort by date
Sort by the Date column to see activity chronologically or find transactions in a specific date range.
Identify top tokens
Use a pivot table on the Token/Mint column to see which tokens you have transacted most frequently.
Limitations of Manual Spreadsheet Analysis
Excel and Google Sheets are great for browsing and filtering your data, but they do not automatically apply historical crypto prices. For tax reporting — calculating capital gains and cost basis — use a dedicated tool like Koinly or CoinLedger.
These tools import your CSV directly, look up the SOL price at the time of each transaction, and generate a formatted tax report. See the best Solana tax tools guide for a comparison.
Frequently Asked Questions
Can I open a Solana CSV export directly in Excel?
Yes. The exported file is a standard .csv file. Open Excel, go to File > Open, and select the file. Excel will import it with columns automatically separated.
Does Google Sheets work with the Solana CSV export?
Yes. Go to File > Import in Google Sheets and upload the CSV file. Select comma as the delimiter and your transaction data will load into the spreadsheet.
Can I use Excel to calculate my Solana taxes?
You can use Excel for basic analysis, but it won't automatically calculate capital gains. For tax reporting, import the CSV into a tool like Koinly or CoinLedger that applies historical prices and generates tax reports.
How many transactions can I export?
The free export includes your 100 most recent transactions. For larger wallets, the Standard tier ($4.99) exports up to 1,000 transactions and the Complete tier ($29.99) exports your full history.
Related Guides
Export Your Solana Transactions
Download your wallet history as a CSV — opens in Excel or Google Sheets instantly.
Export Solana TransactionsWorks with Phantom, Solflare, Backpack, and any Solana wallet.