How to Convert Citibank Statements to Excel or CSV

Key Takeaways

• Citi lets you download recent transactions as CSV or QFX from online banking, but official monthly statement PDFs are only available as PDF — you cannot export them directly to Excel.
• Manual copy-paste from Citibank PDFs produces broken columns and misaligned rows, especially with Citi credit card statements that group transactions by category.
• Several tools can convert Citibank PDFs to spreadsheets: free open-source options (Tabula), cloud-based services, and on-device converters — each with different trade-offs in accuracy, privacy, and cost.
• On-device converters process your statement locally — no upload, no third-party access — which matters for documents containing account numbers and transaction history.
• Whichever method you choose, always verify your converted data against the original statement totals.

Disclosure: This article is published by the company that builds LocalExtract, an on-device bank statement converter. We have a commercial interest in this topic. LocalExtract is presented as one option among several. We encourage you to test any tool against your own Citibank statements and verify claims independently.

Citibank is one of the largest banks in the United States, serving millions of consumer and business clients across checking, savings, and credit card products. If you manage personal finances, run a small business, or handle bookkeeping for clients with Citi accounts, you have likely needed to get statement data into a spreadsheet for reconciliation, tax preparation, or analysis.

This guide covers the main methods for converting Citibank statement PDFs to Excel or CSV — what works, what doesn't, and the trade-offs of each approach.

Contents

• Why Convert Citibank Statements to Excel or CSV?
• What Citibank Statement Formats Does LocalExtract Support?
• How to Convert Citibank Statements — Step by Step
• Alternative Methods
• What the Output Looks Like
• Tips for Working with Citibank Statements
• FAQ
• Getting Started

Why Convert Citibank Statements to Excel or CSV?

There are several practical reasons you might need Citibank statement data in spreadsheet form rather than as a PDF:

• Monthly reconciliation — matching Citi transactions against your accounting software or general ledger is far easier with structured data than with a PDF you have to read visually
• Tax preparation — tax professionals need categorized transaction data to identify deductible expenses, income, and reportable interest. A CSV file can be sorted, filtered, and summed in seconds; a PDF cannot
• Expense analysis — tracking spending patterns, vendor payments, or subscription costs across multiple months requires data you can pivot and chart
• Client deliverables — bookkeepers and accountants often need to provide clients with formatted transaction summaries. Starting from a spreadsheet is far more efficient than retyping from a PDF
• Audit support — maintaining organized, searchable financial records in spreadsheet format helps during audits or financial reviews
• Multi-account consolidation — if you or your clients hold accounts at multiple banks, converting all statements to a common CSV format lets you combine and analyze them together

Citi's online banking does offer a recent transaction download feature, but it only covers recent activity — not archived monthly statements. For official statement PDFs, you need a conversion tool.

What Citibank Statement Formats Does LocalExtract Support?

Before choosing a conversion method, it helps to understand the different PDF layouts Citibank uses.

Citibank Checking and Savings Statements typically include:

• A header block with account holder name, address, account number (partially masked), and statement period
• An account summary showing beginning balance, total credits, total debits, fees, and ending balance
• A transaction detail section organized chronologically with date, description, and amount columns
• Fee disclosures and regulatory notices at the end

Citi Credit Card Statements (Double Cash, Custom Cash, Rewards+, etc.) use a different layout:

• An account summary with previous balance, payments, credits, purchases, cash advances, balance transfers, fees, interest charges, and new balance
• A payment information box with minimum payment due, payment due date, and late payment warning (as required by the CARD Act)
• Transaction details grouped by category — payments/credits and purchases/debits — with transaction date, post date, description, and amount
• Interest charge calculation details and fee summary
• Rewards summary (for cards with reward programs)

Citibank Business Account Statements follow the consumer layout but may include additional sections for wire transfers, ACH batch details, or treasury management summaries.

All Citibank statement PDFs downloaded from online banking are text-based (not scanned images), meaning the transaction data is embedded as selectable text. Text-based PDFs are faster and more accurate to convert than scanned documents requiring OCR. You can verify this: open the PDF and try selecting text with your cursor. If the text highlights, it is text-based.

LocalExtract supports Citibank checking, savings, and credit card statement formats. The engine detects the bank and account type automatically — no manual selection required.

How to Convert Citibank Statements — Step by Step

Here is the complete process for converting a Citibank statement PDF to Excel or CSV using LocalExtract.

Step 1: Download Your Citibank Statement PDF

1. Log in to your Citibank online banking account
2. Navigate to "Statements" or "Statements & Documents"
3. Select the statement period you need
4. Download the statement as a PDF to your computer

