Skip to main content

Transfer an unsupported exchange CSV file into the Blockpit Excel template: guide

Every exchange exports its data differently. The Blockpit Excel template, however, always needs the same thing: one row per transaction with the date in UTC, a label and the outgoing and/or incoming side. This guide shows the steps almost every exchange file needs before it fits into the template.

​

ℹ️ Good to know: Simply copying the content of the exchange file into the template does not work. You transfer the values column by column and translate the exchange terms into Blockpit labels.

​

💡 Do you need the template at all? First check the guide for your exchange to see whether Blockpit reads its CSV file directly. Then you upload the original file and you are done. You need the template if there is no CSV import for your exchange or data is missing from the exchange file.

​

​

At a glance

Step

What you do

1

Open the exchange file correctly so that each value is in its own column

2

Delete extra rows above the header row

3

Convert the time to UTC

4

Check amounts: minus = outgoing, keep tiny amounts

5

Translate the exchange type into a Blockpit label

6

Transfer into the template and upload

​

​

Step 1: Open the file instead of copying it

If everything is in column A after opening, the file is not split. This is how you split it:

​

▸ Excel: open an empty workbook › Data › From Text/CSV › choose the file › delimiter Comma (or Semicolon) › Load.

▸ Google Sheets: File › Import › upload the file › detect the separator automatically.

▸ Already pasted? Select column A › Data › Text to Columns › Delimited › Comma.

​

​

Step 2: Delete extra rows

Many exchanges write details such as the account ID or time zone above the actual header row. Delete everything above the row with the column names (for example Time, Type, Amount, Symbol). Note the time zone first, you need it in step 3.

​

​

Step 3: Convert the time to UTC

The template expects all times in UTC. If the file uses a different time zone, convert it:

​

Time zone in the file

Formula (time in column A)

UTC+8

=A2-8/24

UTC+1 (Central European winter time)

=A2-1/24

UTC-5

=A2+5/24

​

If the file shows no time zone, you usually find it in the guide for your exchange or in the export settings of the exchange.

​

​

Step 4: Check the amounts

▸ Minus = outgoing: a negative amount is an outflow. Enter it without the minus in Outgoing Amount, the asset in Outgoing Asset. Positive amounts go into Incoming Amount and Incoming Asset.

▸ Keep tiny amounts: values like 6.7E-10 are valid, very small amounts (for example interest in fractions of a satoshi). Do not delete them. Set the column to number with many decimals or to text.

▸ Decimal separator: if numbers are imported incorrectly (comma instead of point), set the columns to text or the locale of your spreadsheet app to English.

▸ Read it correctly right away: in Excel, choose the matching locale of the file when opening it via From Text/CSV (usually English (United States), point as decimal separator) or afterwards Change Type › Using Locale. In Google Sheets, set it under File › Settings › Locale and import again.

​

⚠️ Caution: never switch on Set precision as displayed in Excel. It permanently cuts all numbers to the displayed decimals, tiny amounts get lost.

​

​

Step 5: Translate the exchange type into a Blockpit label

Which form does your file have?

Exchange files usually come in one of three forms. This tells you how to convert them:

​

Form

You recognise it by

How to transfer it

One movement per row

columns like Time, Type, Amount, Asset; amounts with plus or minus (typical for account or funding history)

Each row becomes incoming (plus) or outgoing (minus). If two rows belong to one swap, combine them into one trade row.

Trading pair with side

columns like Pair (for example BTC/USDT), Side (Buy/Sell), Amount, Price, Total

For Buy, the first asset is incoming and the second outgoing (amount = Total); for Sell the other way round.

Sent and received in one row

columns like Sent Amount, Sent Currency, Received Amount, Received Currency

Almost direct: sent into the outgoing columns, received into the incoming columns.

​

Translate the types

Every exchange names its transactions differently. The table shows common terms and the matching label of the template. The terms are examples, your exchange may name them differently.

​

Type in the exchange file (examples)

What happens

Label in the template

Side

Deposit, Received

inflow from outside

Deposit

incoming

Withdrawal, Sent

outflow to outside

Withdrawal

outgoing

Trade, Buy, Sell, Convert, Swap

exchange for another asset

Trade

both in one row

Deposit yield, Interest, Earn reward

interest

Interest

incoming

Staking reward

staking income

Staking

incoming

Airdrop, Bonus

free inflow

Airdrop

incoming

Cashback, Card reward

refund

Cashback

incoming

Fee, Trading fee

fee

Fee or the Fee Amount column of the trade row

outgoing

Funding fee

derivative fee

Derivative Fee

outgoing

Realized PnL (positive / negative)

derivative result

Derivative Profit / Derivative Loss

incoming / outgoing

Loan, Borrow / Repay

loan

Receive Loan / Repay Loan

incoming / outgoing

Earn subscription / redemption, Stake / Redeem staking, Transfer to funding

move within the same exchange

rewards listed separately in the file: do not transfer. Otherwise: Stake Transfer or DeFi Transfer

see box

​

