Citizens Bank Statement to Excel Converter
Turn a Citizens Bank PDF statement into a clean Excel, CSV, QuickBooks (.qbo) or OFX file — with every row checked against the running balance. Free, no signup, and unlike every other PDF converter, nothing is uploaded: it's read by your browser's own PDF engine, on your machine.
.pdf only — text-based statements, not scans
Where to get your Citizens Bank statement
Citizens Bank statements are downloaded from its online or mobile banking, generally under a statements or documents section, as a PDF. Citizens Financial Group, based in Providence, Rhode Island, spent decades as a subsidiary of the UK's Royal Bank of Scotland before going public in a 2014 IPO and fully separating a year later. Its commercial and treasury clients can be issued BAI2 cash-reporting files.
Prefer Citizens Bank's own export when you can get one
That BAI2 feed converts directly on BAI2 → Excel, with nothing to misread compared to a PDF. A Citizens personal account with a CSV export option belongs on CSV → QBO. For everything else — which covers most individual customers — the monthly PDF statement is what this page handles.
Citizens Bank is a trademark of Citizens Financial Group, Inc. This tool is independent and not affiliated with, endorsed by, or sponsored by Citizens Bank.
Nothing about your Citizens Bank statement is uploaded
Everything happens locally when you convert a Citizens Bank statement here — the browser's built-in PDF engine reads the file, and this page has no server or upload endpoint at all. Watching your browser's network tab during conversion will confirm it: no request carries the file anywhere. It also works with no internet connection once the page has loaded. See the privacy page for the complete policy.
How this tool reads a Citizens Bank PDF statement
There's no table structure in a statement PDF, only text placed at coordinates — so this tool clusters the fragments that share a line, orders them left to right, and treats that as a row. Repeated header and footer lines are filtered out, a wrapped-over description is stitched back onto its transaction, and parentheses, leading minus signs and trailing minus signs are all normalized to one signed Amount value. The trailing number on each line becomes the running balance used for the check below, not part of your transaction total.
Frequently asked questions
Does Citizens Bank offer BAI2 files for business accounts?
Commercial and treasury customers at Citizens can be issued BAI2-format cash files as part of their reporting, and converting one on BAI2 → Excel is more exact than rebuilding it from a PDF. Personal Citizens accounts generally don't have this option and are limited to the standard monthly PDF, which is what this page is for.
Is my Citizens Bank statement really not uploaded anywhere?
Correct, nowhere. The conversion runs entirely client-side, in the tab your Citizens Bank statement is opened in, with no server component backing this page. Your browser's own network tab will confirm it — watch it while converting and no request will carry the file out.
Why might some Citizens Bank transaction rows be missing or wrong?
Because this tool reads text position rather than following a fixed Citizens Bank template, unusual layouts can occasionally trip it up even though most statements come through fine. The preview table and balance-check panel are there for exactly this reason — check them before relying on a result, and confirm the source file is a text-based PDF, not a scanned image, if rows seem off.