How to Import Citibank Bank Statement into Google Sheets

To import your Citibank statement into Google Sheets: download your PDF from online.citi.com → Statements → Download PDF, convert it to CSV using Bank Statement Converter (free, under 20 seconds), then upload via Google Sheets → File → Import → Upload. 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 CSV output — download in under 20 seconds.

Step 3: Import into Google Sheets

  1. 1. Open Google Sheets (sheets.new) and create a new blank spreadsheet
  2. 2. Click File → Import → Upload
  3. 3. Drag and drop the CSV file from Bank Statement Converter
  4. 4. Choose 'Replace current sheet' or 'Insert new sheet(s)'
  5. 5. Click 'Import data' — all transactions appear with correct columns

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
Should I import as CSV or Excel into Google Sheets?
Either works. CSV is slightly simpler — File → Import → Upload. If you download Excel (.xlsx) from Bank Statement Converter, you can also open it in Google Sheets via File → Import → Upload and select the .xlsx file.
Does Google Sheets automatically detect dates in CSV imports?
Usually yes. If dates import as plain text, select the date column, click Format → Number → Date to apply proper date formatting. Then you can use MONTH() and YEAR() formulas for analysis.
Can I use Google Sheets formulas on the imported data?
Yes. All Google Sheets functions (SUMIF, QUERY, VLOOKUP, FILTER) work immediately on the imported transaction data. QUERY is especially powerful for date-range filtering.
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