Citi statement PDF to Excel: checking, savings, and credit cards
Citi gives you PDFs and nothing else. If you want the transactions in a spreadsheet for budgeting, tax season, or bookkeeping, you have to convert the file first. Here's how to do it for Citi checking, savings, and the credit card variants.
Why this is annoying (the manual way)
Open a Citi PDF in Preview or Acrobat, drag-select a few transactions, paste into Excel. The columns collapse the moment they land. Long merchant strings wrap onto two lines and end up split across cells. The "Statement Period" header repeats on every page and copy-paste treats it as another row. A 10-page personal checking statement turns into 30 minutes of cleanup before you can even start reconciling.
The 30-second method with Bank2XL
Bank2XL is a Chrome extension. One drag, one click.
- Install Bank2XL from the Chrome Web Store at bank2xl.app
- Download the Citi statement from Citibank Online or the credit card portal
- Click the Bank2XL toolbar icon
- Drag the PDF onto the drop zone
- Click "Convert to Excel"
Free during beta: 10 statements a day, no signup. A Citi statement usually converts in 25 to 45 seconds.
What about Citi format quirks
Citi runs a few distinct layouts and each one trips up generic tools in its own way:
- Personal checking and savings statements lead with a "Statement Period" header and use MM/DD/YY dates. The two-digit year confuses tools that try to infer the year from the row; we read it from the period header instead.
- If you have a Citibank checking account with a linked savings, both sit inside the same PDF. Bank2XL splits them into one sheet per account so the running balances don't blend.
- Citi credit card statements (Diamond Preferred, Double Cash, Costco Anywhere Visa, Citi Premier) use a "Statement Closing Date" instead of a period header, and the polarity is reversed against checking. Purchases add to the balance, payments subtract. Tools that assume checking-account math flip the running balance the wrong way.
- The "Charges Since Last Statement" block on cards lists merchant plus category, which template-based parsers often pull into the main running list as duplicates. Bank2XL keeps it as part of the same transaction row.
When to use the alternatives
- Manual copy-paste. Fine for one statement if you have 30 minutes to spare.
- Adobe Acrobat Pro Export to Excel. Workable on Citi checking, messy on the card statements where the credits and charges sections sit on the same page.
- Template-based converters. Accurate on whichever Citi layout the vendor last hand-tuned. Citi tweaks the credit card statement skeleton a couple of times a year and those tools tend to lag. We work without per-bank rules, so a layout change doesn't break extraction.
FAQ
Is the upload safe? My Citi statement has my account number on it. The PDF goes to the extraction backend over HTTPS. We process files in memory, the file auto-deletes within 24 hours, and you can opt out in Settings. Details at /data-retention.html. Account numbers are masked in the Excel output by default. We don't train AI on your content or share it.
Does it handle Citi credit card statements as well as checking? Yes. The statement type (checking, savings, credit card) is detected automatically and the correct polarity is applied. You don't have to flag it as a card statement first.
Can I convert a year of Citi statements at once? During beta you can convert up to 10 a day, so a 12-month run fits in two days. Each PDF runs as a separate conversion in 25 to 45 seconds.
Get started
Install Bank2XL from the Chrome Web Store at bank2xl.app. Free during beta: 10 PDFs a day, no signup. Drop a Citi statement, click Convert, get a clean Excel file back.
Skip the manual cleanup — try Bank2XL free
Drop a PDF, get a clean Excel back. 10 statements per day during beta, no signup, no credit card.