Bank Statement to CSV Converter
Convert PDF bank and credit card statements to CSV for a budgeting app, an accounting import or your own spreadsheet.
- Free, no sign-up
- Runs in your browser
- Nothing uploaded or kept
Drop bank or credit card statements (PDF) here
One or many: each is read and checked on this device. Password-protected PDFs work too.
- Never uploaded
- Every balance checked
- Excel, CSV, QBO, OFX, QIF
How to use it
Add your statements
Drop the PDF statements from your online banking. Password-protected ones ask for the password.
Check the rows
Each row is checked against the balance. Click any cell to correct it.
Download the CSV
Comma or semicolon style, the date format you choose, one file for all statements.
The statement is read in your browser, never uploaded, and each row is checked against the statement's own balance before you download. Choose a comma CSV with a decimal point, or the semicolon style Excel uses in much of Europe.
Why this converter
Most statement converters upload your PDF to their server, give you a few free pages a day and then ask for a subscription. A bank statement holds your account number, your balance and everything you spent money on, so this one is built the other way round.
- Your statement never leaves your device. It is opened by your browser, on this page. Open the Network tab in your browser's developer tools while you convert to see for yourself: no request carries your file.
- Every row is checked. Where the statement prints a running balance, each balance must follow from the one before by exactly that row's amount, and the opening balance plus every row must come to the closing balance. Anything that does not add up is highlighted, so you fix one cell instead of re-checking hundreds.
- Fix it on the page. Click any date, description or amount to correct it, delete a line that is not a transaction, undo, and watch the check update as you go.
- Money in and money out the right way round. From separate columns, minus signs, brackets, DR and CR, section headings such as "Withdrawals" or "Payments and other credits", or the running balance itself. Credit cards come out the same way as bank accounts: purchases out, payments in.
- Password-protected statements. Type the password and the PDF opens here; it is not sent anywhere.
- No limits. No daily cap, no page limit, no watermark, no account. Add a whole year of statements at once.
- Every format. Excel with real dates and numbers and a Summary sheet of live formulas, CSV (comma or European semicolon), QBO for QuickBooks, OFX for Xero, Quicken and GnuCash, QIF, or copy the table straight into Google Sheets.
Which CSV to choose
- Commas, decimal point (1234.56): what QuickBooks Online, Xero, budgeting apps and Excel in the US, UK, Canada, Australia and India read.
- Semicolons, decimal comma (1234,56): what Excel expects in Germany, France, Spain, Italy, the Netherlands and most of Europe, so the numbers open as numbers.
Pick the date format your program uses before you download; YYYY-MM-DD is read the same way everywhere. The file is UTF-8 with a byte-order mark, so names like Café or Zürich come through in Excel. A description that a spreadsheet would run as a formula is written so that it cannot.
What the spreadsheet looks like
| Column | What it holds |
|---|---|
| Date | The transaction date as a real date, so it sorts and filters. A December row on a January statement gets the right year. |
| Description | The full description, with the lines of a long one joined back together. |
| Money out, Money in | Positive numbers in two columns, the way most people read a statement. |
| Amount | One signed column, money in positive and money out negative, for formulas, pivot tables and imports. |
| Balance | The running balance the statement printed, when it prints one. |
| Reference, Posted date | Cheque or reference numbers and the posting or value date, when the statement has those columns. |
A Summary sheet lists each statement with its period, opening balance, money in, money out and closing balance. Money in and out are live formulas over the transactions, so if you change a row in Excel the totals and the difference follow.
How we tested it
A PDF has no table inside it, only bits of text placed on the page. The converter rebuilds the rows from where each piece of text sits, so the layout matters. Before release it was run against 16 test statements laid out the way real banks lay theirs out, with invented names and numbers:
- US checking accounts with one amount column, sections for deposits, withdrawals and checks paid, a check-number column and balances printed once a day.
- UK accounts with money out, money in and balance, dates printed once a day, and amounts on the last line of a long description.
- Indian statements with narration, reference and value-date columns, lakh grouping (1,24,550.00) and Dr/Cr marks.
- German statements with decimal commas (1.234,56) and dotted dates, a Canadian one with brackets for money out, and a list printed newest first.
- Credit cards with payments shown with a minus, and with a running balance of what is owed.
Every one came out exactly and balanced, and a 17th with one deliberately wrong balance was caught and highlighted. The Excel files were opened in Microsoft Excel to confirm that the dates, numbers and formulas come through. Your bank may lay its statement out in a way we have not seen, which is why the check is there: if a row is misread, the balance stops adding up and the row is highlighted.
More free tools for statements and PDFs
The same converter, leading with a different file: Bank statement to Excel, PDF to QBO for QuickBooks and PDF to OFX for Xero and Quicken. Need to send a statement somewhere with a size limit? Compress PDF shrinks it, and Merge PDF puts several months into one file. Both run in your browser too.
Frequently asked questions
Is it safe to convert a bank statement online?
Yes, when the converter runs in your browser, as this one does. Your statement is opened by your own browser on your own device; it is never uploaded, stored or seen by us. You can check: open your browser's developer tools, go to the Network tab and convert a statement, and you will see that no request carries your file. Many other converters upload the PDF to their server to read it, so check how a tool works before giving it a bank statement.
What columns does the CSV have?
Date, Description, Money out, Money in, Amount (money in positive, money out negative) and Balance, plus Reference and the posting or value date when the statement prints them, and the statement's name when you convert several. Most imports want either the single Amount column or the Money out and Money in pair: map the one your program asks for.
Why do the dates or decimals look wrong when I open the CSV in Excel?
A CSV holds plain text, so Excel reads dates and decimals in your computer's regional settings. Pick the date format your Excel uses before downloading (or YYYY-MM-DD, which every program reads), and in Europe choose the semicolon style with a decimal comma. If you just want a spreadsheet, the Excel download avoids the question: its dates and numbers are real values.
Will the CSV import into QuickBooks Online, Xero or a budgeting app?
Yes, those all take a CSV with a date, a description and an amount, and let you match the columns on import. QuickBooks Online also takes the QBO file, and Xero the OFX file, which need no column matching at all: both are on the same page.
How do I convert a password-protected statement?
Add the PDF as usual and type the password when asked. Banks often use your date of birth or part of your customer or account number (HDFC, ICICI, SBI and many credit card companies email statements like this). The password is used only on this page to open the file.
Which banks does it work with?
Statements downloaded from online banking from banks in the US, UK, Canada, Australia, India and Europe: checking and savings accounts and credit cards, with one amount column or separate money in and money out columns, dates written any common way, amounts in any common style (1,234.56, 1.234,56, (45.00), 45.00 DR) and descriptions over several lines. If a layout is not read correctly, the check tells you.
Can it read a scanned statement?
Not yet. A scanned or photographed statement is a picture with no text in it, and this tool reads the text that online banking puts in its PDFs, which is why it is exact. If yours is a scan, download the same statement from your online banking instead.
A free tool from LetRelay: no sign-up, nothing stored on a server.