Bank Statement PDF to Excel: Free Steps and Checks

To convert a bank statement PDF to Excel, upload the statement you downloaded from online banking (not a scan) to ToolistHub's free PDF to Excel Converter, use the default Auto method with Merge all tables into one sheet ticked, and download the .xlsx file. Then check the totals against the statement's balances before you use the numbers.

It works on statements with selectable text, in files of up to 4 MB, with no sign-up.

How to convert a bank statement PDF to Excel

1. Download the statement as a PDF. Use the e-statement from online banking or your banking app, not a scan of a paper statement.
2. Upload it. Open the PDF to Excel Converter and click Upload from PC or Mobile, or drag the file onto the upload box.
3. Open Advanced Settings. Leave Extraction Method on Auto and Pages to Extract on all, and check that Merge all tables into one sheet is ticked (the default).
4. Click Extract Tables to Excel. The result panel shows the method, the pages processed and how many tables were found.
5. Click Download Tables Excel. The file name ends in _extracted_tables.xlsx.
6. Check the sheet before you rely on it (see below).

With Merge all tables into one sheet ticked, every table is stacked on one sheet called Extracted_Tables. Untick it if you want each table on a sheet of its own.

Three things that stop a statement converting

The PDF is password-protected

PDF to Excel cannot open a statement that asks for a password; it stops with an error. If a statement you know is fine is rejected as not valid or damaged, check whether it needs a password to open.

The fix is an unlocked copy, made with your own password in ToolistHub's Split PDF tool:

1. Upload the statement to Split PDF and type its password once, when the Password Required box appears.
2. Choose By Page Range and enter one range that covers every page, such as 1-6 for a six-page statement.
3. Set Output Format to Individual Files, click Split PDF and download the new PDF. It has the same pages without the password.

Do this only for your own statements. Split PDF keeps the upload and its previews in a temporary folder until a cleanup clears files older than 15 minutes, and you should delete your unlocked copy once you have the spreadsheet.

The statement is scanned or photographed

PDF to Excel reads the text stored inside a PDF. A scanned or photographed statement is only a picture of each page, and PDF to Excel has no text recognition (OCR), so the converter finds no tables.

To check, try to highlight a single word in the PDF. If you cannot (nothing highlights, or the whole page highlights as one picture), the page is an image. Download an e-statement from online banking instead, if your bank offers one.

The file is over 4 MB

PDF to Excel and Split PDF both accept files of up to 4 MB, so splitting a large statement on ToolistHub does not get around the limit. Download shorter periods from online banking instead, for example one month at a time, and convert each file.

Auto, Lattice or Stream: matching your statement's layout

The Extraction Method setting decides how the converter finds the transaction table:

• Lattice reads tables drawn with lines between the rows and columns.
• Stream reads tables without lines, where the columns are lined up by spacing alone.
• Auto tries Lattice first and switches to Stream only when no page has a ruled table.

So if page 1 has a ruled summary box but the transactions have no lines, Auto can stop at the summary. If the sheet shows only the summary, or fewer tables than you have pages of transactions, convert again with Stream. Do the same if you see the message "No tables were found in this PDF". If Stream finds nothing either, the statement is probably a scan.

To skip a cover or advert page, list the pages you want in Pages to Extract, separated by commas, such as 2,3,4. Ranges such as 2-4 are not accepted.

Check the spreadsheet before you use it

A conversion can split a column, merge two neighbouring columns (such as Debit and Credit), miss a row or leave amounts as text. Compare the columns with the PDF first; if two were merged, use the PDF to move each amount back into its own column. Then run these checks before you budget, file taxes or share the sheet.

Make sure amounts are numbers

The converter writes an amount as a real number when it recognises it: plain figures (with or without a comma every three digits), figures with a minus sign in front, amounts in brackets (which become negative) and amounts with the ₹, $, €, £ or ¥ symbol in front of them. These stay text:

• amounts with Rs, PKR, INR, Dr or Cr attached;
• amounts with the minus sign after them, such as 250.00-;
• figures grouped the Indian way, such as 1,25,000.00;
• account and reference numbers with leading zeros or more than 15 digits, kept as text on purpose so Excel does not drop the zeros or round the digits;
• the first row of every table, which the converter treats as a header (more on this below).

Account and reference numbers of 12 to 15 digits without leading zeros do become numbers. Microsoft notes that Excel's General format shows numbers of 12 or more digits in scientific notation, such as 4.12346E+11, so before you copy the numbers or save a CSV, format that column as Number with 0 decimal places to show every digit.

To test a column, select it and look at Excel's status bar: if it shows a Count but no Sum, the cells are text. Don't judge by alignment, because the converter left-aligns every cell.