Step 2: Open LocalExtract

Launch LocalExtract on your Mac or Windows PC. If you have not installed it yet, download it here — free to start, no account required.

Step 3: Import the Citibank Statement

Drag and drop the Citibank PDF into the LocalExtract window, or click "Select PDF" to browse. The engine detects the bank format automatically — no need to select "Citibank" from a dropdown.

Step 4: Review the Extracted Data

LocalExtract displays the extracted transactions in a preview table. Check that:

• The statement period dates are correct
• Transaction dates, descriptions, and amounts align properly
• The beginning and ending balances match your statement
• For credit card statements, payments and purchases are correctly categorized

Step 5: Export to Excel or CSV

Click "Export" and choose your format:

• CSV — universal format, works with any spreadsheet app or accounting software. See our guide on converting bank statement PDFs to CSV.
• Excel (.xlsx) — formatted spreadsheet with column headers. Best for manual review or sharing with clients. See our guide on converting bank statement PDFs to Excel.

The entire process — from drag-and-drop to export — typically takes under 10 seconds for a standard Citibank statement.

Processing speed benchmark: We tested LocalExtract against 15 text-based statement PDFs from 8 banks (including Citibank) on an Apple M2 MacBook Air with 8 GB RAM:

Metric	Result
Average processing time	47ms per statement
Range	4ms – 353ms
Successful parses	14 of 15 (93.3%)
Failed parse	1 statement with non-standard layout (format support added within 48 hours)

We only benchmarked our own product. We did not test competing tools under identical conditions, so we cannot make direct speed comparisons. Cold start (first run after launching the app) adds approximately 1-2 seconds for engine initialization.

Limitations

• Free tier cap — the free tier includes 10 pages (lifetime). The Pro plan ($10/month or $60/year) is required for ongoing use
• Desktop only — LocalExtract runs on Mac and Windows. There is no mobile app or browser-based version
• Parse coverage — in our internal benchmark, 14 of 15 statements parsed successfully (93.3%). Statements with non-standard layouts may require a parser update, which we typically ship within 48 hours of a report
• Export formats — CSV and Excel (.xlsx) only. QBO, OFX, and QFX export are not supported
• Cold start — the first conversion after launching the app takes 1-2 seconds longer due to engine initialization

Alternative Methods

LocalExtract is not the only way to convert Citibank statements. Here are the main alternatives, with their trade-offs.

Citi's Built-In Transaction Download

Citibank offers a transaction download feature through online banking.

What you can do:

1. Log in to your Citibank account online
2. Navigate to your account's transaction activity
3. Look for a download or export option
4. Select a date range and choose a format (CSV, QFX, QBO, or OFX depending on the account type)

Limitations:

• Only recent activity — the download covers recent transactions, not full monthly statements
• Not the same as your statement — the export reflects posted transactions for a date range, not the official statement with summary, fees, beginning/ending balances, and disclosures
• No statement-period alignment — if you need data matching a specific monthly statement for reconciliation, the date-range export may not line up
• No archived statements — older monthly statements under "Statements & Documents" are available only as PDF

Manual Copy-Paste from PDF

Open the Citibank statement PDF, select the transaction table, copy, and paste into Excel or Google Sheets.

The problems:

• Column misalignment — dates, descriptions, and amounts land in the wrong columns or merge into a single cell
• Multi-line descriptions collapse — Citibank transaction descriptions sometimes span two lines (merchant name on one line, reference details on the next). Copy-paste merges or splits these unpredictably
• Category headers mix in — credit card statements include section headers ("PAYMENTS AND CREDITS," "PURCHASES") within the transaction area. These end up as data rows with no amount, breaking column alignment
• Page-break artifacts — headers, footers, and page numbers inject into the data at page boundaries
• Time cost — a multi-page statement takes 15-30 minutes to clean up manually, and errors are common

For a single short statement with a handful of transactions, manual copy-paste is tolerable. For anything more, it is not practical.

Tabula (Free, Open-Source)

Tabula is a free, open-source tool for extracting tables from PDF files. It runs locally on your computer (Java-based) and does not upload your data anywhere.

How to use Tabula with Citibank statements:

1. Download and install Tabula from tabula.technology (requires Java)
2. Open Tabula in your browser (it runs a local server)
3. Upload your Citibank statement PDF (the file stays on your machine)
4. Draw selection boxes around the transaction tables on each page, or use the Autodetect Tables feature
5. Click "Preview & Export Data" and choose CSV or TSV format

Strengths:

• Completely free and open-source (GitHub)
• Data never leaves your computer
• Works across Mac, Windows, and Linux
• Good community support

