Bank statements

Federal Bank statement PDF to Excel: convert and tidy it

Federal Bank statement PDF to Excel: convert it, merge narrations that spill over several rows, drop page clutter and prove the table against the balance.

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

To convert a Federal Bank statement from PDF to Excel, try the CSV or Excel download first, and otherwise import the PDF, merge any narration that runs onto a second row, remove page headings and totals, and check the finished table against the closing balance. The step that most often catches people is the narration that spills over.

Why do some statements break into extra rows?

A printed statement has to fit a page, so a long narration may wrap onto a second or third line. When that is converted to a spreadsheet, each wrapped line can become its own row, with a date and amount on the first row and blank cells on the others. We do not know whether your Federal Bank statement wraps this way, so scroll through the converted table and look for rows with no date.

How do you get the PDF into a sheet?

  1. Try copy and paste of the whole table. If values scatter, use Text to Columns in Excel, or Split text to columns in Google Sheets.
  2. In Excel 365 you can instead use Data, Get Data, From File, From PDF, and pick the table it finds.
  3. If the PDF will not open, it may be locked. Read the bank's note that came with the file and open it in your own PDF viewer first.
  4. Keep the untouched PDF as the reference copy.

How do you merge wrapped narration?

Say dates are in column A, narration in B, debit in C, credit in D and balance in E. Use column F as a helper that gives every row the number of the row where its transaction began. In F2 type =ROW(). In F3 type the next formula and fill it down:

  • =IF(A3<>"", ROW(), F2)
  • Now every wrapped line shares the first line's row number.
  • In G2 join the text of the group: =TEXTJOIN(" ", TRUE, IF($F$2:$F$500=F2, $B$2:$B$500, "")). This needs Excel 365 or 2021, where it spills as a normal formula.
  • In Google Sheets wrap the IF inside ARRAYFORMULA: =TEXTJOIN(" ", TRUE, ARRAYFORMULA(IF($F$2:$F$500=F2, $B$2:$B$500, ""))).

Fill G down, copy it, and paste as values. Then filter column A to keep only rows where the date is not blank, and delete the rest. The first row of each group now holds the full narration.

What else needs cleaning?

  • Header lines repeated at the top of every page. Filter the date column for the word Date and delete them.
  • Page totals, summaries and any closing line printed under the table.
  • Dates stored as text. A date written 14/08/2025 in A2 becomes real with =DATE(RIGHT(A2,4), MID(A2,4,2), LEFT(A2,2)).
  • Amounts with commas stored as text. =VALUE(SUBSTITUTE(C2, ",", "")) turns them into numbers.

How do you know the table is right?

Count and total, then compare with the statement. Say the statement opens at ₹14,000 and closes at ₹12,350, and your cleaned table has debits of ₹31,650 and credits of ₹30,000. Then 14,000 plus 30,000 is 44,000, minus 31,650 is 12,350, which matches the closing balance. Use COUNTA($A$2:$A$500) for the number of transactions and compare it with the number you expect.

Is there a faster way for monthly use?

If you repeat the above each month, a sheet starts to feel like a part-time job. SpendixAI takes the PDF, CSV or Excel file directly, shows you the rows for review before anything is saved, and keeps the account with each transaction. A spreadsheet is still the right tool for a quick one-off look. Use whichever costs you less effort.

Before you close the file

  • Delete helper columns once the values are pasted.
  • Save the sheet with the bank name and the month in the file name.
  • Note the verified closing balance in a cell at the top.
  • If a row looks odd later, compare it with the PDF before changing anything.
SPENDIXAI JOURNAL

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

Explore your reports