Getting started

PDF to Excel not working: fixing a bank statement conversion

If Adobe Acrobat PDF to Excel is not working on a bank statement, check scanned pages, locked files and messy columns, then verify totals in Excel.

Editorial illustration for PDF to Excel not working: fixing a bank statement conversion

When a PDF to Excel conversion fails or comes out as a mess, the file is usually the problem: a scanned image, a locked statement, or a table that spans pages in an odd layout. Check the file type first, then clean the output in Excel and prove it with totals. we will not describe any company's menus here, so use the tool's own help page for its steps.

Why do conversions fail?

CauseHow to tellWhat to do
Scanned picture of a pageYou cannot select or search the textDownload the original statement again, not a photo
Locked fileAsks for a password to openUse the password your bank gave you for that file, nobody else's
Table with no linesColumns merge into oneConvert, then split the column in Excel
Many pagesHeaders repeat on each pageDelete repeated header rows after converting
Wrong numbers formatAmounts are left-aligned textConvert text to numbers

Steps when it will not convert

  1. Try to select a line of text in the PDF. If you cannot, it is an image, and conversion will be poor.
  2. Download a fresh copy of the statement from your bank, as PDF, and also check whether a CSV or Excel version is offered. That avoids conversion altogether.
  3. Try a smaller date range, such as one month, if a long file fails.
  4. Update the app and restart it, in case the fault is the software.
  5. Try a different tool as a test, to see whether the file or the tool is at fault.

Clean the Excel output

Say the converted sheet has dates in column A, narration in B, debits in C and credits in D, but amounts are text such as 1,250.00. To convert a text amount in C2 into a number, use:

=VALUE(SUBSTITUTE(C2,",",""))

To add up all debits afterwards, use =SUM($C$2:$C$300) on the converted number column. If the dates came across as text, check that Excel recognises them by trying =ISNUMBER(A2), which should say TRUE for a real date.

Worked example: prove the conversion

Say your statement shows total debits of ₹38,420.50 and total credits of ₹52,000.00 for the month. After conversion, your sheet's debit column adds to ₹38,420.50, but the credit column adds to ₹51,250.00. The difference is 52,000.00 minus 51,250.00, which is ₹750.00. Scroll for a row whose amount did not convert, perhaps one split across a page break, and fix that single row. When both totals match the statement, the conversion is trustworthy.

When you do this every month

Re-cleaning a sheet each month is slow. SpendixAI lets you upload a bank or card statement as PDF, CSV or Excel, pick the account first, review the rows before saving, and it flags possible duplicate imports. It does not promise that every layout will read perfectly, so you still check the rows against your statement. Optional features that read an unfamiliar layout process the uploaded document, so read the AI and privacy information before using them.

Do not use shady converters

  • Avoid sites that ask you to upload a bank statement to an unknown service
  • Never type a net-banking sign-in anywhere to download a file
  • Delete downloaded statements you no longer need

Bank statements contain account numbers and balances, so think about where a file goes.

Checklist

  • Text selectable in the PDF
  • Password is your own for that file
  • CSV or Excel version tried first
  • Amounts converted to numbers
  • Totals matched to the statement
SPENDIXAI JOURNAL

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

Explore your reports