Overview
Crucible's transaction export uses 12 columns. CoinTracker only accepts 8. This guide covers the column changes, date reformatting, and tag mapping you need before importing. It takes about 10 minutes in a spreadsheet.
This is not tax advice. Review your final report with a tax professional before filing.
Before you start
You'll need your Crucible transaction history CSV, a spreadsheet app (Excel, Google Sheets, or LibreOffice Calc), and a CoinTracker account.
Don't have your CSV yet? See "Exporting my wallet activity."
Step 1: Open your CSV and don't delete anything yet
Open the file in your spreadsheet app. You'll see 12 columns. Work through all the steps below before removing anything.
Step 2: Fix the date format
CoinTracker wants dates in MM/DD/YYYY HH:MM:SS format. Your Crucible export uses YYYY-MM-DD HH:MM:SS UTC.
Rearrange the date order and strip the " UTC" suffix from each row. In Google Sheets you can do this with a formula in a new column:
=TEXT(DATEVALUE(MID(A2,1,10)),"MM/DD/YYYY")&" "&MID(A2,12,8)
Once the new column looks right, copy it, paste as values only, then delete the original Date column.
Step 3: Prepare your columns
Make these changes:
Rename "Sent Amount" to Sent Quantity
Rename "Received Amount" to Received Quantity
In both the Sent Currency and Received Currency columns, find and replace
SN0withTAO
Fee Amount and Fee Currency stay as-is.
The SN0 swap matters because SN0 is your staked TAO on the root network. It's 1:1 with TAO, but CoinTracker won't recognize "SN0" and won't be able to price it.
Step 4: Map your labels to CoinTracker tags
Create a new column called Tag and fill it using the table below. Leave it empty for any rows with no label.
Crucible label | Sent Currency | CoinTracker tag |
reward | any | staking |
stake | TAO | stake |
stake | Subnet token (e.g. SN10, SN41) | unstake |
(empty) | any | (leave empty) |
Empty rows are fine. CoinTracker auto-categorizes standard deposits, withdrawals, and trades.
Step 5: Delete the unsupported columns
CoinTracker rejects files with extra columns. Before you delete, note the Net Worth Amount values for any subnet alpha token transactions. You'll need those figures to set custom prices in CoinTracker after importing.
Then delete: Net Worth Amount, Net Worth Currency, Label, Description, TxHash.
Step 6: Check your final column order
Your file should have exactly these 8 columns:
Date
Received Quantity
Received Currency
Sent Quantity
Sent Currency
Fee Amount
Fee Currency
Tag
Save as CSV and import using CoinTracker's custom CSV import option.
Heads up: subnet alpha token pricing
CoinTracker pulls historical price data for TAO automatically. For subnet alpha tokens like SN10, SN41, SN50, SN62, SN88, or SN95, there's no automatic pricing. After importing, find those transactions in CoinTracker and set custom prices manually. Use the Net Worth Amount from your original Crucible export as your reference.
Skipping this step means CoinTracker can't calculate gains or losses for those transactions.
Common questions
Is this file an official tax document? No. CoinTracker uses the imported data to generate tax reports, but always review those with a qualified tax professional before filing.