How to Export Citi Credit Card Transactions as a CSV (Debit and Credit Column Format)
Citi provides CSV downloads from citi.com for both credit cards and bank accounts. The notable difference from other banks: Citi splits money in and money out into two separate columns (Debit and Credit) rather than using one Amount column with negative numbers. That one difference causes most of the trouble people have importing a Citi file elsewhere, so it is covered in detail below.
How to export Citi transactions as a CSV
- Sign in at citi.comUse a desktop browser for the full export options.
- Open the account you wantSelect the credit card or bank account from your account list to view its activity.
- Find the Export or Download optionLook for a download arrow or a link labelled "Export" near your transaction list. On credit cards this often appears just above the transactions on the right.
- Select CSV as the file typeCiti also offers Quicken, QuickBooks, and sometimes Excel. Choose CSV.
- Choose your date range and downloadYou can usually export by statement period or a custom date range. Confirm and the file downloads.
What is inside a Citi CSV file
A Citi export contains these columns:
Citi puts purchases in the Debit column and payments or refunds in the Credit column, both as positive numbers. Fynnap combines the two into a single signed amount automatically, so the import needs no manual editing.
The Citi Debit and Credit columns explained
Most banks give you one Amount column with a minus sign for money leaving your account. Citi does not. It follows an accounting-style layout with two columns, and only one of them is filled on any given row:
Read that as: two purchases, a refund, and a card payment. Here is what each column is doing:
| Column | Example | What it means |
|---|---|---|
Status | Cleared | Whether the transaction has settled. Pending rows can still change or disappear. |
Date | 06/04/2026 | MM/DD/YYYY. On credit cards this is the posting date, which can trail the purchase by a day or two. |
Description | WHOLE FOODS MKT 10233 | The raw merchant string, usually including a store number. |
Debit | 112.47 | Money out: purchases and fees. Always a positive number, never signed. |
Credit | 43.20 | Money in: refunds, statement credits, and payments to the card. Also always positive. |
The trap is the sign. Both columns hold positive numbers, so software that grabs whichever number it finds and treats it as an amount ends up adding your $850 card payment to your spending total. That single mistake inflates a monthly figure more than anything else in a Citi file.
To collapse the two columns into one signed amount in a spreadsheet, add a column with:
where D is Debit and E is Credit. Purchases become negative, refunds and payments positive, which is the convention Chase, Bank of America, and Wells Fargo already use. Fynnap performs this merge on import, so a Citi file needs no editing first.
One more distinction worth holding onto: a refund and a payment both land in the Credit column but mean different things. A refund reverses a purchase and genuinely reduces your spending for the month. A payment is you moving money from a bank account to the card, which is not income and not a change in spending at all. Sorted by Credit they look identical, which is why category rules that read the description matter more on Citi than on other banks.
Citi credit card versus Citi bank account exports
Citi runs credit cards and retail banking on different platforms, and the exports differ accordingly.
Credit card exports use the five-column layout above: Status, Date, Description, Debit, Credit. There is no running balance, because a card balance is what you owe rather than what you have.
Citi checking and savings exports generally include a running balance and may present the date as a posting date with slightly different header wording depending on the account. The Debit and Credit split is the constant across both, which is the part that matters for importing.
Because the wording varies between products and Citi has changed it over the years, the safest thing is to open the file and look at the first line before assuming the layout. Tools that match columns by name rather than by fixed position handle the variation without complaint.
If you hold both a Citi card and a Citi bank account, remember that a payment from the account to the card appears in both files: as a Debit on the bank export and a Credit on the card export. It is one movement of money between two accounts you own. Counting it twice, once as spending and once as income, is the clearest way to make a month's numbers meaningless.
Opening a Citi CSV in Excel or Google Sheets
A Citi export opens in Excel by double-clicking, but Excel takes liberties. Dates commonly get reformatted into a different convention, and blank cells in the Debit or Credit column occasionally cause Excel to guess the wrong column type for the whole range.
In Excel: open a blank workbook first, go to the Data tab, choose From Text/CSV, select the file, and use the preview to set Date to a date type and both Debit and Credit to Decimal Number. Then click Load. Add your merged amount column afterwards using the formula above.
In Google Sheets: open a blank sheet, choose File then Import, upload the file, and set the separator to comma. Leave "Convert text to numbers, dates, and formulas" on if you intend to sum the columns.
A quick sanity check once it is loaded: sum the Debit column and sum the Credit column separately. The Debit total is your gross spending for the period. The Credit total is refunds plus payments, so it will usually be dominated by one large payment figure. If your Credit total looks suspiciously close to your spending, that is the payment, not income.
If you are budgeting rather than doing spreadsheet work, you can skip all of this. Tools that read the CSV directly handle the two-column format and the type guessing without any preparation.
The mobile app, and printing your transaction history
The Citi mobile app cannot export a CSV. It will show statements and save them as PDFs, which is not the same thing: a PDF is a picture of a document, and pulling numbers back out of one is unreliable enough that it is rarely worth attempting. There is no setting that enables CSV export in the app. If a computer is not available, open citi.com in your phone browser and use the browser menu to request the desktop site. The export option reappears and the file saves to your phone's Downloads folder.
To print your Citi transaction history, open your account activity, filter to the period you want, and press Ctrl+P (Cmd+P on Mac). Check the print preview, because the Debit and Credit columns sit on the right of the table and are the first thing to be clipped; landscape orientation usually fixes it. Printing is the right choice when you need a physical record for a landlord, an accountant, or a loan application.
If the goal is to understand your spending rather than to file a copy, export the CSV. Printing and retyping is a long way round to the same numbers.
When the Citi export option is missing
Citi moves this control around more than most banks, so if you cannot find it, work through these.
You are on the app or the mobile site. The usual cause. Switch to a desktop browser or request the desktop site.
You are looking at Statements rather than activity. Statements are PDFs only. The export control sits above the live transaction list.
The control is inside a menu. On some Citi card pages the export is not a visible button but lives behind a small download arrow or a "Manage" or three-dot menu to the right of the transaction list header.
Your filter returned nothing. An empty date range produces either no button or a file containing only headers.
You selected the wrong file type. Citi offers Quicken and QuickBooks formats alongside CSV. A .qfx or .qbo file contains similar data in a structure most budgeting tools cannot read. Go back and choose CSV explicitly.
An extension is blocking it. Privacy extensions and ad blockers sometimes hide banking controls. Try an incognito window with extensions disabled.
How far back can you export?
Citi credit cards generally offer several years of statement history online, though the exportable window is commonly the most recent 12-24 months depending on the product.
Common questions about Citi CSV exports
Why does my Citi CSV have separate Debit and Credit columns?
Citi follows an accounting-style layout: money out is listed under Debit and money in under Credit, both as positive numbers. Other banks combine them into one Amount column using negatives. Import tools that understand the Citi format merge the two automatically.
Do I need to edit the file before importing it?
Not with a tool that supports the split-column format. If you are using a spreadsheet manually, you can create a single amount column by subtracting Debit from Credit.
What does the Status column mean in a Citi export?
It indicates whether a transaction has cleared or is still pending. Pending transactions can change, so most people import cleared transactions only.
How far back can I export Citi transactions?
Usually 12 to 24 months of downloadable activity, though older statements are often viewable as PDFs.
How do I convert the Citi Debit and Credit columns into one amount column?
In a spreadsheet, add a column with the formula =IF(ISBLANK(D2), E2, -D2) where D is Debit and E is Credit. That turns purchases into negative numbers and payments into positive ones, matching the convention every other bank uses. Tools built to read Citi exports do this merge automatically, so no formula is needed.
Can I export transactions from the Citi mobile app?
No. The Citi app shows statements as PDFs but has no CSV export. Sign in at citi.com from a browser. On a phone you can open citi.com and use your browser menu to request the desktop version, which restores the export option.
How do I print my Citi transaction history?
Open your account activity, set the date range, and use your browser print command (Ctrl+P on Windows, Cmd+P on Mac). Printing gives you a readable record but not workable data. If you want to analyse the numbers rather than file them, export the CSV instead.
How do I open a Citi CSV in Excel?
Open Excel first with a blank workbook, go to Data then "From Text/CSV", select the file, and set the Date column to a date type in the preview before loading. Double-clicking usually works too, but Excel sometimes reformats the dates. In Google Sheets use File then Import with comma as the separator.
Why are some rows in my Citi export missing a Debit and a Credit value?
Every row should have exactly one of the two filled and the other blank. A row with both blank is usually a pending authorisation with no settled amount yet. Filtering out pending rows before importing avoids duplicate entries once those transactions post properly.
Does a Citi export include my card number?
No. Citi CSV exports contain the status, date, description, and the two amount columns. Your card number and credentials are not in the file. It still reveals your spending in detail, so treat it as a sensitive document.
Why does my Citi payment show as a positive number?
Payments to your card reduce what you owe, so Citi records them in the Credit column as a positive number. This is correct, but it means a payment can look like income to software that does not understand the two-column layout. A card payment is a transfer between accounts you own, not income, and counting it as income is the most common reason Citi imports look wrong.
Guides for other banks
Fynnap is an independent budgeting tool and is not affiliated with, endorsed by, or connected to Citi. Bank websites change; if a menu has moved, look for any option labelled “Download”, “Export”, or “Account activity”.