Google Sheets is free, it runs in a browser, and it is where a lot of people would happily keep their transactions if only they could get them out of the PDF. The catch is that Sheets cannot read a PDF table on its own. The reliable path is to convert the statement to CSV first, then open that in Sheets. This guide shows the fastest way to do it, and how to keep your amounts as real numbers.
I maintain the converter behind this site, so this is the route I would point a friend to.
Why you cannot open a PDF statement in Sheets directly#
Google Sheets opens spreadsheets: CSV, XLSX, and its own format. A bank statement PDF is none of those. It is a page layout, so even though it looks like a neat table, there is no column structure inside the file for Sheets to read. Drag a statement PDF into Drive and Sheets will not turn it into rows.
So the move is to convert the PDF to CSV, which is a format Sheets understands, and then bring that in.
Step one: convert the statement to CSV#
- Upload your PDF bank statement to the converter.
- Check the parsed rows, especially the dates and the amount column.
- Download the CSV.
Convert your statement to CSV
Turn the PDF into a clean CSV you can open straight in Google Sheets.
Step two: get the CSV into Google Sheets#
There are two ways, and one is cleaner than the other.
Import into a sheet (recommended). This keeps the most control over how the numbers come in.
- Open a new Google Sheet.
- Go to File, then Import, then Upload, and pick your CSV.
- In the import dialog, choose Insert new sheet (or replace the current one).
- Leave the separator on Detect automatically, unless your amounts use a comma as the decimal mark, in which case set it manually so the columns split correctly.
- Click Import data.
Open from Drive (quicker, less control). Upload the CSV to Google Drive and double-click it, then choose Open with Google Sheets. This is faster but gives you no say over how values are parsed, so it is more likely to misread amounts.
Keep amounts as numbers
After importing, click the amount column and check it is right-aligned, which means Sheets read it as numbers. If it is left-aligned, the values came in as text. That usually happens when the file kept currency symbols or thousands separators. Strip those, or re-import with the right locale under File, then Settings, then the locale dropdown.
Tidy it into something useful#
Once the data is in, a few minutes of cleanup turns a raw export into a working sheet:
- Freeze the top row so your headers stay visible while you scroll.
- Add a quick total under the amount column with
=SUM(...). - Filter by description to see everything from one payee.
- Add a category column if you are tracking spending, and use it to build a quick pivot table.
That is the whole point of getting out of the PDF: the moment the data is in real cells, all of this is one formula away.
A note on accuracy#
Before you build anything on top of the numbers, do one sanity check. If your statement prints a running balance, the last balance in your sheet should match the closing balance on the statement. If it does, the import is sound. The converter reconciles this for you during the conversion and flags anything that does not add up, so most of the time the check just confirms what you already know.
Where to go next#
Converting to a Google Sheet is the simplest case there is: make a CSV, import it, done. Start with the PDF to CSV converter. If you would rather have a desktop file, the PDF to Excel converter gives you an .xlsx instead, and the full conversion guide covers the trickier statements.
Heading into accounting software next? See the guides for QuickBooks and Tally.