Spreadsheets

Spreadsheet cannot read your bank statement PDF: what to do

What to do when a spreadsheet cannot read your bank statement PDF: retyping, copy-paste, CSV or Excel download, converters or an app, and each one's risks.

Editorial illustration for Spreadsheet cannot read your bank statement PDF: what to do

The safest route is to download the statement as CSV or Excel from your bank's net banking, if it offers that, and open it in your sheet. If you only have a PDF, copy-paste or a PDF import can work but often splits columns or merges lines, so check the result against the statement's own balances. Avoid uploading a statement to a random online converter.

What are your options, and what can go wrong with each?

OptionGood forRisks
Retype by handA few rows, cash notesSlow; typos; you will stop after a few weeks
Copy and paste from the PDFA one-page statementColumns merge, descriptions break across lines, dates paste as text
Excel's own PDF importNewer Excel on a computer, tidy tablesPage headers repeat as rows; amounts may arrive as text
CSV or Excel from net bankingMost monthsNot every account offers it; column order can change between banks
Online PDF converterLast resortYour whole statement is uploaded to a third party
Expense app that reads statementsRegular monthly useNot every layout reads perfectly; review the rows

Why does my PDF paste as one messy column?

A PDF is a picture of text positioned on a page, not a table. Pasting it gives you lines in the order the file stores them, so a multi-line description can spill into the next row and the debit and credit amounts end up under one heading. Fix by pasting into a staging tab, then using Data, Text to Columns, or formulas such as =LEFT, =MID and =FIND to split text. Expect to spend time on it each month.

A note on Excel's own import: in recent Excel for Windows, Data, Get Data, From File, From PDF lists the tables it finds in the document. Pick the one with the transactions, then use Transform Data to remove repeated header rows and set the amount columns to numbers. Check which of your Excel versions offers it, as it is not in every edition.

What if the PDF is locked?

Many bank PDFs are locked with a password that the bank tells you how to form. Open it yourself in your own PDF viewer, then print to PDF or save a copy without the lock if your viewer allows that. Do not give the statement and its unlock key to a website; that hands over everything in it. If a file will not open at all, download it again from your bank.

How do you avoid retyping every month?

  • Use the CSV or Excel download wherever your bank offers one, since it keeps columns separate.
  • Keep one tab for raw statement data and another for your cleaned table, so you never edit the original.
  • Set a monthly date for downloading, so statements do not pile up.
  • Add a duplicate check: =COUNTIFS($A$2:$A$500,A2,$C$2:$C$500,C2,$B$2:$B$500,B2)>1 flags rows with the same date, amount and description.

Where an expense app fits

SpendixAI takes a statement as PDF, CSV or Excel, you choose the account first, and you review the rows before saving. It does not need your net-banking login and does not connect to your bank. It cannot promise that every statement layout will parse perfectly, so look at the preview. An optional feature for reading an unfamiliar layout does process the uploaded document, which the AI and privacy information explains, so decide whether you are comfortable with that.

A practical order to try

  1. Download CSV or Excel from your bank, if available.
  2. Otherwise try an import that keeps the table shape, and run the balance check.
  3. If neither works, use an app that reads statements and review its rows, or retype the month once and set up a better source for next time.
SPENDIXAI JOURNAL

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

Explore your reports