You will act as a google sheets/excel expert. Your first task is to understand the following information as you will need it to format the table in the google sheets/excel file :

How to Convert Your Transaction History into CoinTracker-Compatible CSV Format
This guide will walk you through the process of formatting your exchange's CSV to the CoinTracker format to import in cases where automatic syncing or custom file import are not available.

If you are troubleshooting errors after attempting to import your formatted CSV, check out this guide instead: Troubleshooting CSV Import Errors in CoinTracker

What is the purpose of the CoinTracker CSV format?
CoinTracker integrates with a wide array of blockchains, exchanges, and wallets directly. However, in scenarios where automatic syncing is unavailable or a bug disrupts the process, manually importing transactions via CSV files becomes necessary.

CoinTracker simplifies this by supporting direct uploads of transaction history CSV files from exchanges or wallets whenever possible, eliminating the need for modifications. In cases where importing the unedited CSV file isn't possible, converting your exchange's transaction history CSV file into CoinTracker's format is required for successful import.

How to Format Your Transaction History CSV to the CoinTracker Format
Step 1: Export Your Transaction History
First, we'll need your transaction data from the exchange or wallet: 

Navigate to the exchange or wallet you wish to add to CoinTracker.
Seek the option for exporting transaction history, usually available as a CSV file. If you do not see this option, please contact the exchange or wallet to ask if it is available.
Step 2: Prepare Your CSV for CoinTracker
Download our CSV template —this contains the correct headers you will need to reformat your CSV. You can add your transactions into the template or use it as a guide.
Headers: The headers must match the template exactly:
Column A	Column B	Column C	Column D	Column E	Column F	Column G	Column H
Date	Received Quantity	Received Currency	Sent Quantity	Sent Currency	Fee Amount	Fee Currency	Tag
Columns: Can be in any order but all must be present—do not delete or add columns.
Step 3: Put the Right Information in Each Column
Now, you’ll need to add all the data you have from your existing CSV to the template you’ve downloaded:

Date and Time
Columns:

Date (Column A): The exact date and time of the transaction.
Date and Time Format:  MM/DD/YYYY HH:MM:SS. For example, "06/14/2017 20:57:35".

Time entries are optional. If you choose to include a time, it is assumed to be in UTC. If your time data is in another timezone, ensure you convert it to UTC before entry to guarantee accuracy. 
Sent and Received Assets
Columns:

Received Quantity (Column B): The amount of crypto or fiat you have received. 
Received Currency (Column C): This is the type of crypto you have received.
Sent Quantity (Column D): This is the amount of crypto or fiat currency you sent.
Sent Currency (Column E): This is the type of crypto you have sent.
Fee Amount (Column F) This is the amount of the transaction fee in the currency it was paid in.
Fee Currency (Column G): This is the type of currency that your transaction fee was paid in.
Quantity Format: Numbers only, including decimals if applicable. For example, "1.05". Do not include text other than numbers.

Currency Format: The token symbol of the received crypto. For example, "BTC" or "USD".

Other Considerations:

Blank Cells: If no data exists, leave the cell blank. Here are some examples of transaction types that will have blank cells:
Staking rewards will only have received data—'Sent Quantity' and 'Sent Currency' will be blank.
Transfers to another wallet will have only sent data—'Received Quantity' and 'Received Currency' will be blank.
See more in the Examples section at the end of this article
Currency Symbols: Only currencies supported by CoinTracker will be accepted. You may see an error if an unsupported currency is used in the file. You can check if your currency is supported and, if not, use this guide to create a custom currency, which can then be used in your CSV: How to Create a Custom Currency
Pairs: If your trade is expressed as a trading pair, be sure to split the token symbols according to the transaction type.
Transaction Category Tags 
Column

Tag (Column H): To categorize transactions by type for better tracking and tax purposes. This column is optional.
Tag Format: Only certain CoinTracker CSV tags will be accepted by the importer—any other text will cause the import to fail or ignore the row containing an unsupported tag. Make sure the text exactly matches one of the available 'CoinTracker CSV Tags' listed in this help article: Transaction Category Definitions.

Other Considerations:

When to Use Tags: Tags help categorize transactions correctly for tax purposes and portfolio tracking. Without tags, transactions imported via CSV default to Sent, Received, Trade, or Transfer (when the wallet transferred to or from is also added to CoinTracker). Tagging allows you to specify transaction types for Sent and Received transactions. You can add tags in Column H before import or update categories manually after import using this guide: How to Change a Transaction Category.
Not for All Transactions: You cannot tag trades or transfers and you should not use tags unless it is necessary to categorize a transaction.
Use Supported Tags Only: Only certain tags are accepted. Incorrect tags will cause import issues, including import failure and incorrectly tagged rows to be missing after import.
Transaction Memo: This column cannot be used for memos or notes. You can leave a note on a transaction after import by editing the transaction.
Step 4: Upload Your CSV to CoinTracker
Save the file as .csv file type.
Import your CSV file to the CoinTracker CSV import page.
Demos of CSV Reformatting
For a written walkthrough of how a CSV is converted to the Cointracker-compatible format, check out this article: How to Import FTX US Transactions via CSV

For a video example:



Format Examples for Different Transactions Types
Trade
Definition

Exchanging crypto for another crypto. 
Example: Selling .001 WAVES for 20.0941 USD
Format Rules for Trades

Trades will have both a sent quantity and a received quantity.
If no fee, leave Fee Amount and Fee Currency blank.
Tag must be blank.
Original Format

Screenshot 2024-03-05 at 4.32.41 PM.png

CoinTracker Format

Screenshot 2024-03-05 at 4.32.55 PM.png

Date: "09/04/2023 17:00:00"
Received Quantity: "3000"
Received Currency: "USD"
Sent Quantity: "1"
Sent Currency: "ETH"
Fee Amount: "0.01"
Fee Currency: "ETH"
Tag:
Buy
Definition: Buying crypto with fiat

Date: "09/03/2023 15:45:25"
Received Quantity: "1"
Received Currency: "BTC"
Sent Quantity: "45000"
Sent Currency: "USD"
Fee Amount: "0.0004"
Fee Currency: "BTC"
Tag:
Staking Rewards
Definition: When you stake, you're usually receiving rewards at intervals.

Date: "09/01/2023 00:00:00"
Received Quantity: "0.01" (the staking reward)
Received Currency: "ETH"
Sent Quantity: (leave blank)
Sent Currency: (leave blank)
Fee Amount: (leave blank) (usually no fee for receiving staking rewards, but it can vary)
Fee Currency: (leave blank)
Tag: staking
Transfers 
Definition: This is when you're transferring crypto between wallets or exchanges that you own.

Outgoing Transfer: Transferring to another wallet 
Date: "09/02/2023 12:30:00"
Received Quantity: (leave blank: you're not receiving, you're sending)
Received Currency: (leave blank)
Sent Quantity: "5"
Sent Currency: "BTC"
Fee Amount: "0.0001"
Fee Currency: "BTC"
Tag: must be blank
Incoming Transfer: Receiving a transfer from another wallet
Date: "09/02/2023 12:30:00"
Received Quantity: "5"
Received Currency: BTC"
Sent Quantity: (leave blank: you're not receiving, you're sending)
Sent Currency: (leave blank)
Fee Amount: (leave blank)
Fee Currency: (leave blank)
Tag: must be blank