Home › Convert a bank statement PDF for Google Sheets

Convert a bank statement PDF for Google Sheets

Google Sheets cannot read statement PDFs, but it imports CSV perfectly. Convert the PDF to CSV here, then import it into Sheets.

Drag & drop statement PDFs hereor tap to choose files — multiple PDFs for batch mode

Privacy: uploaded files and generated exports are stored only briefly to complete your download and are automatically deleted within 15 minutes. Files are never used for any other purpose.

The two-step that works

Convert the statement PDF to CSV with the tool above, then in Google Sheets use File, then Import, then Upload, and choose the CSV. Each transaction lands on its own row with Date, Description, Amount, Debit, Credit and Balance in separate columns.

Why not paste from the PDF?

Pasting from a PDF merges columns and wraps descriptions across rows. The CSV route keeps the table structure, and the converter reconciles the transactions against the statement before export.

How it works, step by step

  1. Download your statement PDF. Sign in to your bank's online banking, open Statements or Documents, and download the period you need as a PDF.
  2. Upload it to the converter. Add the PDF (or several, for batch conversion) to the tool on this page.
  3. Check the reconciliation result. The converter verifies the transactions against the statement's balances and flags any row that does not tie.
  4. Download your file. Choose Excel, CSV, QuickBooks or Xero format and import it into your software.

These are the general steps most banks follow for statement downloads; exact menu labels vary by bank and change over time.

Questions and answers

Can I convert straight into a Google Sheet?

The converter produces the CSV file; importing it into Sheets takes under a minute with File > Import.

What does the reconciliation check do?

Where the statement prints opening and closing (or running) balances, the converter adds up the extracted transactions and compares the result with the statement itself. If the numbers do not tie, the conversion is flagged and the mismatched rows are marked — a failed check is never shown as a success.

Are my statement files kept?

No. Uploaded files and generated exports are stored only briefly to complete the download and are automatically deleted within 15 minutes.

Related reading from the blog

Excel, CSV & Google Sheets · November 4, 2026

How to Clean Up a Converted Bank CSV

Remove header blocks, page-title rows, subtotals, blank rows, and stray characters from a converted bank CSV so it imports cleanly the first time.

Excel, CSV & Google Sheets · November 3, 2026

Excel or CSV for Bookkeeping: Which Format Wins When

Excel workbooks and plain CSV each win in different bookkeeping jobs. Learn the formatting risks of workbook round-trips and when to use each.

Excel, CSV & Google Sheets · November 5, 2026

Date Formats in Bank Statement Files

Ambiguous date orders in statement files put transactions in the wrong month. Use one clear format per file and check the rows most at risk.

More on the StatementVerified blog.

Convert by bank

Chase statement converter · Bank of America statement converter · Wells Fargo statement converter · Citibank statement converter · Goldman Sachs Bank USA statement converter · Morgan Stanley Bank statement converter · U.S. Bank statement converter · Truist Bank statement converter · PNC Bank statement converter · TD Bank statement converter · Capital One statement converter · American Express statement converter · Fifth Third Bank statement converter · Citizens Bank statement converter · BMO Harris Bank statement converter · KeyBank statement converter · Bank of New York Mellon statement converter · State Street Bank statement converter · Northern Trust statement converter · Regions Bank statement converter · M&T Bank statement converter · Huntington Bank statement converter · Santander Bank statement converter · Comerica Bank statement converter · First Citizens Bank statement converter · Zions Bank statement converter · Flagstar Bank statement converter · Webster Bank statement converter · CIBC Bank USA statement converter · Popular Bank statement converter · East West Bank statement converter · Valley National Bank statement converter · Frost Bank statement converter · First Horizon Bank statement converter · Western Alliance Bank statement converter · Synovus Bank statement converter · Old National Bank statement converter · First National Bank of Pennsylvania statement converter · Bank of Oklahoma statement converter · EverBank statement converter · Raymond James Bank statement converter · SouthState Bank statement converter · United Community Bank statement converter · Simmons Bank statement converter · Hancock Whitney Bank statement converter · Prosperity Bank statement converter · MidFirst Bank statement converter · Arvest Bank statement converter · BancFirst statement converter · FirstBank statement converter · Umpqua Bank statement converter · WaFd Bank statement converter · Cathay Bank statement converter · Bank of Hawaii statement converter · First Hawaiian Bank statement converter · Texas Capital Bank statement converter · Independent Bank statement converter · Glacier Bank statement converter · Atlantic Union Bank statement converter · WSFS Bank statement converter

Convert by country

Statement converters for banks in Afghanistan · Albania · Australia · Austria · Bahrain · Bangladesh · Barbados · Bermuda · Bhutan · Brazil · Brunei · Canada · China · Colombia · All 68 countries

Bank statements in. Clean books out.

Your first conversion is free — no card, no sign-up — and every result is reconciled against the statement itself before you download it.

Convert a statement — free