Open your Trade Republic export in Excel
Statement, transactions, spending: the right file, and the right way to open it.
Updated 7 October 2026
The Trade Republic transaction export is a CSV file, so it opens in Excel. It separates columns with commas and writes amounts with a decimal point: fine if your Excel uses English regional settings, misread if it uses German, French, Spanish or Italian ones. In that case use Data › From Text/CSV, or export from NokxiStats a file already in your spreadsheet's format.
What the file contains
The file is named transactions_YYYY-MM-DD_YYYY-MM-DD.csv (how to download it). It has one row per transaction and 23 columns, all in double quotes, encoded in UTF-8. The main ones:
| Columns | Content |
|---|---|
date, datetime | Day of the transaction (2026-03-14) and exact time, in UTC. |
category, type | Cash account (CASH) or securities (TRADING), then the kind: BUY, SELL, DIVIDEND, INTEREST_PAYMENT, CARD_TRANSACTION, TRANSFER_IN… |
account_type, asset_class | The account and the asset class: stock, fund, crypto. |
name, symbol | Name of the security or merchant, and the ISIN. |
shares, price | Quantity (negative for a sale) and unit price. |
amount, fee, tax | Amount in euros, negative when money leaves, then fees and tax withheld. |
original_amount, original_currency, fx_rate | Amount, currency and exchange rate of a payment abroad. |
counterparty_name, counterparty_iban | Sender or recipient of a transfer. |
mcc_code | Merchant category code, for card payments. |
transaction_id | Unique identifier of the transaction. |
Amounts have six decimals and a point (-12.900000), and dates are written year-month-day. That is
what confuses a spreadsheet set up for continental Europe.
Open it in Excel without breaking the amounts
With English (UK, Ireland, US) regional settings, a double-click works. With German, French, Spanish, Italian or
Dutch settings, the file often lands in a single column, and an amount such as 3.910000 is read as
text, as a date or as a number far too large. Import it instead:
- In an empty workbook, open Data, then From Text/CSV, and pick the file.
- Check the preview: File Origin on “65001: Unicode (UTF-8)”, Delimiter on “Comma”. Click Transform Data.
- Select the number columns (
shares,price,amount,fee,tax), right-click a header, Change Type, then Using Locale: data type “Decimal Number”, locale “English (United States)”. - Click Close & Load. The amounts are now real numbers, shown in your own format.
Labels vary slightly between Excel versions. The import does not change the original file.
Do not save the original CSV from Excel if you plan to drop it into NokxiStats afterwards: Excel changes the separators and the dates, and the file is no longer recognised. Work on a copy or in an .xlsx workbook.
Google Sheets and LibreOffice
- Google Sheets: File › Import, separator type “Comma”. If the amounts stay left-aligned, like text, switch the sheet's locale to “United States” for the import (File › Settings).
- LibreOffice Calc: the import dialog opens by itself. Choose the character set “Unicode (UTF-8)”, the language “English (USA)” and the separator “Comma”.
The easy way: a CSV that just opens
If what you want is your card payments, transfers, interest and dividends in a spreadsheet, NokxiStats does the work. Drop the export into the dashboard, open the Spending tab, then Transactions and Export as CSV.
- The file follows the language of the page: comma and decimal point here, semicolon and decimal comma on the German, French, Spanish and Italian pages.
- Seven columns: date, description, type (spending or income), category, amount in euros, original amount and currency.
- The merchant name is cleaned up and every card payment has its category (groceries, restaurants, transport…).
- The export follows the period, month, category and search you have selected.
The file is created in your browser; nothing is uploaded. Security purchases and sales are not in it: they are analysed on the Portfolio performance page. The categories are explained on the Spending by category page.
PDF statement or CSV export?
Trade Republic provides two different documents. The account statement is a PDF, meant to be read or passed on: converting it to Excel shifts columns and leaves amounts to fix by hand. The transaction export lists your transactions as a table, made for a spreadsheet. For Excel, always take the CSV.
Frequently asked questions
Excel shows everything in a single column
The file was opened with a double-click and Excel expected semicolons. Close it without saving and use Data › From Text/CSV, with the “Comma” delimiter.
The amounts are huge, turned into dates or left-aligned like text
Excel did not understand the decimal point. Run the import again and give the amount columns the type “Decimal Number” with the locale “English (United States)”.
Can I convert the Trade Republic PDF statement to Excel?
A converter can do it, but it is unnecessary and unreliable: the transaction export already lists your transactions, column by column.
How do I get totals per category or per month?
With the CSV exported from the Spending tab: select the table, Insert › PivotTable, the category in rows, the date (grouped by month) in columns and the amount in values.
Is my file sent anywhere?
No. NokxiStats reads the file in your browser and creates the CSV on your device. The details are on the Privacy page.