PDF to CSV: convert a bank statement, every row checked
Drop a PDF bank or credit card statement and get a CSV with one row per transaction, dates and amounts that every spreadsheet reads, and a check column that says which rows the printed balances confirm.
Updated Oct 21, 2026 · 6 min read
The short answer: drop the statement PDF in the converter below, look at any row it flags, and choose CSV on the result. Pick the comma or semicolon version to match your spreadsheet. Every row has been checked against the balances the bank printed before you download, and the file says so in its last column.
Convert a bank statement PDF to CSV
Drop a bank or credit card statement, in any language, digital or scanned. Sheetfold reads every row and checks it against the balances your bank printed; CSV and Excel are one click away. 5 free pages a day with an account.
What the CSV looks like
One header row, then one row per transaction, in the order the statement prints them. This is the real file Sheetfold writes for three rows of an example statement:
| Date | Description | Amount | Balance |
|---|---|---|---|
| Beginning balance | 4,210.00 | ||
| Oct 14, 2026 | Oct 14, 2026RENT OCTOBER | −1,450.00 | 2,760.00 |
| Oct 15, 2026 | Oct 15, 2026ACME CORP PAYMENT | +3,200.00 | 5,960.00 |
| Oct 20, 2026 | Oct 20, 2026OFFICE DEPOT #1123 | −312.40 | 5,647.60 |
| Ending balance | 5,647.60 |
- One header row: money out and money in in their own columns, a signed Amount for software that wants one column, then the balance, the page each row came from and the check.
- Dates as year-month-day, which Excel and Google Sheets read the same way in every country, and amounts without thousands separators or currency signs, so they arrive as numbers. Proven means the balances printed on the statement confirm the row.
Two details that save a cleanup later: a description that starts with = or + gets an apostrophe in front, so a spreadsheet shows it as text instead of running it as a formula; and the semicolon version writes decimal commas (1450,00), so Excel in most of Europe splits it into columns on open.
Open it in Excel
Double-click the file. Excel opens it in columns with the dates as real dates. If everything lands in column A, your Excel expects the other separator: download the semicolon CSV instead (or the comma one), or use Data, From Text/CSV and pick the delimiter. For formatted columns and a second sheet with the reconciliation, download Excel instead of CSV: the same rows, ready to use.
Import it into Google Sheets
- In Google Sheets, choose File, Import, and upload the CSV.
- Choose where it goes: a new spreadsheet, new sheets in this one, or appended to the current sheet (handy for adding one month after another).
- Leave the separator on Detect automatically, then import.
Google Sheets reads dates and numbers by the spreadsheet’s locale (File, Settings, Locale). Year-month-day dates and plain decimal amounts read correctly whatever the locale is.
For accounting software, a CSV is not always the best file
Accounting programs take CSV, but each wants its own columns, and some import a CSV without checking which rows they already have. A statement file in the program’s own format is usually simpler, and Sheetfold exports those from the same result:
- QuickBooks: Online accepts a CSV with Date, Description and Amount, but a .qbo file needs no mapping and also works in Desktop. See PDF to QBO.
- Quicken: use a .qfx file; Quicken for Windows never matches CSV rows, so a second import duplicates them. See QFX file.
- Xero, Sage, FreeAgent, YNAB, GnuCash: an .ofx file. See OFX file.
Why not download the CSV from the bank?
If your online banking offers a CSV download for the months you need, use it: it comes straight from the bank. The PDF is the way when:
- The months are too old. Downloads usually reach back a year or two; statements go back further, as PDFs.
- Someone sent you PDFs. A client, a lender or an auditor rarely sends anything else.
- You need the statement as issued. A download can include pending transactions, usually carries no opening or closing balance, and has no page to point to when a question comes up.
- Every bank’s CSV is different. Column names, date formats and signs change from bank to bank; converted statements all come out in one layout.
Check any statement CSV in one formula
Whatever made the CSV, the statement’s running balance can check it. With the signed amount in column E and the balance in column F, put this in G3 and fill it down:
=ROUND(F3-F2-E3, 2)
Every row should show 0: the balance moved by exactly the row’s amount. Anything else marks a misread amount, a wrong sign or a missing row just above it. Sheetfold runs this check (and the statement’s printed totals) on every row before you download, so its Check column already tells you which rows are proven.
Sources, checked 21 October 2026: Google Sheets: import data sets, Google Sheets: locale and time zone, QuickBooks Online uploads, Quicken CSV import.
Questions
- How do I convert a PDF bank statement to CSV?
- Drop the PDF into a bank statement converter such as Sheetfold, look at any row it flags, and download CSV. If your bank offers a CSV download for the same period, that works too, but it usually reaches back only a limited time.
- Is there a free bank statement to CSV converter?
- Sheetfold converts 5 pages a day free with an account and 1 without one, with CSV, Excel and accounting files included.
- Comma or semicolon CSV?
- Comma, if your spreadsheet writes 1,234.56. Semicolon, if it writes 1.234,56 (most of Europe): that file uses decimal commas too, so Excel opens it straight into columns.
- Can I import the CSV into QuickBooks or Xero?
- QuickBooks Online accepts a CSV with Date, Description and Amount columns. Most accounting software also takes an OFX file, which needs no column mapping; Sheetfold exports QBO for QuickBooks, QFX for Quicken and OFX for the rest.
- Why do my CSV dates look wrong in Excel?
- Excel reads dates by your computer’s regional setting, so 03/04 can become April 3 or March 4. Sheetfold writes dates as year-month-day (2026-10-14), which reads the same way everywhere.
Try it on your own statement
Drop a PDF here and Sheetfold reads it, then checks every row against the balances your bank printed. A free account converts 5 pages a day.
Keep reading
All guides- How to convert a bank statement PDF to Excel Four ways to get a bank statement PDF into Excel, free and paid, what each one gets wrong, and a one-formula check that every number came through.
- PDF to QBO: convert a bank statement PDF for QuickBooks Convert a PDF bank or credit card statement to a .qbo file for QuickBooks Online or Desktop, with every row checked against the printed balances.