How to Convert a US Bank Statement PDF to CSV

US Bank gives you two paths to get your transaction data into a spreadsheet: a direct activity download that works for recent months, and the official PDF statement for everything older. Here is exactly how to use both, and what to do when the PDF is the only option.

If you bank with US Bank, you have probably noticed that the online portal gives you two different ways to access your transaction history: a live activity feed for recent transactions, and formal monthly statements in PDF format for anything older. When you need that data in a spreadsheet, knowing which path to take saves a lot of time.

Option 1: US Bank's built-in activity download (recent data)

For transactions from roughly the past 12 to 18 months, US Bank's online banking lets you export directly to CSV without any conversion step. This is the fastest route for recent data.

On usbank.com

• Sign in at usbank.com and click the account you want to export.
• Look for the Download Activity or Export button, typically found near the top of the account activity screen.
• Choose a date range and select CSV (or Microsoft Excel) as the file format.
• Click Download. The file opens directly in Excel, Google Sheets, or any spreadsheet app.

In the US Bank Mobile app

• Open the app and tap the account tile.
• Access transaction history and look for a share or download option (availability varies by device). For longer date ranges, the desktop site gives you more control over the export window and format.

One practical limit: the activity download only reaches back as far as US Bank keeps live transaction data in the portal - usually the last few billing cycles to 18 months depending on your account type. For anything older, you need the PDF path below.

Option 2: Convert an older US Bank PDF statement

For any period beyond the activity download window, US Bank makes official monthly statements available as PDFs, typically going back several years. These PDFs are perfectly formatted for reading but not for importing into software - you need a conversion step to extract the raw transaction data.

Step 1: Download the PDF from US Bank

• Log into usbank.com and navigate to your account.
• Select Statements and Documents (sometimes found under Account Services or Documents in the menu).
• Find the statement month you need and click the PDF icon to download it. Repeat for any additional months.
• US Bank generally keeps several years of statement history available online, so you can go back further than the activity download allows.

Step 2: Extract the transaction data

A US Bank PDF statement is designed for human reading: multi-column layout, running balance rows, page headers on every page. None of that structure translates cleanly into a spreadsheet without a converter that understands how to parse it.

Your options:

• Online PDF converters. Upload the file to a web service that converts it. These services work, but they require you to hand your bank statement - including account number, balances, and full transaction history - to a third-party server.
• Excel's Get Data feature. Recent versions of Excel on Windows can attempt to import tables from a PDF. Results on US Bank's multi-column format are inconsistent and often require significant manual cleanup.
• A local desktop converter. Parses the PDF entirely on your own machine, producing clean, column-organized output with no upload required.

Quill handles this locally: drop in a US Bank statement PDF and it reads every transaction row on your own computer, then lets you export to CSV. Nothing leaves your machine and no third party sees your statement data.

Step 3: Review and export

Once the transactions are extracted, take a moment to review the output. A good converter will have date, description, and amount in separate columns. If you use the account for both personal and business spending, tools like Quill also let you split transactions into Personal and Business categories before you export, which saves time when the data lands in your spreadsheet or accounting software.

Which accounts does this work for?

The PDF-to-CSV process works the same way for all major US Bank account types:

• US Bank checking accounts (including US Bank Smartly Checking and Bank Safely Checking): both deposits and withdrawals appear as separate rows with positive and negative amounts.
• US Bank savings accounts: similar format; interest credits appear as their own line items.
• US Bank credit cards (including the US Bank Altitude, Cash+, and Visa Platinum cards): purchases, payments, and credit adjustments each appear as separate rows. Filter out payment rows when summing spending totals or your totals will undercount.
• US Bank business accounts: same process. The statements tend to be longer with more transactions per page, but a parser handles that automatically.

Tips for working with multiple months of US Bank data

If you need a full quarter or a full year of history in one spreadsheet, the cleanest approach is to convert each month's PDF separately and then combine them. Keep the column headers consistent - Date, Description, Category, Amount - so you can paste months together without adjustment.

With Quill, you can drop multiple statement PDFs in at once and export a single combined CSV that covers the full date range, which skips the copy-paste step entirely.

For related guides, see how to import US Bank statements into QuickBooks and how to convert any bank statement PDF to CSV.