BankToRows

PDF statement → CSV

Bank Statement to CSV

Convert a PDF statement to a CSV file with one row per transaction. Choose a plain CSV (date, description, amount, balance) or the 3-column layout that QuickBooks Online’s bank upload reads.

Converted in your browser. Your file is never uploaded.

No file handy?

Nothing uploaded

Files are read and converted in your browser, on your device.

Amounts checked to the cent

Opening + transactions = closing, and each running balance. Dates and currency are confirmed with you.

Fix before you export

Edit any date, description or amount, flip a sign, drop a line.

How to convert a bank statement to CSV

  1. 1

    Drop the PDF statement

    Download it from online banking first. Checking, savings and credit card statements all work; password-protected PDFs too.

  2. 2

    Check the balance

    Every transaction is listed with the result of the balance check. Fix anything that’s off right in the table.

  3. 3

    Download CSV

    Pick the date format you need in Export settings. Any other format is one click away too.

CSV for QuickBooks Online and Xero

QuickBooks Online’s Upload transactions screen accepts a CSV with Date, Description and Amount (3 columns) or Date, Description, Credit and Debit (4 columns). Pick “CSV for QuickBooks” to get the 3-column layout. Xero’s bank statement import takes CSV files too.

Dates and amounts the way importers want them

Pick MM/DD/YYYY, DD/MM/YYYY or YYYY-MM-DD before you download. Amounts are written as plain numbers (-4.50, 2500.00) with no currency signs or thousands separators, which is what import screens expect.

The formats

PDF statement
The statement your bank lets you download from online banking. It looks like a table but is really text placed at positions on a page, which is why copying it into a spreadsheet goes wrong. Scanned paper statements are pictures of text and need OCR, which BankToRows doesn’t do yet.
CSV
Comma-separated values: a plain-text table that every bank, spreadsheet and accounting app can read. Banks’ CSVs differ in column names, date order and whether money out is negative or in its own column.

Related converters

Bank statement converterBank statement to ExcelPDF statement to QBOPDF statement to QIFQBO to CSVIIF to CSV

Bank Statement to CSV: FAQ

Can I open the CSV in Google Sheets?

Yes: File › Import › Upload in Google Sheets. It opens in Excel, Numbers and LibreOffice too. If you want formatting and real dates without an import step, download Excel instead.

What does the balance check mean?

Statements print an opening balance, a closing balance and often a running balance. After reading the transactions, the converter adds them up and compares: opening + money in − money out must equal closing, and each printed running balance must follow from the one before. A green check means everything adds up to the cent; anything else is shown with the rows to look at. It’s a check of the totals, not a guarantee: two mistakes that cancel out (a missed +100 and a missed −100) still add up, which is less likely when the statement prints a running balance on every line.

Is my file uploaded anywhere?

No. The conversion runs in your browser: the file is read on your device and the download is built there too. It never reaches our server, so we can’t see it, keep it or lose it.

Is it free?

Yes, while BankToRows is in beta: no sign-up and no page limits.

Last updated October 2026