Moonscape CSV Format Guide

There are two ways to import your crypto trading data into Moonscape: using your exchange's native CSV format or our standardized Moonscape format.

Import Options

Option 1: Direct Exchange Import

For supported exchanges (Binance, Coinbase, Kraken, etc.), you can simply:

1. Download the CSV export from your exchange
2. Upload it directly to Moonscape
3. We'll automatically convert it to our unified format

Option 2: Moonscape CSV Format

Use our standardized format if:

• Your exchange isn't supported yet
• You manage trades manually
• You want to combine data from multiple sources
• You're migrating from another platform

What is the Moonscape CSV Format?

The Moonscape CSV format is a standardized structure that consolidates crypto trading data from any source into a single, consistent format. This makes it easier to analyze your trading history, calculate taxes, and integrate with other tools.

Column Structure

The Moonscape CSV format consists of 9 columns:

Column	Description	Example
exchange	The exchange where the transaction occurred	Binance, Coinbase, Kraken
datetime	Transaction timestamp in YYYY-MM-DD HH:MM:SS format	2024-10-17 12:30:45
type	Transaction type	buy, sell, deposit, withdrawal
buyasset	Asset being purchased/received	BTC, ETH, USD
buyqty	Quantity of the buy asset	0.1, 1000
sellasset	Asset being sold/sent	USDT, SOL, BTC
sellqty	Quantity of the sell asset	6000, 130
feeasset	Asset used to pay fees	BTC, ETH, USD
feeqty	Fee amount	0.0001, 2.5

Sample Data

Here's what the format looks like in practice:

exchange,datetime,type,buyasset,buyqty,sellasset,sellqty,feeasset,feeqty
Coinbase,2024-10-17 12:30:45,buy,BTC,0.1,USDT,6000,BTC,0.0001
Binance,2024-01-17 12:30:45,sell,USD,130,SOL,1,SOL,0.0001
Kraken,2024-02-17 12:30:45,sell,USD,2500,ETH,1,ETH,0.0001

Download Sample File

Want to see the format in action? Download our sample CSV file to understand the structure:

Download Sample Moonscape CSV

Transaction Types Explained

Buy Transactions

• buyasset: The cryptocurrency you purchased
• buyqty: Amount of crypto purchased
• sellasset: The currency you paid with (usually USD, USDT, etc.)
• sellqty: Amount you paid

Sell Transactions

• buyasset: The currency you received (usually USD, USDT, etc.)
• buyqty: Amount received
• sellasset: The cryptocurrency you sold
• sellqty: Amount of crypto sold

Deposits & Withdrawals

For deposits and withdrawals, one of the asset fields will typically be empty or marked as the native currency of the exchange.

Benefits of the Moonscape Format

1. Consistency: Same structure across all exchanges
2. Completeness: Captures all essential transaction data
3. Compatibility: Works with most tax software and analysis tools
4. Simplicity: Easy to understand and work with

Using Your Data

Once you have your data in Moonscape format, you can:

• Import into tax software for crypto tax calculations
• Analyze trading performance with spreadsheet tools
• Track portfolio performance over time
• Generate custom reports and visualizations

Getting Started

Ready to import your trading data into Moonscape?

For Supported Exchanges:

1. Sign up at moonscape.app
2. Connect your exchanges using read-only API keys, or
3. Download CSV from your exchange and upload to Moonscape
4. Export your unified CSV with one click

For Manual Trading or Unsupported Exchanges:

1. Download our sample Moonscape CSV
2. Replace the sample data with your actual transactions
3. Upload your completed CSV to Moonscape
4. Export your unified data for analysis

The Moonscape CSV format makes managing your crypto trading data simple and standardized. No more wrestling with different formats from different exchanges!

Questions?

Have questions about the format or need help with your data? Email us at hello@moonscape.app

Follow us on Twitter: @MoonscapeHQ