Convert a PDF Bank Statement to Google Sheets

Why a PDF statement isn't data in Google Sheets

You can open a PDF next to Google Sheets, but you cannot work with it as data. Sheets needs rows and columns, and a PDF statement is a printed page, so there is nothing for it to sort, total, or chart. Copying and pasting from the PDF rarely helps either: the text runs together, amounts merge with descriptions, and dates land in the wrong cells. The reliable path is to convert the statement into a CSV first, where each transaction is a proper row with separate date, description, and amount fields. Then Google Sheets can import it cleanly and every spreadsheet tool, from a simple sum to a pivot table, works on it.

Importing the CSV with File, Import

Google Sheets has a built-in importer made for this. Open a spreadsheet, choose File, then Import, and upload your converted CSV. Sheets asks how to bring it in, and the settings that matter are the delimiter, a comma for a standard CSV, and how it reads the date format, so the dates land as real dates rather than text. You can import into a new sheet or replace the current one. If you prefer, dropping the CSV into Google Drive and opening it with Sheets does the same thing. Because a converted file has clean, separated columns, the import lands correctly without the cleanup a copy-paste would need.

Categorizing with data validation

Once the transactions are in, a category column turns a raw list into something you can analyze. The tidy way to build it is a dropdown: keep a small config sheet listing your categories, then select the category column and use Data, then Data validation, with the criteria set to list from a range pointing at that config sheet. Now each row gets a consistent category chosen from the list rather than free text, which keeps totals accurate later. It takes a couple of minutes to set up and pays off on every transaction you tag, and consistent categories are what make the analysis step meaningful.

Analyzing with pivot tables

With categorized rows, a pivot table is the payoff. Select the data, choose Insert, then Pivot table, and Sheets summarizes the whole statement without formulas: total spending per category, per month, or both at once. Put the pivot on its own tab as a small dashboard, group by category in the rows and by month in the columns, and you can see where the money went and compare periods side by side. Date filters let you narrow to a single month or roll several together, which is exactly the view a statement in PDF form can never give you.

Why a spreadsheet, and privacy

Google Sheets appeals when you want full control of the analysis without committing to accounting software: your own categories, your own formulas, your own layout. Getting a statement into that environment starts with the conversion. Because the statement holds real account activity, the file is processed to build the CSV and then deleted automatically, with nothing retained on a server afterward. The transactions live only in your own spreadsheet from then on, which keeps your financial data under your control rather than in a third-party tool.

Frequently Asked Questions