How to get bank statement transactions into Google Sheets

Updated October 26, 2026

Google Sheets can't read a PDF bank statement directly. The quickest route is to convert the PDF's transaction table into rows first, then paste or import them. Below are the steps, plus two common reasons people do this: monthly bookkeeping and pulling together numbers for a loan or mortgage application.

Option 1: Copy and paste (fastest)

Open statementtosheet.app and drop your PDF statement on the page (digital PDFs from online banking; scanned images aren't supported yet).
Check the transaction count and the balance check.
Click Copy to clipboard.
In Google Sheets, click cell A1 and paste (Ctrl+V, or ⌘V on a Mac). The rows land in separate columns: Date, Description, Amount, Balance.

Sheets usually recognizes the YYYY-MM-DD dates and the amounts as numbers automatically. If a column comes in as text, select it and choose Format → Number.

Option 2: Import a CSV or Excel file

Convert the statement and click Download CSV (or Download Excel).
In Google Sheets, open File → Import → Upload and choose the file.
Pick Insert new sheet(s) to keep each month separate, or Append to current sheet to build a running ledger.

Importing is handy when you add a new month's statement to the same spreadsheet every month.

Private by design: the PDF is read in your browser and isn't uploaded to our servers. Only the rows you choose to paste or import end up in your Google account. Convert a statement →

For bookkeeping

Tick Separate Debit/Credit columns before copying if your bookkeeper or accounting import template expects two amount columns.
Add a Category column (for example Supplies, Rent, Owner draw) and use Insert → Pivot table to total each category by month.
Monthly totals: with dates in column A and amounts in column C, =SUMIFS(C:C, A:A, ">="&DATE(2026,9,1), A:A, "<"&DATE(2026,10,1)) totals September.
Keep the original PDFs too. The spreadsheet is a working copy; the bank's statement is the record.

For a loan or mortgage application

Lenders normally ask for the original statement PDFs, so send those, not the spreadsheet. A spreadsheet is still useful for preparing yourself before you apply:

Total deposits per month: =SUMIF(C:C,">0") on each month's sheet shows your monthly inflows at a glance.
Find large deposits: add a filter (Data → Create a filter) and sort Amount from largest to smallest. Underwriters often ask about deposits that aren't regular paychecks, so it helps to know which ones you'll need to explain or document.
Spot recurring payments: sort by Description to group subscriptions, loan payments and transfers.
Check balances: the Balance column (when your statement prints one) shows the lowest balance in the period.

If something looks off

If the balance check shows a mismatch, compare the totals with the PDF before relying on the numbers.
If no transactions are found, the PDF is probably a scan; download it again from online banking.
Password-protected PDFs are fine: you'll be asked for the password, and it's only used in your browser.

Working in Excel instead? See how to convert a bank statement PDF to Excel.

Convert a bank statement PDF