To fix currency text, select the column, open Find and Replace (Ctrl+H) and replace the currency text (Rs., Rs, PKR or INR, plus the space after it) with nothing, and do the same with the commas in Indian-style figures. Excel turns the cleaned cells into numbers.

For Dr and Cr, use a helper column with this formula, changing C2 to your first amount cell: =IF(C2="","",IF(UPPER(RIGHT(TRIM(C2),2))="DR",-1,1)*VALUE(TRIM(SUBSTITUTE(SUBSTITUTE(UPPER(C2),"DR",""),"CR","")))). It turns 250.00 Dr (or DR) into -250 and 250.00 Cr into 250. Copy it down, then paste the results back as values.

If your statement puts the minus sign after an amount instead, use =IF(C2="","",IF(RIGHT(TRIM(C2))="-",-VALUE(SUBSTITUTE(C2,"-","")),VALUE(C2))) in the same way; it turns 250.00- into -250.

Fix wrapped descriptions, headers and blank rows

Look for these layout problems, especially in a multi-page statement:

• Wrapped descriptions. A description that runs onto a second line in the PDF can arrive as a row of its own, with text only in the description column. Move that text into the row above and delete the extra row.
• Table titles and repeated headings. With merged tables, each table sits under a title row (Table 1, Table 2 and so on) and its own header row, with two empty rows before the next table. Delete the title rows and every header row that repeats the column headings, so the transactions form one list; a filter on the first column (Data, then Filter) makes them easy to find.
• Transactions used as headers. Before you delete a header row, check that it really holds the column headings. If a page of your statement does not repeat them, the converter uses that page's first transaction as the header row, so keep that row, clear any placeholder text such as Column_5 from its empty cells, and turn its amounts into numbers (header rows are always stored as text).
• Blank rows and page text. Delete rows that are empty all the way across, and rows that are not transactions, such as the bank's name and address, summary lines and "Page 1 of 2" footers. To find empty rows, filter the first column for (Blanks), but check each row before you delete it: some statements print the date only on the first transaction of each day.

Don't sort until the balance check below passes, because sorting hides missing rows.

Match the opening, closing and running balances

The opening balance plus all credits minus all debits should equal the closing balance on your statement, so total the credit and debit columns with =SUM() and compare.

Then check each row. With Date in column A, Description in B, Debit in C, Credit in D and Balance in E, type =E2-N(C3)+N(D3)-E3 in F3 and copy it down, changing the column letters if your sheet is laid out differently. Every row should show 0; any other number marks a transaction that was missed, doubled or misread at that point.

If your statement lists the newest transaction first, use =E3-N(C2)+N(D2)-E2 in F2 instead. If it has a single amount column that you converted with the Dr and Cr formula, use =D2+N(C3)-D3 in E3 (or =D3+N(C2)-D2 in E2 if the newest comes first), with the amounts in C and the balances in D.

Keep your financial data safe

A statement holds your account number, balances and spending, so it helps to know where the file goes. PDF to Excel uploads it to ToolistHub's server and converts it within a single request, in a temporary folder that is deleted before the spreadsheet is sent back to you.

If you would rather not upload a statement, some versions of Excel can import a PDF on your own computer; our guide to extracting data from PDF to Excel for free covers that offline method. Either way, store the spreadsheet as privately as the statement.

Frequently asked questions

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

Upload the downloaded statement to ToolistHub's PDF to Excel Converter, click Extract Tables to Excel and download the .xlsx file. It is free, needs no sign-up and takes files of up to 4 MB.

How do I convert a password-protected bank statement PDF to Excel?

Make an unlocked copy with Split PDF first: type your password once, split By Page Range with one range covering every page and Individual Files as the output, then convert the new PDF. Do this only for your own statements.

Can I convert a PDF bank statement to Excel or CSV?

You get an .xlsx file; for CSV, open it in Excel and choose File, Save As, CSV UTF-8. A CSV holds one sheet only, so leave Merge all tables into one sheet ticked. If your online banking offers a CSV download, use that instead.

How do I convert a bank statement PDF to Excel accurately?

Start from a downloaded e-statement rather than a scan, switch to Stream if Auto misses transaction pages, turn text amounts into numbers, remove blank rows and repeated headings (but keep any transaction used as a header), and confirm that the opening balance plus credits minus debits equals the closing balance.

Turn your next statement into a spreadsheet

A clean conversion comes down to a text-based statement, the right method and a balance check. Upload your next statement to the free PDF to Excel Converter, and for other paperwork see our list of free PDF tools for small businesses.