Kraken CSV Export Not Opening or Showing Wrong Numbers? Fix It

Source workflow verified: August 29, 2026

A Kraken CSV export that will not open, appears empty, or shows impossible amounts is often a spreadsheet-import problem rather than damaged account data. The safest fix is to keep the original file untouched, correct the import or locale settings, and reopen a fresh copy.

Identify the Kraken CSV problem before changing anything

How to open a Kraken CSV correctly

Microsoft Excel

1. Create a working copy of the downloaded Kraken CSV.
2. Open a blank workbook instead of double-clicking the CSV.
3. Use Excel’s data import command for a text or CSV file.
4. Select UTF-8 when character encoding is requested and comma as the delimiter.
5. Preview the date, amount, fee, asset, and identifier columns before loading.
6. Import identifiers as text when Excel proposes scientific notation or removes leading characters.
7. Compare several rows with the original before saving as XLSX.

Google Sheets

1. Open a blank spreadsheet and confirm its locale before importing.
2. Use File → Import → Upload and choose a copy of the Kraken CSV.
3. Select comma as the separator if Sheets does not detect it automatically.
4. Avoid converting long IDs or timestamps into rounded numbers.
5. After review, keep the imported sheet separate from the original CSV.

Apple Numbers

Numbers is listed by Kraken as a supported spreadsheet application for viewing CSV exports. Open a duplicate, review delimiter and regional settings, and compare decimal values before using totals.

Fix Kraken CSV values that are 100 or 1,000 times too large

Kraken uses a period (.) as the decimal separator and a comma (,) as the thousands separator. Spreadsheet software configured for a decimal-comma country can interpret the same characters differently. Kraken gives the example that 0.01 may be displayed as 100.

Excel settings

Configure the decimal separator as a period and the thousands separator as a comma before importing the fresh file. Changing only a column’s visual number format after the values were misinterpreted does not necessarily restore the original numbers.

Google Sheets locale

Open File → Settings and choose a locale that uses decimal periods, such as the United States, Canada, the United Kingdom, Australia, or New Zealand. Then import a fresh copy of the CSV.

1. Close the altered working file without overwriting the original.
2. Correct the spreadsheet or locale settings.
3. Download or duplicate a fresh Kraken export.
4. Import it through the data-import workflow.
5. Check a known small fee or amount against the Kraken account view.

Fix an empty or incomplete Kraken CSV

Use transaction dates, not a balance date

Kraken says an empty export commonly results from selecting dates with no activity or confusing a desired balance date with the date of transactions. Generate a new export whose start and end dates surround the transactions themselves.

Widen the date range

Include a small buffer around the expected dates when time-zone conversion might move an entry across midnight. After identifying the rows, make a filtered working copy.

Choose the correct export

Trades contain execution details; ledger history is broader and includes balance-changing activity such as deposits and withdrawals. Follow our complete Kraken transaction-history export guide when the file type is uncertain.

Remove optional filters

An asset, pair, or field filter can exclude the row you expected. Create one broad export to confirm that the data exists, then narrow subsequent copies.

Do not “repair” a Kraken CSV by guessing

• Do not use find-and-replace on commas throughout the raw file.
• Do not manually remove rows that look duplicated until you understand their ledger type.
• Do not upload the file to random online converters; it contains financial activity.
• Do not treat spreadsheet totals as reliable until sample values match the account.
• Do not send a full CSV to unofficial support accounts.

Frequently asked questions