How to export your US bank transactions as CSV
Where the big banks put their download option, what to look for, and what to do with the file.
Most large US banks let you download transactions from the website, and a CSV file is the simplest way to move them into a budgeting app. This guide shows how to export bank transactions as CSV from Chase, Bank of America, Wells Fargo, Capital One and Citi, links to the bank's own help where we found it, and ends with importing the file into Vartu on your iPhone.
A caution before the steps. Banks rename menus and move buttons often, and we have not tested every bank's file with Vartu. So the directions below say what to look for, not exact click paths. When in doubt, the bank's own help page wins.
Quick overview
| Bank | Where to look | Typical formats | Help |
|---|---|---|---|
| Chase | Open the account on the website, look for a download or "Download account activity" option | Usually CSV, plus other formats | Search Chase's help for "download account activity" |
| Bank of America | Open the account, look for Download or Export on the activity list | Several formats are usually offered; pick CSV or a spreadsheet-friendly one | Online financial management FAQs |
| Wells Fargo | Account Activity page, then look for a Download option | Several, including CSV | Account Activity and statement FAQs |
| Capital One | Open the account or card, look for a download or export option in the transaction list | Often CSV | Search Capital One's help for "download transactions" |
| Citi | Account activity, look for Download or Export | Varies by account | Search Citi's help for "download transactions" |
The table describes where to look, based on what banks have offered; it is not a guarantee, and your account type (checking, savings, credit card, business) can change the options. Where the help-page column has no link, we could not confirm a stable official page, so use the search box on the bank's own help site.
General steps that work almost everywhere
- Use a computer if you can. Web banking usually offers more download options than the mobile app.
- Open the account, then its transaction or activity list.
- Look for words like Download, Export, Download account activity or a small download arrow.
- Choose a date range. Banks often limit how many months, or rows, one file can hold, so you may need several files.
- Choose CSV, or the closest spreadsheet-friendly format (some banks offer "Excel" or "Comma separated"). Avoid formats meant for accounting software (such as QFX, QBO or OFX) unless CSV is not offered; Vartu reads CSV and PDF statements.
- Download. Keep the file somewhere easy, such as iCloud Drive.
Chase
On Chase's website, open the account and look for a download option near the activity list. Chase has described downloading account activity as a choice of date range and file type. We did not find a single stable official help page to link, so search "download account activity" on chase.com's help. Credit cards and checking accounts may be in different places.
Bank of America
Open the account and look for Download, then choose your date range and file type. Bank of America's online financial management FAQs describe what can be downloaded. If you see a choice between spreadsheet and software formats, take the spreadsheet or CSV one.
Wells Fargo
Wells Fargo describes viewing and downloading transaction detail on its Account Activity page, and its statement FAQs cover statements. The download option sits on the activity view; choose the date range and a file format that opens as a spreadsheet.
Capital One and Citi
Both offer a download or export option from the transaction list on the website, for at least some account types. We did not find official help pages that we could link with confidence, so use each bank's help search. Credit card exports and bank-account exports are not always laid out the same way.
Check the file before importing
- Open it in Numbers or a text editor. Confirm there is a header row, a date column, an amount (or separate debit and credit columns) and a description.
- Look at the signs. Some banks show purchases as negative, others as positive with a separate type column. Credit card files are often the reverse of bank-account files. If a file has separate debit and credit columns, combine them into one amount column before importing.
- Look for extra top rows. A few banks add a summary before the header; delete those.
- Pending vs posted. Many files hold only posted transactions. Anything still pending may show up in a later download.
- Row limits. If the file stops sooner than you expected, download the older months separately.
Import into Vartu
- Move the file to your iPhone, then open it from Files or Mail and choose Vartu when asked "Import this file?". Or use Settings → Import statements. This is a Pro feature.
- Choose the date, amount and description columns. Vartu remembers them for that bank, so next month's file needs no setup.
- Check every row on the review screen, then save.
- If your files overlap (for example, you re-download the same week), Vartu does not add duplicate rows twice.
- Create rules so merchants are categorized automatically from now on.
PDF statements work as well; every row is shown for checking before you save. The full walk-through is in our import guide. Vartu has ready-made support only for a few sources (Interactive Brokers, Trading 212 and some UK apps and banks); for US banks you pick the columns yourself, which takes a minute the first time.
Is there a no-file route?
In the US, Apple's FinanceKit only covers Apple Card, Apple Cash and Apple Savings, so ordinary bank accounts still need a file. If you want to avoid connections altogether, importing a file monthly is the usual rhythm. For the philosophy behind that, read budgeting without a bank connection, and if you have an old Mint file, see how to import it.
Common problems
- The file opens as one long line. Open it in a text editor to check the separator, or re-download it. Most bank CSVs use commas.
- Dates look wrong. US files usually use month/day/year. If a file mixes formats, fix the date column in a spreadsheet first.
- Amounts are all positive. Look for a column that marks debits and credits and build a signed amount column.
- The download is a PDF only. Import the PDF statement instead; every row is shown for checking before saving.
- Special characters look odd. Re-export as UTF-8 if the bank offers a choice.
Bank websites change, so if a step here no longer matches what you see, the bank's help page is the authority. Nothing here is financial advice.
When you have a file ready, try Vartu from the App Store. One spending account and one broker account are free, and your data stays on your iPhone.
On a computer?
Scan with your iPhone camera to open Vartu in the App Store.
More guides
- Monarch or Copilot alternative for iPhone, without a bank link
- What to do with your old Mint transactions CSV
- A Mint alternative that never links to your bank
- Track your investments on iPhone, in dollars
Vartu is not financial advice. Forecasts and estimates are arithmetic on your own figures.