Limitations:

• Manual table selection — you need to identify and select table regions on each page, which is tedious for multi-page statements
• No bank-specific awareness — Tabula does not understand Citibank's statement structure, so category headers, multi-line descriptions, and page-spanning tables require manual cleanup
• Multi-line row handling — descriptions that wrap to a second line often become separate rows in Tabula's output
• No batch processing — each PDF must be processed individually with manual table selection
• Requires Java — Tabula needs a Java runtime environment installed

Tabula is a solid choice if you have a small number of statements to convert and are comfortable with manual cleanup.

Cloud-Based Converters

Cloud-based services accept a Citibank statement PDF upload, process it on their servers, and return a CSV or Excel file.

Examples include:

• DocuClipper — specializes in bank statement conversion. Supports many banks including Citibank
• BankStatementConverter.com — focused on bank statement PDFs, charges per page
• General PDF converters (Adobe Acrobat online, Smallpdf, etc.) — not bank-specific, but can extract tables from PDFs

Advantages:

• Automated extraction with generally good accuracy for standard formats
• No software installation required
• Some offer batch processing and accounting software integration
• Cloud-based services can update their parsing models server-side without requiring you to install anything

Concerns:

• Data leaves your device — your Citibank statement is uploaded to a third-party server, including account numbers and full transaction history
• Retention policies vary — review each provider's privacy policy before uploading financial documents
• Ongoing cost — most charge per page or per statement, which adds up for professionals processing many statements monthly

For bookkeepers and accountants handling client financial data, uploading statements to third-party servers creates regulatory considerations. The FTC Safeguards Rule (16 CFR Part 314) requires non-bank financial institutions — including accounting firms and bookkeeping services — to implement safeguards for customer financial information. IRS Publication 4557 outlines similar responsibilities for tax professionals. These regulations do not prohibit cloud tools outright, but they require you to assess and document the risk of each data-sharing arrangement. Local processing avoids this requirement by keeping data off third-party servers entirely.

Tool Comparison Summary

Method	Cost	Privacy	Citibank Accuracy	Effort	Best For
Citi built-in download	Free	High (first-party)	N/A (not statement PDF)	Low	Recent transactions only
Manual copy-paste	Free	High	Low (requires cleanup)	High	One-off, small statements
Tabula (open-source)	Free	High (local)	Medium (manual selection)	Medium	Occasional use, tech-comfortable users
Cloud converters	Per-page/subscription	Lower (data uploaded)	High (with bank-specific services)	Low	Convenience, integration needs
On-device converter (LocalExtract)	Free tier (10 pages), Pro $10/month or $60/year	High (local)	High (with Citi support)	Low	Privacy-sensitive, recurring use

For a deeper comparison of cloud versus local processing, see our article on cloud vs. local bank statement converters.

What the Output Looks Like

A well-converted Citibank checking statement produces clean, consistently structured rows that you can open directly in Excel or Google Sheets.

Sample CSV output from a converted Citibank checking statement (data redacted):

Date,Description,Amount
03/01/2026,"DIRECT DEPOSIT - PAYROLL",3150.00
03/03/2026,"DEBIT CARD PURCHASE - WHOLE FOODS",-87.34
03/05/2026,"ZELLE PAYMENT TO JOHN D",-250.00
03/07/2026,"ATM WITHDRAWAL",-200.00
03/10/2026,"ONLINE TRANSFER FROM SAVINGS",500.00

Sample CSV output from a converted Citi credit card statement (data redacted):

Date,Post Date,Description,Amount
02/25/2026,02/27/2026,"AMAZON.COM",-64.99
02/26/2026,02/28/2026,"SHELL OIL",-42.17
03/01/2026,03/01/2026,"PAYMENT - THANK YOU",1500.00
03/03/2026,03/05/2026,"SPOTIFY USA",-10.99

The exact columns depend on the statement type and the tool you use. Credit card statements typically include both a transaction date and a post date. Amounts follow accounting sign convention — positive for credits (payments, deposits) and negative for debits (purchases, withdrawals).

Tips for Working with Citibank Statements

Credit Card Category Groupings

Citi credit card PDFs organize transactions into sections — Payments and Credits, Purchases, Cash Advances, Balance Transfers, and Fees. Each section has a sub-header within the transaction area. When converting, verify that:

• Section headers were excluded from your data rows (they have no amount and will break column alignment if included)
• Transactions from all sections are present in the output — some tools may only capture the first section
• The sign convention is consistent (payments positive, purchases negative, or vice versa, depending on the tool)

Multi-Account Consolidation

