How to get a bank statement PDF into Google Sheets
Google Sheets cannot open a PDF as a spreadsheet. The add-ons built for this usually send the PDF to their own service to read it, so check an add-on's privacy policy before you give it a statement. There is a simpler route: convert the PDF to a CSV file on your own computer, then import the CSV, which Sheets reads directly.
Step 1: convert the statement to CSV
- Open the StatementLocal converter and drop the statement PDF on the page. The file is read inside your browser and is never uploaded.
- Check the verdict. Reconciled means the rows add up to the statement's printed balances. Fix any Off by rows in the grid before you download.
- Click Download CSV. The file has four columns: Date, Description, Amount and Balance.
Step 2: import the CSV into Google Sheets
- Open Google Sheets and create a blank spreadsheet, or open the one you keep your transactions in.
- Choose File, then Import, then Upload, and pick the CSV.
- For the import location, pick Create new spreadsheet for a first import, Insert new sheet(s) to keep each month on its own tab, or Append to current sheet to add a month below the last one.
- Leave Convert text to numbers, dates, and formulas ticked, so amounts arrive as numbers you can add up.
- Click Import data.
Google moves its menus from time to time; its own help page on importing data into Sheets is the final word.
Step 3: check it arrived intact
- Click an amount. Numbers sit at the right of the cell by default; an amount at the left came in as text. Select the column and choose Format, Number, Number.
- Sort by the Date column. If the dates sort oddly, select the column and choose Format, Number, Date.
- Add up the Amount column with
=SUM(C2:C). That total, added to the statement's printed opening balance, should give its printed closing balance.
A worked example
You keep a household sheet with one tab per month. In October you convert the September checking statement, and it shows Reconciled with 31 rows. You import the CSV with Insert new sheet(s), rename the new tab Sep, and in an empty cell enter =SUM(C2:C32). The result is -418.30. The statement printed an opening balance of $3,204.55, and $3,204.55 less $418.30 is $2,786.25, its printed closing balance. The tab is ready to sort, filter or chart.
To total spending by category, add a Category column with a keyword table, as in categorizing bank transactions.
Limits of this method
- Importing into Sheets stores the transactions in your Google account. The PDF, with your address and account number, stays on your computer; the CSV holds only the transaction rows.
- StatementLocal converts one statement per file, so a year is twelve CSVs. Append them to one tab, or keep one tab per month.
- StatementLocal reads text-based PDFs only (no scans, photos or password-protected files), in US dollars and common US layouts.
- The balance check proves amounts, not words. A Reconciled statement can still have a misread date or description.
Try it on one of your statements
Open the StatementLocal converter and drop one statement PDF on the page. Converting and previewing are always free, and you can download 3 statements a day free, as CSV, Excel or QuickBooks CSV. The file is read inside your browser and is never uploaded.
What has and has not been tested
We tested StatementLocal on 200 synthetic (made-up) statements across 10 common US statement layouts, built by our own generator. Every statement it could not verify was flagged with Off by or Cannot check, never shown as Reconciled. We have not tested it on every bank's real statements, and we quote no accuracy figure for them.
Related guides
- Categorize bank transactions in a spreadsheet
- Organize a year of statements for taxes
- Combine several months into one sheet
- Convert a statement to CSV without uploading it
StatementLocal is not affiliated with any bank, card issuer or software company named on this page. Names are used only to say what the steps are for.
Need more than 3 statements a day? Buy the 30-day pass for $9 or Buy Lifetime for $39. One-time payments, taken by Stripe. Sold to US customers only.
Use Chrome? The same converter is also a Chrome extension: Add to Chrome from the Chrome Web Store.