How to convert a PDF bank statement to CSV
Quick answer
Convert the statement with Bank Statement to Excel and choose Download CSV. You get one row per transaction with ISO dates (YYYY-MM-DD), separate Debit and Credit columns, plain numbers without currency symbols, and UTF-8 encoding that Excel and accounting tools read correctly.
- 1Open the PDF statement in Bank Statement to Excel.
- 2Check the balance check and any flagged rows.
- 3Choose Download CSV.
- 4Map Date, Description, Debit and Credit in your import screen.
Free, no sign-up, and your file is read on your own device rather than uploaded.
CSV is the format accounting and budgeting tools import, but it is unforgiving. A date written 03/04/2026 is read as March or April depending on the software, a currency symbol turns a number into text, and an amount of 1.234,56 becomes 1.234 in a tool expecting a decimal point. Most failed imports come down to one of those three.
The CSV from Bank Statement to Excel is written to avoid them: dates as YYYY-MM-DD, which no software misreads; amounts as plain numbers with a decimal point and no currency symbol; money out and money in in separate columns; and a byte-order mark so Excel on Windows reads accented characters correctly.
Step by step
Convert and review the statement
Open the PDF, check that the balance check passes, and correct any flagged rows. A CSV imported with a missing transaction is much harder to fix later than on screen now.
Bank Statement to ExcelDownload CSV
Columns are Date, then Value date and Reference if your statement has them, Description, Debit, Credit, Balance, Status and Review notes.
Bank Statement to ExcelMap the columns in your software
Most import screens ask which column is the date, the description and the amount. If yours wants a single signed amount, map Credit as money in and Debit as money out, or add a column of Credit minus Debit first.
Set the date format to YYYY-MM-DD
If the import screen asks for a date format, choose year-month-day. It is the only format that means the same thing everywhere.
Tips
- Delete the Status and Review notes columns before importing if your software complains about extra columns - they are there for you, not for the import.
- Opening the CSV in Excel and saving it again can change the dates to your local format. Import the file as downloaded.
- If a description in your statement begins with =, +, - or @, it is written with a leading apostrophe so a spreadsheet cannot run it as a formula.
Common problems
Amounts import as text or zero.
Your software may expect a comma as the decimal separator. Change the import setting to a decimal point, since the CSV always uses one.
Every transaction imports as money in.
The import mapped only the Credit column. Map Debit too, or create a signed amount column (Credit minus Debit) before importing.
Characters like é or ₹ look garbled.
Choose UTF-8 as the file encoding in the import screen. The file is UTF-8 with a byte-order mark, which Excel detects automatically.
Frequently asked questions
- Should I use CSV or Excel?
- Excel (XLSX) if a person will read or analyse the transactions - it keeps real dates, number formats and a summary sheet. CSV if a program will import them.
- Does the CSV include the opening and closing balance?
- The running balance is a column on every transaction. The opening balance, closing balance and totals are on the Summary sheet of the Excel download.
Related related tools
- Data CleanerTidy a spreadsheet, and see exactly what changed, with real before-and-after examples.
- PDF to ExcelExtract tables from a PDF into a real spreadsheet with proper columns.
Related articles
- Money & Calculators
How to convert a bank statement to Excel
Open the PDF statement in Bank Statement to Excel, let it read the transaction table, check the balance check and any rows marked for review, then download the XLSX. Dates and amounts arrive as real Excel dates and numbers.
- Money & Calculators
How to extract transactions from a bank statement
Open the statement in Bank Statement to Excel: a locked PDF asks for its password and is unlocked in your browser; a scan is read with OCR. Then use the balance check to confirm every transaction was captured before you rely on the list.
- Excel & Data
Why does Excel drop leading zeros from my CSV?
Excel treats every CSV value as "General" format when it opens the file, which means anything that looks like a number is read as one - and a real number can never start with a zero, so it is dropped. Converting the CSV to Excel with those columns explicitly typed as text, rather than opening the CSV directly, avoids the problem entirely.
Ready to do it?
Free, no sign-up, and nothing is uploaded to a server.