Skip to content
DoYourPDF

Banking · How-to

Convert a bank statement PDF to Excel (without uploading it)

Turn a bank statement PDF into one Excel table with real dates and numbers you can add up, on phone or computer. Free; the statement never leaves your device.

HarshFounder, DoYourPDF5 min read

To turn a bank statement PDF into Excel, open PDF to Excel, choose the statement, switch on "Put all pages on one sheet" and press Convert to Excel. You get one table of transactions with real dates and amounts you can add up. It works on a phone or a computer, and the statement is read inside your browser, never uploaded.

People usually need this at ITR time, to send transactions to a CA, to show a loan officer a few months of credits, or to track their own spending. Copying and pasting from a PDF breaks the columns; a proper conversion keeps each value in its own cell.

Before you start: check what your bank offers

If your net banking offers a spreadsheet download of the statement, use it: that file comes straight from the bank's records. This guide is for when all you have is the PDF: the monthly e-statement from your email, or a PDF someone sent you.

Step 1: open the statement

  1. Open PDF to Excel.
  2. Choose the statement PDF, or drop it on the page.
  3. If the statement has a password, a box asks for it. Type it and press Unlock. Not sure what it is? Banks usually build it from details such as your name, date of birth or customer ID; see bank statement PDF passwords for the formats banks publish.

You don't need to remove the password first. If you'd like an unlocked copy of the PDF as well, for a loan app for example, Remove Password makes one.

Step 2: put all pages on one sheet

Switch on Put all pages on one sheet. This is the setting that matters for statements.

With it on, a transactions table that runs across pages with the same columns becomes one continuous table. The column headings that repeat at the top of each page appear once, the bank's letterhead appears once at the top of the sheet, and page numbers are left out. Narrations that wrap onto two lines in the PDF land in one cell.

With it off, you get one sheet per page, which is handy only if you want to compare the Excel file with the PDF page by page.

Step 3: convert and download

Press Convert to Excel and download the .xlsx file. It opens in Excel, Google Sheets, LibreOffice or the spreadsheet app on your phone.

PDF to ExcelTables become real rows and columns. Free, works on your device, nothing uploaded

What you get in the spreadsheet

  • Amounts are numbers. Withdrawals, deposits and balances can be added, sorted and filtered. Commas, decimals and a currency sign such as Rs. are kept as a number format, so the cells look as they did in the PDF.
  • Indian grouping stays. A positive amount printed as 1,23,456.78 still shows that way, and is still a number underneath. Negative amounts and Dr or Cr balances show the usual thousands grouping (123,456.78).
  • Dr and Cr are handled. A balance printed as 5,000.00 Dr becomes the number -5000 and still shows "Dr"; a Cr balance stays positive.
  • Dates are dates. 05-Mar-2026 or 14 Aug 2026 become real dates you can sort by. For dates written as numbers only, such as 05/03/26, see the note below.
  • Long account numbers and references stay text. Numbers of 12 or more digits, and references with leading zeros (000123456789), are kept exactly as printed, so Excel doesn't turn them into scientific notation or drop the zeros.

A note on numeric dates: 05/03/26 could mean 5 March or 3 May. PDF to Excel looks at every date in the statement and decides only when one settles it, such as 25/03/26, which can only be day first. A statement period line such as 01/03/26 to 31/03/26 is enough. If every day in the file is 12 or less, the dates are left as printed rather than guessed.

Check it before you rely on it

Take one minute to compare the spreadsheet with the PDF:

  1. Add up the withdrawal and deposit columns with =SUM() and compare them with the totals in the statement's summary, if it has one.
  2. Check that the last balance in the sheet matches the closing balance in the PDF.
  3. Look at the first and last transaction, and at a page boundary, to make sure nothing was skipped.

If the totals and the closing balance match, nothing has been lost. If they don't, look for a row where the narration ran into the amount column, and fix that cell by hand.

Useful things to do with it in Excel

  • Total one kind of credit. SUMIF adds the amounts in one column for rows whose narration matches a pattern, and it accepts wildcards: =SUMIF(B:B,"*INT*",F:F) adds column F for every row whose column B contains INT. That also catches words such as PRINT or MAINTENANCE, so look at what your bank actually writes in the narration for interest, salary or a particular payee, make the pattern as specific as that wording allows, and adjust the column letters to your sheet.
  • Filter by month or by payee. A long table's heading row already has filter buttons; use them to filter the date column by month or the narration column by a word.
  • Send a clean copy. If your CA or accounting software wants a plain file, PDF to CSV gives the same table as comma-separated values, with dates written as year-month-day.

Scanned or photographed statements

A statement printed from a branch and scanned, or photographed with a phone, is a picture: there is no text for PDF to Excel to read. Run it through OCR: Searchable PDF first, which recognises English and Hindi on your device, then convert the result. The table is only as good as the scan, so always do the checks above.

Your statement stays on your device

A bank statement shows your account number, balance, salary and everyone you pay. PDF to Excel opens and converts it inside your browser; nothing is sent to a server. You can check this yourself: the privacy meter at the top of every page shows how much of your files has been sent to servers, and it stays at 0 B while you convert. There's more on this in is it safe to upload PDFs online?

The Excel file has no password, even if the PDF had one. Keep it in a private folder, and delete copies you no longer need.

Questions people ask

How do I convert a bank statement PDF to Excel for free?

Open PDF to Excel, choose the statement, type its password if it asks, switch on "Put all pages on one sheet" and press Convert to Excel. You get one .xlsx file with the transactions in one table. It's free and the statement is never uploaded.

Will the amounts add up in Excel?

Yes. Withdrawals, deposits and balances become numbers, so SUM and SUMIF work on them. A balance marked Dr becomes a negative number while Cr stays positive, and positive amounts printed with Indian grouping (1,23,456.78) keep that look.

Does it work on a password-protected statement?

Yes. If the PDF is locked, PDF to Excel asks for the password and opens it on your device. The Excel file it makes has no password, so keep it somewhere safe.

Why are my dates showing as text?

A date such as 05/03/26 could be 5 March or 3 May. PDF to Excel turns it into a real date only when some date in the statement settles the order, such as 25/03/26. If every day in the file is 12 or less, the dates stay as printed.

Can I convert a scanned or photographed statement?

Not directly, because a scan has no text to read. Run it through OCR: Searchable PDF first, then convert the result. How well the table comes out depends on how clear the scan is, so check the totals.

Tools in this guide

Remove PasswordUnlock a PDF you have the password for. Free, works on your device, nothing uploadedOCR: Searchable PDFMake scanned PDFs and photos searchable and copyable. Free, works on your device, nothing uploadedPDF to CSVTable data as comma-separated values. Free, works on your device, nothing uploaded

More guides