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.