How to Import Citibank Bank Statement into Microsoft Excel

To import your Citibank statement into Microsoft Excel: download your PDF from online.citi.com → Statements → Download PDF, convert it to Excel (.xlsx) using Bank Statement Converter (free, under 20 seconds), then upload via Double-click to open — no import steps needed. No manual re-keying — all transactions transfer automatically.

Step 1: Download Your Citibank Statement

  1. 1. Log in at online.citi.com and select your account
  2. 2. Click 'Statements' from the account details page
  3. 3. Choose a statement period from the list
  4. 4. Click 'Download' next to the statement you need
  5. 5. Select PDF format and save to your computer

Step 2: Convert PDF with Bank Statement Converter

Upload your PDF to Bank Statement Converter — select Excel (.xlsx) output — download in under 20 seconds.

Step 3: Import into Microsoft Excel

  1. 1. Download the Excel (.xlsx) file from Bank Statement Converter
  2. 2. Double-click the file to open it in Microsoft Excel
  3. 3. All columns are pre-formatted: Date, Description, Debit, Credit, Balance
  4. 4. Use Excel's AutoFilter (Data → Filter) to sort and search transactions
  5. 5. Add formulas or pivot tables for monthly summary analysis

Frequently Asked Questions

How do I download my Citibank bank statement?
Log in at online.citi.com and select your account → Click 'Statements' from the account details page → Choose a statement period from the list → Click 'Download' next to the statement you need → Select PDF format and save to your computer
Do I need to do anything to the Excel file after downloading?
No. The .xlsx file opens directly in Excel with properly formatted columns. Date, Description, Debit, Credit, and Balance are pre-formatted — dates as Date type, amounts as Number with 2 decimal places.
How do I create a monthly spending summary?
Select any cell in the data → Insert → PivotTable → OK. Drag 'Description' or 'Category' to Rows and 'Debit' to Values. This creates a spending-by-merchant breakdown instantly.
Can I open the Excel file in Google Sheets?
Yes. Go to Google Sheets → File → Import → Upload and select the .xlsx file. All formatting and values transfer correctly.
Is my Citibank data safe to upload?
Yes. Bank Statement Converter processes files in-memory and deletes them immediately after conversion. No data is stored, logged, or used for model training. No account is required.
Convert Free — No Signup