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 LocalExtract team. We build the desktop converter and have a commercial interest in this topic. Verify the exported rows against your own statement; bank guides and generic screenshots are not compatibility guarantees.

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.

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.

Check the actual PDF by trying to select and copy its transaction text. Do not assume every file from this bank has the same format. A scan or image-only copy can require OCR, and both text extraction and OCR results must be checked against the original.

Try LocalExtract with your own PDF and compare the output with the original. Compatibility depends on the specific layout and account type; a bank guide is not a guarantee of support.

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. Review the resulting transactions against your original PDF; not every statement layout is guaranteed to work.

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 CSV and Open It in Excel

Click Download CSV to save the reviewed transactions. The current desktop apps export three columns: date, description, and amount.

• CSV — use it for spreadsheet review or an accounting import after checking the required column mapping.
• Excel — open or import the CSV in Excel. If you want an .xlsx workbook, save a copy from Excel; LocalExtract does not export a native XLSX file.

Compare the exported rows with the original PDF before using them. The App does not export investment holdings, security symbols, quantities, prices, or cost basis as separate columns.

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
• Format coverage — test your own PDF and verify every exported row. No bank-specific accuracy or update turnaround is guaranteed.
• Export formats — CSV for use in 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

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

The current desktop workflow imports one PDF at a time. For multiple months, convert and verify each file separately, then combine the CSV files in your spreadsheet if needed.

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? It depends on the statement layout. Try your own statement PDF and verify the resulting transactions. This guide does not establish compatibility for every account or card variant.

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? Before relying on a conversion, try one statement from your own account and compare each exported date, description, and amount with the PDF. Processing time and extraction quality depend on the document layout, scan quality, hardware, and app version. A supported language or another account at the same bank does not establish support for every statement format. No bank-specific accuracy or timing guarantee is provided here.

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.

---

Disclosure: This article is published by the LocalExtract team. We build the desktop converter and have a commercial interest in this topic. Verify the exported rows against your own statement; bank guides and generic screenshots are not compatibility guarantees.