Sheetfold

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.

or drop it here

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:

Example Bank · ••••6789 Example
DateDescriptionAmountBalance
Beginning balance4,210.00
Oct 14, 2026Oct 14, 2026RENT OCTOBER−1,450.002,760.00
Oct 15, 2026Oct 15, 2026ACME CORP PAYMENT+3,200.005,960.00
Oct 20, 2026Oct 20, 2026OFFICE DEPOT #1123−312.405,647.60
Ending balance5,647.60
becomes statement.csv
1Date,Description,Money out,Money in,Amount,Balance,Page,Check
22026-10-14,RENT OCTOBER,1450.00,,-1450.00,2760.00,1,Proven
2026-10-15,ACME CORP PAYMENT,,3200.00,3200.00,5960.00,1,Proven
2026-10-20,OFFICE DEPOT #1123,312.40,,-312.40,5647.60,1,Proven
  1. 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.
  2. 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.
An invented statement and the CSV made from it by the same code as a real download. The file also starts with an invisible byte order mark, so Excel keeps accented letters intact.

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

  1. In Google Sheets, choose File, Import, and upload the CSV.
  2. 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).
  3. 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.

or drop it here

All guides