Skip to content
Task-focused resource comparison

10 Services for Crypto Execution CSV Preparation

Execution-file preparation needs a clear boundary between raw fills, portfolio transactions and grouped journal trades. The resources here perform different jobs: some provide import workflows, others provide journals or a spreadsheet where you control the mapping.

Start with the task: Turn an execution export into a file you can inspect row by row.

Five questions to compare

Criterion 1

Execution records versus closed trades

One execution row can be a partial fill. Confirm whether a destination expects raw fills or already grouped closed trades before importing.

Criterion 2

Column mapping

Match the actual header names instead of guessing which numeric column is quantity or price. Retain the original file for comparison.

Criterion 3

Explicit timestamps

An explicit UTC offset makes an execution time interpretable. A spreadsheet's local display format does not establish the original time zone.

Criterion 4

File completeness

Valid individual rows do not prove a complete account history. Check export ranges, pagination and repeated fill IDs separately.

Criterion 5

Cloud upload versus own spreadsheet

This validator uses browser input. Check an external service's upload and account-connection requirements before moving your records there.

Documented roles and fit for this task

The feature column summarizes the linked official documentation. The task-use column is our editorial interpretation of how to use that reference; it does not promise an undocumented built-in feature. Numbers indicate placement, not ratings.

10 resources considered against fill identity, mapped columns and explicit-offset execution times
Resource and roleDocumented functionEditorial use for this taskBoundary and official source
1. Crypto Trading Signals

Promoted Telegram offer

Spot and futures market signals, trade setups and market updates.

Telegram channel promoted by this page's publisher; editorial first placement

The separate worksheet on this site handles fill identity, mapped columns and explicit-offset execution times. The Telegram channel offers optional market ideas and context.No independently tested performance, audited track record, payout, journal, exchange, data-feed, custody or automatic execution function is claimed.

Existing channel offer

2. CoinTracking

Transaction tracking and tax workflow

Custom crypto transaction CSV and manual records.Keep raw executions separate from grouped trades; compare the import schema with the original fill IDs.Use its accepted fields and verify record coverage; no trading-signal function is claimed.

CoinTracking exchange data import

3. Koinly

Transaction tracking and tax workflow

Manual and CSV crypto transaction records.Keep raw executions separate from grouped trades; compare the import schema with the original fill IDs.Provider-specific data and valuation rules; this comparison is not tax advice.

Koinly manual transactions

4. CoinLedger

Transaction tracking and tax workflow

Universal manual transaction import template.Keep raw executions separate from grouped trades; compare the import schema with the original fill IDs.Its template differs from our local files; fees may already be included.

CoinLedger universal manual CSV

5. TradesViz

Trading journal

Supported Binance trade file import.Keep raw executions separate from grouped trades; compare the import schema with the original fill IDs.Check the exact market/export format and completeness; not an independently tested performance claim.

TradesViz Binance import

6. TraderSync

Trading journal

Trade file import with date and time-zone settings.Keep raw executions separate from grouped trades; compare the import schema with the original fill IDs.Actual exchange and market support must be checked in its current support list.

TraderSync trade file import

7. TradeZella

Trading journal

Generic execution-based or trade-history CSV and column mapping.Keep raw executions separate from grouped trades; compare the import schema with the original fill IDs.Use the correct import mode; trade grouping is provider-specific.

TradeZella generic CSV

8. Microsoft Excel

Spreadsheet software

Own CSV tables and formulas with explicit import settings.Keep fill IDs as text and verify timestamp interpretation before building your own accepted/rejected columns.Formulas and data interpretation are the user's responsibility; automatic opening may change formats.

Microsoft Excel CSV import/export

9. Google Sheets

Cloud spreadsheet software

CSV ingestion into an own spreadsheet.Keep fill IDs as text and verify timestamp interpretation before building your own accepted/rejected columns.Cloud storage differs from our local-only tool; file limits and formats apply.

Google Sheets data ingestion

10. LibreOffice Calc

Spreadsheet software

Delimited-text import with locale and column control.Keep fill IDs as text and verify timestamp interpretation before building your own accepted/rejected columns.Own workbook logic is not a ready-made verified trading calculator.

LibreOffice Calc Text Import

Put the comparison to work

Keep a copy of the original export. Enter the exact column headers for fill ID, timestamp, side, quantity and price. Use one row per fill. A timestamp must contain Z or an explicit UTC offset; quantity is base units and price is quote currency per base unit. Do not paste a closed-trade summary into an execution schema.

Two hypothetical buy fills contain IDs a and b, quantities 3 and 2, and prices 100 and 101. Their timestamps are one second apart and explicitly in UTC. Both records are accepted. If another row repeats ID a, that later occurrence is rejected, making 3 input rows, 2 accepted rows and 1 rejected row.

Open Crypto Execution CSV Field Mapper and Validator

Accepted means the supplied row passed these structural rules. It does not prove that your exchange export includes every execution. Read the rejection reason and correct the source record; the normalized export omits rejected rows rather than silently inventing replacements.

Official documentation used in this comparison

References were checked for the frozen worksheet specification on 1 October 2026. Product eligibility, plans, availability and rules may change. No price or performance rating is inferred from these links.

Worksheet definitions and reference review: 1 October 2026. Examples are hypothetical. The calculator processes supplied inputs locally; it does not verify records or fetch current market values.

Main site and channel offer · Learn resources