⚠️ Caution, moves within the same exchange (for example into the earn or staking product and back) are not outflows. If you enter them as Withdrawal, the asset is missing from your holdings afterwards. How you handle them depends on whether the file lists the rewards separately:
▸ Rewards are listed separately (for example Deposit yield): do not transfer the moves, only the rewards as Interest or Staking.
▸ Rewards are not listed as separate rows: transfer the moves as Stake Transfer (staking) or DeFi Transfer (earn, DeFi). The mismatch that then remains in the sub-integration is the rewards. You book these afterwards, as the Kraken guide describes for Earn (Vault).

​

Formulas that save you work

For large files, calculate the template columns with formulas instead of transferring every row by hand (Excel, English function names; example: amount in column C, type in column B, time in column A):

​

Task

Formula or method

Outgoing from a negative amount

=IF(C2<0,ABS(C2),"")

Incoming from a positive amount

=IF(C2>0,C2,"")

Time from UTC+8 to UTC

=A2-8/24

Translate exchange type into label

Create a small table on a second sheet „Mapping“ (column A exchange type, column B label), then =VLOOKUP(B2,Mapping!A:B,2,FALSE)

Split a trading pair (BTC/USDT)

Data › Text to Columns › delimiter /

Amount and asset in one cell („0.5 BTC“)

=LEFT(A2,FIND(" ",A2)-1) and =MID(A2,FIND(" ",A2)+1,20)

​

When everything is calculated, copy the results and paste them into the template via Paste Special › Values.

​

▸ Trades in one row: if your exchange exports a swap as two rows (outflow and inflow with the same time), combine them into one row with Trade: outgoing on the left, incoming on the right.

​

​

​

Example: from the exchange file to the template

Made-up exchange file, one movement per row, time zone UTC+8:

​

Time

Type

Amount

Symbol

2026-03-02 10:15:00

Deposit

500

USDT

2026-03-02 10:20:00

Trade

-500

USDT

2026-03-02 10:20:00

Trade

0.0071

BTC

2026-03-05 08:00:00

Deposit yield

3.5E-07

BTC

2026-03-06 09:00:00

Simple Earn subscription

-0.0071

BTC

​

In the template this becomes:

​

Date (UTC)

Integration Name

Label

Outgoing Asset

Outgoing Amount

Incoming Asset

Incoming Amount

02.03.2026 02:15:00

My exchange

Deposit

USDT

500

02.03.2026 02:20:00

My exchange

Trade

USDT

500

BTC

0.0071

05.03.2026 00:00:00

My exchange

Interest

BTC

0.00000035

​

▸ The time is moved back by 8 hours.

▸ The two trade rows with the same time are one Trade row.

▸ The interest stays as a tiny amount.

▸ The earn move is left out on purpose: the rewards are listed separately in the file.

​

​

Checklist before uploading

✅ All times in UTC

✅ No minus signs in the amount columns

✅ Tiny amounts present, nothing rounded

✅ Trades in one row with outgoing and incoming

✅ Moves within the exchange handled correctly

✅ No period twice that the API has already imported

✅ Three samples compared with the exchange

​

💡 Large files: export smaller periods from your exchange, for example per quarter, and upload a test with a few rows first. If the result fits, the rest follows.

​

​

Step 6: Transfer into the template and upload

1️⃣ Copy the prepared columns into the matching columns of the template: Date (UTC), Integration Name, Label, Outgoing Asset, Outgoing Amount, Incoming Asset, Incoming Amount, if needed Fee Asset and Fee Amount.

​

2️⃣ Check three samples against the exchange: a trade, a deposit and an income.

​

3️⃣ Upload the file via the cloud icon (☁️) into your existing integration. Make sure the period does not overlap with data the API has already imported.

​

​

⚠️ Typical mistakes
✗ Content copied instead of opening the file → everything is in column A, the template cannot map anything
✗ Time zone forgotten → transactions are hours off, trades and transfers do not match
✗ Minus in the amount → the upload fails or incoming and outgoing are swapped
✗ Earn or staking moves as withdrawals → the asset is missing from your holdings afterwards, and rewards without their own row get lost
✗ Trade as two rows → two transactions with Unlabeled instead of one trade

​

​

No time to prepare your data?

🧑‍💼 Expert Service: no time or desire to prepare and import data yourself?

​

Manually transferring transaction histories into the Excel template, cleaning faulty CSV files or reconstructing closed exchanges takes time and accuracy. With the Blockpit Expert Service (DE / AT / CH), we take over this work completely: we check your raw data, transfer your history without errors into our templates and carry out the full import directly in your account.

​

You can find detailed information on booking, process and joining the in-app call in the guide: Blockpit Expert Support – Everything about Expert Check & Expert Service.

​

💡 Optional - The free 15-minute initial call: discuss scope, process & a targeted cost estimate for your account in advance

Do you want the Expert Service to prepare your account, but you are unsure before booking about the exact time required or about missing data?

​

Simply put our free 15-minute initial call before the Expert Service. In the appointment we review your starting point and create a tailored, reliable Expert Service offer with a time and cost frame for the preparation, without you having to buy an hours package in the shop beforehand.

​

Your advantage: You do not have to select a service package in the shop beforehand. If our offer suits you, our expert books the suitable package directly with you during the appointment and starts the preparation right away.

​

​

Blockpit does not provide tax advice. For specific legal questions, please contact a tax advisor.

Did this answer your question?