How to Convert Citibank Statements to Excel (Bank & Credit Card)

Citibank statements arrive as PDFs — clean to read, frustrating to work with. Whether it's a Citi checking account or a Citi credit card, the moment you need the transactions in a spreadsheet for budgeting, expense tracking, or your accountant, the PDF stands in your way. You need columns; Citi gives you a page.

This guide walks through three ways to convert a Citibank statement into a working Excel file, from a two-minute automated method to the manual route, plus the specific quirks of Citi statements to watch for.

Download your Citibank statement as a PDF

1. Sign in to Citi Online at citi.com (or the Citi Mobile app).
2. Select the account — checking, savings, or a Citi credit card.
3. Open Statements (under "Account Documents" or "Statements & Documents").
4. Choose the statement period and download the PDF.

Citi keeps multiple years of statements online, so you can pull historical periods for tax season. If a PDF is password-protected, open it, enter the password, and save an unlocked copy before converting.

Method 1: AI bank statement converter (fastest)

1. Open the Citibank conversion page. Your first conversion needs no signup.
2. Upload the PDF.
3. The tool reads each transaction and rebuilds the data into columns — date, description, amount, and running balance where present.
4. Download your Excel or CSV file — one row per transaction.

Citi credit card statements group charges into sections (purchases, payments, fees) and often wrap long merchant names across lines. An AI converter that understands statement structure keeps these correct instead of flattening them into a jumble.

Method 2: Copy and paste into Excel (free, fiddly)

1. Open the PDF, select the transaction rows, and copy them.
2. Paste into a blank Excel sheet — most likely everything lands in one column.
3. Use Data → Text to Columns to split date, description, and amount.
4. Clean up wrapped descriptions and re-align amounts by hand.

Workable for a page or two, but Citi's multi-line merchant names make Text to Columns struggle, so expect cleanup.

Method 3: Generic PDF-to-Excel software

General "PDF to Excel" tools automate extraction but don't understand card or bank statements, so section subtotals and wrapped descriptions frequently break the columns. Inspect the output carefully before trusting it.

Which method should you choose?

Tips for clean Citibank conversions

• Use the original downloaded PDF, not a screenshot or scan.
• Separate card and bank statements into different files.
• Verify signs on payments, credits, and refunds after conversion.
• Check the date format matches what your spreadsheet or accounting software expects.
• Reconcile the ending/new balance before using the data.

With your Citibank transactions in Excel, you can categorize spending, track your card month over month, or import into accounting software. For the next step, see our guides on categorizing bank transactions in Excel and bank statement reconciliation.

Frequently Asked Questions