Bank statements

ICICI Bank statement PDF to Excel: convert and tidy it

Clean an ICICI Bank statement in Google Sheets or Excel: fix text dates, filter out header rows, use QUERY and FILTER, and tally the closing balance.

Editorial illustration for ICICI Bank statement PDF to Excel: convert and tidy it

To get an ICICI Bank statement from PDF into a spreadsheet, download the CSV or Excel version if your own login offers one, because that avoids conversion. Import the file into Google Sheets with File, Import, Upload, then fix the dates, strip the non-transaction rows with FILTER or QUERY, and tally the totals with the closing balance on the statement.

Can Google Sheets open a PDF statement directly?

Google Sheets has no built-in PDF table import, so a PDF has to be converted somewhere else first. Excel for Microsoft 365 has Data, Get Data, From File, From PDF, which can read tables from a PDF. Either route works; the cleaning steps below are the same. We do not know the exact column order of any ICICI Bank file, so first read your own header row, and adjust the column letters in each formula to match.

Why are my dates not sorting?

Sheets may turn 05/04/2026 into a real date or leave it as text, depending on the locale in File, Settings. First test: =ISTEXT(A2). If it says TRUE, the date is text. With text in day/month/year form in column A, this converts a whole column at once from a header-free range:

  • =ARRAYFORMULA(IF(A2:A="","",DATE(RIGHT(A2:A,4),MID(A2:A,4,2),LEFT(A2:A,2))))
  • Put it in an empty column, such as H2. It fills downward by itself.
  • If Sheets treats day and month the other way round, set the locale to India in File, Settings and re-import.

How do I remove header and balance rows?

Converted PDFs carry repeated headings and page-end lines. Once column H holds real dates, keep only the rows where a date exists. With the cleaned date in column H, the statement text in B, debits in C and credits in D:

  1. =FILTER(H2:H500, ISNUMBER(H2:H500)) returns only the real dates.
  2. =QUERY(A1:F500, "select A, B, C, D where C is not null or D is not null", 1) keeps rows that have a debit or a credit.
  3. Copy the cleaned result and use Paste special, Values only, before you delete the original.

QUERY with a text header in row 1 and the last argument 1 treats that row as a heading. The columns A, B, C and D in the QUERY string refer to your sheet's actual columns, so match them to your file.

How do I get monthly totals?

With real dates in H and the debit amount in C, total debits for April 2026 are:

  • =SUMIFS(C2:C500, H2:H500, ">="&DATE(2026,4,1), H2:H500, "<"&DATE(2026,5,1))
  • For credits, change C2:C500 to D2:D500.
  • Use the ">=" and "<" pair rather than "<=" and the last day, so that a transaction on the 30th at any time is included.

How do I know the sheet matches the statement?

Say the printed opening balance is ₹26,000, total credits ₹74,500, and total debits ₹68,900. The closing balance should be ₹26,000 plus ₹74,500 minus ₹68,900, which is ₹31,600. In the sheet: =B1+SUM(D2:D500)-SUM(C2:C500), with the opening balance typed in B1. If the numbers differ, sort by date and look for a missing or repeated row.

Whichever app you use, do the work on a copy. Keep the raw import on one tab and the cleaned data on another, so that a wrong formula never overwrites the only version of your statement. If the cleaned tab goes wrong, you can rebuild it from the raw tab in a couple of minutes.

Is there a quicker route once I have many months?

A sheet works well for one or two months. After that, repeating the cleaning every month gets tiring, and categorising becomes a task of its own. That is the point at which a tracker like SpendixAI is worth a look, since it takes PDF, CSV or Excel statements and shows each row for review before saving. Until then, a tidy sheet with a tally cell for each month is a perfectly good record.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports