Trading 212 Dividend Tracker, How to Track Trading 212 Dividends, Trading 212 Dividend Income Spreadsheet, Best Dividend Trackers for Trading 212

If you're a dividend investor using Trading 212, you've probably noticed that the platform does a solid job of paying out dividends — but a less impressive job of helping you analyse them. There's no built-in income calendar, no year-on-year comparison, and no way to see at a glance how much your dividend income has grown. That's where knowing how to export Trading 212 data becomes genuinely valuable. Whether you want to build a dividend income spreadsheet, feed data into a dedicated tracker, or connect your portfolio to a more powerful analytics platform, the process starts with getting your data out of Trading 212 in a usable format — and understanding the tools available to do it.

What Data Can You Export from Trading 212?

Trading 212 gives you two primary routes to access your data: the built-in CSV export and the Public API. Both are free to use, and both serve different purposes depending on how hands-on you want to be with your analysis.

The Trading 212 CSV export covers the following data types:

• Orders — all buy and sell transactions, including fractional shares
• Dividends — a record of every dividend payment received, including the gross amount, withholding tax, and net payment
• Transactions — deposits, withdrawals, and currency conversions
• Interest — interest earned on uninvested cash (where applicable)

You can select a custom date range when exporting, which makes it straightforward to pull a full-year dividend history for tax purposes or to build a rolling income tracker. The file downloads as a .csv, which opens directly in Excel, Google Sheets, or any spreadsheet application.

How to Export Trading 212 Dividends Step by Step

The Trading 212 data export process is the same whether you're on the web platform or the mobile app. Here's how to do it:

• Open Trading 212 and go to the Menu
• Select History
• Tap or click the export icon (a downward arrow)
• Choose your date range — you can go back to the start of your account history
• Select the data types you want: tick Dividends (and Orders or Transactions if needed)
• The file will download to your device automatically

Once you have the CSV, you can open it in Excel or Google Sheets and begin filtering. The dividend rows will include the stock name, ticker symbol, payment date, gross dividend, withholding tax deducted, and the net amount credited to your account. This is the raw material for any serious dividend income tracker.

Building a Trading 212 Dividend Income Spreadsheet

For many investors, a well-structured spreadsheet is the most practical way to track dividend income from Trading 212. After importing your CSV export, a useful dividend tracker spreadsheet typically includes:

• Monthly income totals — sum dividends by calendar month to see your income trend over time
• Per-stock breakdown — how much each holding contributes to your total dividend income
• Withholding tax summary — particularly relevant for US-listed stocks like Johnson & Johnson (JNJ) or Coca-Cola (KO), where a 15% withholding tax applies to UK and EU investors
• Year-on-year comparison — comparing this year's dividend income to last year's is one of the clearest signals of portfolio progress
• Forward income estimate — using current yield data to project the next 12 months of expected dividends

The limitation of the spreadsheet approach is that it requires manual updates every time you want fresh data. You need to re-export from Trading 212, paste the new rows into your sheet, and ensure there are no duplicates. It works, but it's a maintenance task that compounds over time as your portfolio grows.

Using the Trading 212 API for Automated Dividend Tracking

For investors who want a more automated solution, the Trading 212 API offers a more powerful alternative. The Public API is free to use and available for Invest and Stocks & Shares ISA accounts (note: it is not currently available for SIPP accounts).

How to Get Your Trading 212 API Key

Generating a Trading 212 API key takes only a few minutes:

• Open the Trading 212 app or web platform and go to Settings
• Select API (Beta)
• Accept the risk warning (required before first use)
• Tap Generate API Key and choose your permissions — for dividend tracking, you'll need at minimum account data and history access
• Give the key a name and optionally restrict it to trusted IP addresses (recommended for security)
• Submit the form — you'll receive both an API Key and an API Secret Key

The API Secret Key is shown only once, so store it securely immediately. If you lose it, you'll need to generate a new key pair. Trading 212 advises treating the Secret Key with the same care as your account password.

What the Trading 212 API Can Return

The Trading 212 REST API gives programmatic access to a range of account data, including:

• Current portfolio positions and open quantities
• Historical orders and transaction records
• Paid-out dividends with full detail (gross, tax, net)
• Account cash balance and portfolio valuation
• Instrument metadata (ticker, ISIN, currency)

The API documentation is available at docs.trading212.com and covers all available endpoints, request formats, and rate limits. For investors comfortable with Python or JavaScript, the API makes it possible to build a live dividend dashboard that updates automatically — no manual CSV exports required. There are also community-built libraries (such as the open-source trading212-api package on GitHub) that wrap the REST endpoints and simplify common tasks.

Connecting the API to Google Sheets or Excel

If you'd rather stay within a spreadsheet environment, the Trading 212 API can be connected to Google Sheets using Google Apps Script, or to Excel using Power Query with a web connector. This approach gives you the best of both worlds: the familiarity of a spreadsheet with the automation of a live data feed. The setup requires some basic scripting knowledge, but numerous community tutorials exist to guide you through the process.

Third-Party Dividend Trackers That Work with Trading 212

If you'd prefer not to build your own solution, several third-party platforms accept Trading 212 CSV exports and provide ready-made dividend tracking dashboards. These tools typically let you upload your exported file and will then categorise your dividend income, display it in charts, and project future payments based on current yields.

When evaluating any third-party tracker, consider the following:

• Data privacy — you're uploading detailed financial records, so check the platform's data handling policy
• Update frequency — some tools require manual re-uploads; others can connect via API for automatic syncing
• Currency handling — if you hold US-listed stocks alongside UK or European equities, the tracker needs to handle multi-currency portfolios accurately
• Tax reporting support — for UK investors in particular, a tracker that separates ISA dividends from general account dividends can save significant time at year-end

For investors who want deeper analytical capability beyond dividend tracking — including fundamental analysis, valuation metrics, and earnings data — a dedicated stock analysis platform can complement your dividend tracker by providing the research context behind each holding.

Making the Most of Your Exported Data

Exporting your Trading 212 data is only the first step. The real value comes from what you do with it. A few practical ways to use your exported dividend history more effectively:

• Identify your top income contributors — knowing which stocks generate the most dividend income helps you assess concentration risk and diversification
• Track dividend growth over time — companies that consistently grow their dividends, such as those in the S&P 500 Dividend Aristocrats index, tend to be worth monitoring closely
• Reconcile with your tax records — the Trading 212 annual statement (also downloadable from the History section) provides a consolidated view suitable for self-assessment tax returns
• Monitor withholding tax efficiency — if a significant portion of your dividend income is being lost to withholding tax, it may be worth reviewing your account type or stock selection

The combination of Trading 212's export tools and a structured approach to data analysis gives dividend investors a much clearer picture of their income than the app alone provides. Whether you opt for a manual spreadsheet, a third-party tracker, or a custom API integration, the starting point is the same: get your data out, and start asking better questions of it.

You can Compare JNJ, KO side by side on Openbook, or find stocks with the screener.