If you or your clients hold multiple Citi accounts (checking plus credit card, for example), converting all statements to CSV and importing them into a single spreadsheet lets you see the full financial picture. Use a consistent file naming convention — for example, citi_checking_2026_03.csv and citi_cc_doublecash_2026_03.csv — to keep files organized.

For tips on building efficient workflows with converted statements, see our guide for accountants and bookkeepers.

Handling Large Statement Histories

If you need to convert a full year of Citibank statements (12 PDFs), tools that support batch processing will save significant time. LocalExtract accepts multiple files at once. Tabula requires table selection on each PDF individually. Cloud converters vary — some support batch upload, others require one file at a time.

Verify After Every Conversion

Regardless of which tool you use, always verify converted data against the original PDF:

1. Beginning and ending balances — do they match the statement?
2. Total credits and debits — sum the amounts in your spreadsheet and compare against the statement summary
3. Transaction count — count rows in the spreadsheet and compare to the number of transactions on the PDF
4. Spot-check 3-5 transactions — pick random entries and verify date, description, and amount match exactly
5. Date range — confirm the first and last transaction dates fall within the statement period

This verification takes 2-3 minutes and catches the most common conversion errors before they propagate into your accounting.

Privacy Considerations

Citibank statements contain sensitive information — account numbers, routing numbers, transaction descriptions that reveal spending patterns and vendor relationships, and balance information. When choosing a conversion method, consider where your data goes:

• Methods that keep data local (manual copy-paste, Tabula, LocalExtract): your statement never leaves your computer
• Methods that upload data (cloud converters): review the provider's privacy policy, data retention period, and encryption practices before uploading

For professionals subject to data-handling regulations, the choice of tool affects your compliance posture. See our article on why bookkeepers should be cautious about uploading bank statements for a deeper discussion.

FAQ

Can I download Citibank statements as CSV directly from Citi's website? Not for monthly statements. Citibank offers a transaction download for recent account activity, but your official monthly statement PDFs — available under "Statements & Documents" — can only be downloaded as PDF files. To get statement data into CSV or Excel format, you need to convert the PDF using one of the methods described above.

Does LocalExtract work with Citi credit card statements? Yes. LocalExtract supports Citi credit card statement PDFs, including Double Cash, Custom Cash, and Rewards+ cards. The converter handles the credit card layout — which differs from checking and savings — automatically, including the grouped transaction categories (payments, purchases, fees).

How far back can I convert Citibank statements? You can convert any Citibank statement PDF you have, regardless of age. Citibank retains downloadable statements in online banking for a limited period (check your account for specifics). If you have older PDFs saved locally, those can be converted as well — the PDF format is stable across years. Very old statement layouts may differ from current templates, which could affect parsing accuracy.

Is manual copy-paste accurate enough for a few transactions? For a single-page statement with fewer than 10 transactions, manual copy-paste can work if you are willing to spend a few minutes cleaning up column alignment. Beyond that, errors from multi-line descriptions and page-break artifacts accumulate quickly. Even for small statements, we recommend verifying every amount against the original PDF.

What if my Citibank statement is a scanned paper document? If you received a paper statement and scanned it to PDF (rather than downloading it digitally from online banking), the PDF may not contain selectable text. LocalExtract includes a local OCR engine that can process scanned statements, though accuracy depends on scan quality. For best results, scan at 300 DPI or higher in black and white. Text-based PDFs downloaded from Citi's website will always produce better results than scanned documents.

How does LocalExtract handle Citibank statements compared to other banks? LocalExtract uses bank-specific parsing logic that adapts to each bank's PDF layout. In our internal benchmark across 15 PDFs from 8 banks (including Citibank), the engine successfully parsed 14 of 15 statements with an average processing time of 47ms on an Apple M2 MacBook Air with 8 GB RAM. Each bank has its own layout quirks — Citi credit card category groupings, for example — and the parser handles these automatically. See our guides for Chase, Bank of America, and other supported banks.

Getting Started

LocalExtract is free to try — the free tier includes 10 pages (lifetime) with no account required and no data uploaded. Processing happens entirely on your Mac or Windows PC.

Download LocalExtract and convert your first Citibank statement in under 30 seconds.

If you process statements regularly, the Pro plan ($10/month or $60/year) removes the page limit. For accountants and bookkeepers managing multiple clients, see our accountant workflow guide for tips on building an efficient conversion pipeline.

---

This article is published by the LocalExtract team. LocalExtract is one of several tools that can convert Citibank statement PDFs to CSV and Excel. Processing times cited were measured on Apple M2 MacBook Air hardware in March 2026 using the methodology described in the benchmark section above. We did not test competing products under identical conditions.