BR
BankStatementReader

How to Download a TD Statement in CSV Format

By BankStatementReader Team ·

TD usually delivers your statements as PDFs, which are easy to read but awkward to analyze. If you want your transactions in a spreadsheet or accounting tool, you need CSV. The good news is there are two reliable routes to get there: download recent activity as CSV directly from online banking where that option is offered, or convert the PDF statement to CSV for any period that isn't available as a download. This guide covers both. (Menu labels change over time, so these are the general steps rather than exact button names.)

Two ways to get TD transactions as CSV

It helps to understand the distinction up front:

  • Recent transaction download — many banks let you export recent account activity (for example, the current period or the last several months) as a CSV or similar data file. This is the quickest path when the period you need is recent.
  • PDF statement conversion — formal monthly statements are typically provided as PDFs. For older periods, or whenever a CSV download isn't available, you convert the PDF into CSV yourself.

Which one you use depends on how far back you need to go and what your online banking offers.

Option 1: Download recent transactions as CSV (where available)

If the activity you need is recent, it's worth checking whether TD online banking can export it directly. Where the option exists, banks generally let you download recent transactions or account activity in a spreadsheet format — CSV or something similar. Important: this is not guaranteed for every account or every period, and TD doesn't offer a CSV download for all products. The exact wording, placement, and availability of any export option can vary by account type and by the version of online banking or the app you're using, so treat the steps below as a general approach rather than exact button names.

A typical approach looks like this:

  1. Sign in to TD online banking, ideally on a desktop browser — download options, where present, tend to be easier to find on desktop than in the mobile app.
  2. Open the chequing, savings, or credit card account you want.
  3. On the account activity or transaction view, look for an export or download option. It may be near the transaction list, behind a menu, or not present at all depending on the account.
  4. If a download is offered, choose your date range. Exports are commonly limited to recent activity rather than years of history.
  5. If you're given a choice of format, pick a spreadsheet-friendly one. CSV may be labelled as "CSV," "spreadsheet," "Excel," or "comma-separated values," but the available formats vary.
  6. Save the file, then open it in Excel, Google Sheets, or your accounting software.

If no CSV or spreadsheet export appears for the account or period you need, that's expected — CSV download isn't available for all accounts or all date ranges, and formal statements and older history are usually only provided as PDFs. That's exactly why Option 2 below exists as a fallback: when there's no CSV download, you convert the PDF instead.

Quick checks for the CSV file

  • Open the file and confirm the columns make sense: date, description, and amount at a minimum.
  • Note whether debits and credits are in one column (with negatives) or split into two — your accounting tool may expect one layout.
  • Check the date format. Tools sometimes misread day/month order, so verify a few rows against the source.

Option 2: Convert a TD PDF statement to CSV

When a direct CSV download isn't offered, start from the PDF statement. First, get the document itself — see how to download a TD bank statement for the steps to find and save the PDF. Once you have it, you have a few ways to turn it into CSV.

Copy and paste (only if there's a text layer)

If the PDF has selectable text, you can sometimes highlight the transaction table and paste it into a spreadsheet. In practice the columns often collapse together, multi-line descriptions break the row alignment, and dates and amounts merge. You can clean this up with Data → Text to Columns in Excel, but it's tedious and easy to get wrong on a long statement.

Manual entry

For a single short statement, typing the rows in by hand is an option. It needs no tools, but it's slow and a transposed digit in an amount column is easy to introduce and hard to spot later. This route doesn't scale past a page or two.

Automated conversion

A dedicated converter reads the PDF — including scanned or image-only statements that have no selectable text — finds the transaction table, and exports clean, structured rows. This is the fastest route when you have several statements or a monthly workflow, because the column mapping is handled for you. Drop your TD PDF into the free bank statement converter and export to CSV.

For a fuller walkthrough of converting any statement, including format trade-offs, see how to convert a bank statement to Excel and the guide to bank statement to CSV.

CSV vs Excel: which should you pick?

  • Choose CSV when you're importing into accounting or bookkeeping software, which usually expects a plain, comma-separated file.
  • Choose XLSX (Excel) when you want formatting, formulas, or multiple sheets in one file.

If your converter offers both, export CSV for imports and keep an Excel copy for your own analysis.

Keep your records straight

A few habits make this easier the next time:

  • Keep the original PDF statement even after you convert it. It's your source document if a number is ever questioned.
  • Use consistent file names that include the account and period, so a folder of exports stays sortable.
  • For tax or loan purposes you may need several consecutive periods — download or convert each one and confirm there are no gaps in the dates.

If you're filing or reporting, the Canada Revenue Agency outlines how long to keep financial records on canada.ca.

Summary

For recent activity, try a direct CSV export from TD online banking first. For older periods or whenever no CSV download is offered, convert the PDF statement instead — manual entry or copy-paste for one-off needs, and an automated bank statement converter when you want clean CSV rows quickly and repeatably.

Related reading