Santander’s CSV Export Caps at 12 Months. Convert Older PDFs Here.

Santander Bank is a subsidiary of Banco Santander, the Spanish banking giant and one of the largest financial institutions in the world. In the United States, Santander operates about 650 retail branches concentrated in the Northeast, primarily across Massachusetts, Connecticut, Rhode Island, New York, New Jersey, Pennsylvania, Delaware, New Hampshire, and Florida. With $102 billion in assets and more than 1.8 million retail customers, Santander is a significant regional player. The bank offers checking, savings, money market, and CD products under the Santander Bank brand, while its sibling entity Santander Consumer USA handles auto lending, RV loans, and marine financing through a completely separate portal. If you need to convert a Santander statement to CSV, Excel, or QBO, you will hit a few notable limitations that this guide walks through in detail.

Can You Download CSV Directly from Santander?

Yes, partially. Santander Online Banking lets you download transactions in several formats: CSV (Comma Separated Values), Microsoft Excel (.xls), Quicken, Microsoft Money, and QIF. To access these options, log into your account, go to your transaction history, click Download, set a date range, and choose a format.

That said, Santander's built-in export has several real limitations:

• Multiple format options: Unlike many banks that only offer one or two formats, Santander supports CSV, Excel, Quicken, MS Money, and QIF downloads from the transaction history page.
• Custom date range: You can pick a start and end date rather than being limited to preset 30-, 60-, or 90-day windows.
• 12-month cap: The transaction download only covers the last 12 months of activity. Anything older is only available as a PDF statement. If you need data from two, three, or seven years ago, the built-in export is useless.
• 600-transaction limit: Each download is capped at 600 transactions for personal accounts (3,000 for business accounts). If your checking account processes more than 600 transactions in the date range you selected, you have to split the download into smaller chunks and stitch the files together manually.
• Fake Excel file: The "Microsoft Excel (XLS)" option downloads a file with a .xls extension, but the actual content is an HTML table. Modern Excel will warn you that "the file format and extension don't match," and some spreadsheet programs will refuse to open it. LibreOffice versions after 4.1 cannot open these files at all.
• Santander Consumer USA excluded: If you have an auto loan, RV loan, or marine loan through Santander Consumer USA, those accounts live on a completely separate portal (santanderconsumerusa.com) and do not support CSV, Excel, or any structured download. You get PDF statements only.

For anything beyond the last 12 months, any statement from Santander Consumer USA, or a clean Excel file that actually works, you need to convert the PDF itself. For a broader look at downloading statements from any bank, see our guide to downloading bank statements as CSV.

Santander Statement Formats and Quirks

Santander US has multiple product lines, and the PDF statement format varies depending on the account type. Understanding these differences will help you know what to expect during conversion.

Key things to know: Santander US provides up to 25 months of downloadable PDF statements through online banking. The transaction export feature (CSV, Excel, Quicken) only covers the last 12 months. For statements beyond 25 months, you can request copies from a Santander branch or by calling customer service. Santander Consumer USA auto loan and marine loan statements use a completely different PDF format with amortization-style data rather than traditional checking/savings transaction tables. The "Excel" download has been a known issue for years: it is an HTML table wrapped in a .xls extension, and users on forums have reported problems since at least 2012.

Convert a Santander Statement to CSV with CapyParse (Step-by-Step)

Here is how to convert any Santander PDF statement into a clean CSV, Excel, or QBO file using CapyParse:

Account Type Details

CapyParse handles every type of Santander US statement. Here is what to expect for each product line:

Simply Right Checking and Select Checking

Simply Right Checking is Santander's standard personal checking account, while Select Checking is the premium tier that waives fees with a $25,000 balance. Both produce identical PDF statement formats. Statements list deposits, withdrawals, debit card purchases, checks, and fees in separate sections with a running daily balance. Santander also offers a Student Value Checking account for customers between 16 and 25 that follows the same layout. CapyParse reads each section, assigns the correct transaction type, and outputs a single unified table. If your statement includes linked savings or money market accounts on the same PDF, CapyParse detects those sub-sections and produces separate output files.

Santander Savings and Money Market

Santander's savings account carries a $1 monthly fee that is waived if you hold any Santander checking account, maintain a $100 balance, or are under 26. Money Market Savings requires a Santander Select Checking relationship. Both savings products use a straightforward PDF layout with deposits, withdrawals, interest credits, and a running balance. CapyParse extracts all fields cleanly, including the interest earned line that many users need for tax reporting.

Santander Consumer USA (Auto Loans)

Santander Consumer USA is one of the largest subprime auto lenders in the country, financing vehicles through dealership partnerships nationwide. It operates on a completely separate technology platform from Santander Bank, with its own portal at santanderconsumerusa.com. The MyAccount portal lets you view statements and payment history, but there is no CSV, Excel, or structured export of any kind. You can only download or view PDF statements. These PDFs show monthly payment amounts, principal and interest allocation, late charges, and remaining loan balance. CapyParse recognizes the Santander Consumer USA format and extracts payment-level detail, making it easy to build a full amortization history in a spreadsheet.

Certificates of Deposit (CDs)

Santander offers standard CDs with terms ranging from 6 months to 5 years. CD statements are minimal, typically showing interest accrued, interest paid, and maturity details. CapyParse handles these straightforward PDFs and captures all relevant fields for your records.

Import Into QuickBooks, Excel, or Google Sheets

QuickBooks

Export your Santander statement as a QBO file from CapyParse and import it directly into QuickBooks via Banking > Upload transactions. Santander does support direct connections with Quicken and QuickBooks for recent transactions, but those connections are limited to the same 12-month window as the CSV export. For older statements, converting the PDF to QBO with CapyParse is the reliable path. For a detailed walkthrough, see our guide on importing bank statements into QuickBooks.

Excel and Google Sheets

The CSV export from CapyParse opens directly in Excel or Google Sheets with all transaction fields (date, description, amount, balance) in separate columns. This is a genuine CSV file, unlike Santander's native "Excel" download that is actually HTML masquerading as .xls. The CapyParse Excel (.xlsx) export is also available for users who want native spreadsheet formatting with proper data types. For a walkthrough, see our Google Sheets import guide.

Xero, Wave, and Other Accounting Software

Xero, FreshBooks, Wave, and Sage all accept CSV imports for bank transactions. Export from CapyParse in CSV format and follow the import wizard in your accounting platform. See our guides for Xero, Wave, or Sage.

Have a QIF file from Santander? Santander offers QIF downloads for recent transactions. Check out our QBO/QIF to CSV conversion guide to convert those files.

Tips for Santander Conversions

Frequently Asked Questions

Related Articles