Export file can't be opened
Currently we only offer export files in the CSV (comma-separated values) format.
CSV is a popular format for data exports and can be opened with common spreadsheet applications such as:
- •Apple Numbers for macOS
- •Microsoft Excel for Windows (or macOS)
- •Google Sheets for just about any computer
If you are having issues opening your export file, please make sure your spreadsheet application is up to date or try another spreadsheet application.
Export file is empty or not complete
If the export CSV file has no entries in it, it's likely that dates with no activity were selected for the export request.
A common mistake is to select the desired date of balances rather than the date of transactions. See How do I find my balances on a particular date? for more details.
Please submit a new export request and make sure that the correct dates are selected.
Decimal separators: points vs commas
As a US-based company, we use points (.) instead of commas (,) for separating decimals in numbers.
If you live in a country which uses decimal commas, your spreadsheet application will likely incorrectly interpret our export files. For example, a fee of 1 cent (0.01) might be shown as 100 dollars.
It is currently not possible to export your Kraken account history with decimal commas.
Instructions:
To properly view your export file, please make sure that your spreadsheet application uses points/periods (.) for decimal separation before you open or import your Kraken history.
Note: This is different from simply changing the formatting in a column.
Important: If you saved any changes to the history file on a spreadsheet application with incompatible settings, then you'll need to re-download a fresh history file from our website.
Microsoft Excel
The settings should look as follows:
Decimal separator: "." (period)
Thousands separator: "," (comma)
Thousands separator: "," (comma)
For more details, see this support guide for Microsoft Excel: How to change the character used to separate thousands or decimals.
Google Sheets
In "File" > "Settings", make sure that "Locale" is set to a decimal period country such as the US, Canada, UK, Australia, or New Zealand.