Google Sheets is happy to hold your bank data once it arrives. Getting it there is the problem. You cannot open a PDF in Sheets, drag one into a tab, or point a formula at it and expect rows to appear. People try a few tricks that feel like they should work, waste twenty minutes, and end up retyping numbers off a screen. There is a clean path, and it hinges on one fact: Sheets imports CSV files, not PDFs. So the real task is turning the statement into a CSV first.
Why the obvious methods fail
The first thing most people try is a copy and paste. You open the PDF, highlight the transaction table, and paste it into a Google Sheet. What lands is a mess. Dates fuse with descriptions, the amount column collapses into the text, and a single transaction spreads across three rows. PDFs store text as positioned fragments, not as a real table, so the grid you see on screen does not survive the paste. We wrote a longer breakdown of exactly why this happens in why copy-paste from a PDF bank statement breaks, and everything in it applies to Sheets too.
The second attempt is usually a formula. IMPORTDATA looks promising because it pulls a CSV or TSV straight from a URL. But it needs a public link to an actual CSV file. A bank statement PDF sitting on your desktop is neither a URL nor a CSV, so the function has nothing to chew on. IMPORTHTML and IMPORTXML have the same problem: they read web pages, not local PDFs. None of the built-in import functions can parse a statement.
There is no Sheets add-on that reliably reads an arbitrary bank PDF either. Some scripts promise it, but they either upload your statement to a third-party service or choke on any layout they were not trained for. Which brings us to the part that actually matters.
Convert to CSV first, then import
The dependable route is two moves. Turn the PDF into a CSV, then let Sheets import that CSV. A converter that reads the PDF's layout does the hard part, lining up the columns the way copy-paste never can.
ConvertFin does this in the browser. You drop in a PDF statement and it gives you back a file with four columns: Date, Description, Amount, and Balance. Card statements often have no running balance, so that column comes back empty, which is normal and nothing to fix. It reads the layout rather than a fixed per-bank template, so Chase, Bank of America, Wells Fargo, Capital One, Citi, Amex, US Bank, and PNC statements all come out in the same shape.
The detail worth pausing on is where the parsing happens. The whole thing runs client-side using pdf.js, which means the PDF is read inside your own browser tab. The file never gets uploaded to a server before it lands in your Drive. For a document that lists every place you spent money last month, that is the difference between keeping the data yours and handing it to a company you have never met. If you want the technical version of that claim, the security page spells out what does and does not leave your machine.
You can convert a statement for free without an account. The free tier covers five conversions a day, tracked locally, which is plenty for a personal budget or a couple of months of cleanup. If you are processing statements in bulk, nothing lifts that limit yet — there is no paid plan, and files go through one at a time.
Importing the CSV into Google Sheets
Once you have the CSV, Sheets takes it without complaint. You have two ways in.
The direct way: open the sheet you want the data in, go to File > Import, choose Upload, and drag the CSV over. In the dialog, set Import location to whatever fits. "Insert new sheet(s)" keeps the data on its own tab, "Replace current sheet" wipes what is there, and "Append to current sheet" adds the rows under whatever you already have, which is how you stack several months into one register. Leave the separator on "Detect automatically" unless your numbers look wrong, and click Import data.
The other way is to drop the CSV into Google Drive first, then double-click it and pick Open with > Google Sheets. That spins up a fresh spreadsheet from the file. Use this when the CSV is a standalone thing you did not already have a home for.
A few things to check once the rows land:
- Dates reading as text. If a column of dates sits left-aligned and won't sort, Sheets parsed it as text. Select the column, then Format > Number > Date. If it still won't convert, your locale's date order (under File > Settings) probably disagrees with the file, so switch it to match and re-import.
- Amounts stuck as text. Numbers that hug the left edge and refuse to sum usually carry a stray currency symbol or a thousands separator. A clean CSV avoids this, but if it slips through, run Format > Number on the column.
- A blank Balance column. Expected on credit card statements. Delete the column if you don't want it, or leave it.
The one real limitation
This approach only works on PDFs that contain selectable text. Open your statement and try to highlight a transaction with your cursor. If the text highlights, a converter can read it. If nothing selects because the page is really an image, the statement is a scan or a photo, and there is no text under the pixels to extract.
ConvertFin does not run OCR, so it will not read a scanned statement. That is a deliberate line, not an oversight, because guessing characters off a blurry scan is exactly how a 7 becomes a 1 in your ledger without you noticing. If you are stuck with a scan, the cleaner fix is to log into online banking and download a fresh PDF, which is almost always a real text document rather than an image. Failing that, you would need a dedicated OCR tool and a careful eye on every number it produces.
Putting it together
The whole flow, once you have done it once, takes a couple of minutes per statement. Convert the PDF to a CSV, open Sheets, go to File > Import, and check that dates and amounts came in as numbers rather than text. From there the data behaves like anything else in a spreadsheet: sort it, run a SUMIF by category, drop it into a pivot table, or feed it into a budget you already keep.
The reason to bother with the conversion step instead of muscling through a copy-paste is that a clean starting file saves every minute you would otherwise spend untangling merged columns. Start with a proper CSV and Sheets does the rest without a fight. When you are ready, convert your statement and import it, and the numbers that took an afternoon to retype will land in about the time it takes to read this sentence.