Koinly → Excel / Google Sheets

Koinly CSV to Excel / Google Sheets

Excel / Google Sheets won't take your Koinly CSV directly — TurboTax removed crypto CSV import in January 2026 and the legacy importer capped at ~4,000 rows. Upload your export here and download a CSV that imports without the cap.

No 4,000-row cap Free preview · $6.99 to download

Why Koinly users get stuck at Excel / Google Sheets

The Koinly details that trip up a clean Excel / Google Sheets filing — and how the converter handles each.

Note 01

Koinly's Form 8949 CSV and its Complete Tax Report shape the same disposals differently — either uploads here, but the raw transactions ledger is not a Form 8949 export.

Note 02

When wallets aren't fully synced, Koinly marks the affected lots as Unknown cost basis, and those import at zero basis unless you reconcile them first.

Note 03

Free Koinly plans preview your gains but gate the CSV download behind a paid tier — the export you get still converts here the same way.

How it works

Four steps. Preview and reconciliation are free — you only pay to download.

Upload

CSV or 1099-DA PDF

Extract

Every lot, term-aware

Reconcile

Fill Unknown basis

Download

TXF, CSV, XLSX, PDFs

Upload this, download that

You upload

Koinly Form 8949 CSV
Exported from Tax Reports → Form 8949 report (or the Complete Tax Report)

You download

Form 8949 CSV, ready for Excel / Google Sheets
Form 8949 CSV and XLSX
Wash sale report PDF (if your data has wash sales)
Import guide PDF with step-by-step screenshots

Preview is free. One-time $6.99 for the bundle.

How to open your Form 8949 CSV

1
Open Excel or Google Sheets and create a new blank spreadsheet.
2
Use Data → From Text/CSV (Excel) or File → Import (Google Sheets) and select the downloaded CSV.
3
Confirm comma as the delimiter so each field lands in its own column.
4
Every row is one Form 8949 disposal — description, dates, proceeds, cost basis, gain/loss, and wash sale.
5
Use it as your filing worksheet or hand it to your CPA.

Koinly to Excel / Google Sheets FAQ

Which Koinly export should I upload?

Upload the Koinly Form 8949 CSV from Tax Reports → Form 8949 report (or the Complete Tax Report). Koinly's Form 8949 CSV and its Complete Tax Report shape the same disposals differently — either uploads here, but the raw transactions ledger is not a Form 8949 export.

What exactly do I download?

A Form 8949 CSV — one row per disposal with description, acquisition and sale dates, proceeds, cost basis, gain/loss, and any wash sale adjustment. Open it in Excel or Google Sheets, or hand it to your CPA.

Does the 4,000-row limit apply here?

No. The ~4,000-row ceiling was specific to TurboTax's old crypto CSV importer. A plain CSV worksheet has no row cap, so even a heavy Koinly trading year comes through in full.

Are wash sales handled?

If your CSV includes wash sale figures, they pass through using the standard crypto codes (322 short-term, 324 long-term). The IRS has not formally extended the wash sale rule to digital assets for the 2025 filing year, so we honor whatever your source reports rather than inferring new adjustments.

Is my file stored anywhere?

No. Your upload is processed in memory and deleted when the conversion finishes. The output bundle stays available for 24 hours, then is removed. There's no account to create.

Got a different crypto CSV? The CSV to TXF Converter handles every source. Open the CSV to TXF Converter.

Koinly, meet Excel / Google Sheets

Free preview. $6.99 to unlock the CSV and the rest of the bundle.