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?
| Option | Good for | Risks |
|---|---|---|
| Retype by hand | A few rows, cash notes | Slow; typos; you will stop after a few weeks |
| Copy and paste from the PDF | A one-page statement | Columns merge, descriptions break across lines, dates paste as text |
| Excel's own PDF import | Newer Excel on a computer, tidy tables | Page headers repeat as rows; amounts may arrive as text |
| CSV or Excel from net banking | Most months | Not every account offers it; column order can change between banks |
| Online PDF converter | Last resort | Your whole statement is uploaded to a third party |
| Expense app that reads statements | Regular monthly use | Not 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
- Download CSV or Excel from your bank, if available.
- Otherwise try an import that keeps the table shape, and run the balance check.
- 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

