Citibank Bank Statement to Excel

Citibank statements → .xlsx for Microsoft Excel / Google Sheets. Free, private, reconciled.

Drop PDF statements here (Citibank)

Parsed in your browser — nothing uploads. Up to 3 files on the free tier.

How to convert

Drop your PDF into the tool above
Click Export Excel (.xlsx)
Open the file in Excel — columns are typed and ready for formulas

Why .xlsx for Microsoft Excel / Google Sheets

Dates become real Excel dates, amounts become real numbers, so SUM, VLOOKUP and pivot tables work immediately — no numbers-stored-as-text cleanup.

Citibank statement layout notes

MM/DD dates, single Amount column, running balance column on checking; credit card statements show only Credits/Payments vs Charges.

Credit card layout has no balance column — balance checks switch off automatically
Dates sometimes repeat for multi-entry days with blank date cells below
Interest rows appear at period end outside the main table

Import into your software

QuickBooks: Banking > Link account or upload converted file
Xero: Banking > Import statements

FAQ

Does this work with Citibank's current statement design?

Yes — the converter handles the standard Citibank layout (MM/DD dates, single Amount column, running balance column on checking; credit card statements show only Credits/Payments vs Charges.) and falls back to a generic parser for anything unusual.

What if a row parses wrong?

Edit it inline or delete it — the reconciliation chain re-verifies instantly so you can see when the numbers line up again.

Free

$0forever

✓ Unlimited CSV & Excel exports
✓ Full-quality output, no watermark
✓ Balance-chain reconciliation
✓ Up to 3 files per batch
✗ QBO / OFX / QIF exports

Start above — no signup