How to Import a Bank Statement Into Google Sheets (2026)

Last updated July 2026.

To import a bank statement into Google Sheets, first convert the statement PDF to a CSV file, then in Sheets choose File, Import, Upload, select the CSV, and pick Replace current sheet or Insert new sheet. Google Sheets cannot read a PDF directly, so the conversion step is what makes the import work. Once the file is a CSV, the transactions land in real columns with date, description, amount, and running balance, ready to total and reconcile.

Why you cannot just open the PDF in Sheets

Google Sheets has no native PDF import. Its File, Import menu accepts CSV, XLSX, ODS, TSV, and TXT, and that is the whole list. A PDF is not on it. The reason is structural: a PDF places text by coordinates on a page, mixed in with the bank logo, the address block, and page headers, and there is no underlying table for a spreadsheet to read. Paste a page straight from a PDF and the date, description, and amount all collapse into one column, because Sheets has nothing telling it where one field ends and the next begins. So the job is really two smaller jobs: turn the statement into a clean CSV, then import that CSV.

Step 1: Convert the statement PDF to CSV

Upload the statement to a bank statement to Google Sheets converter and download the result as CSV. A good conversion returns one row per transaction with the date, the full description, the amount, and the running balance each in its own column. Two things matter here. First, the amounts should come out as plain numbers, with no dollar signs, thousands commas, or parentheses, because those are what break totals later. Second, if your statement is a scan or a phone photo rather than a digital PDF, the tool needs OCR to read the image, since there is no selectable text to work with.

Step 2: Import the CSV into Google Sheets

Open the Sheet you want the data in, then go to File, then Import. Click Upload and choose your CSV. Sheets shows an import dialog with a few choices that decide where the data goes:

Leave the separator type on Detect automatically and Sheets will read the commas correctly. Click Import data and the transactions appear. That is the whole process for a downloaded file.

Using IMPORTDATA for a live link

If you would rather the Sheet update itself when the file changes, use the IMPORTDATA function instead of a manual upload. Host the converted CSV at a public URL, for example a file on Google Drive published to the web, then put =IMPORTDATA("your-csv-url") in a cell. Sheets pulls the rows in and refreshes them periodically. The one rule to remember: IMPORTDATA reads a CSV or TSV only, never a PDF. Pointing it at a statement PDF returns an error or a line of unreadable characters, which is the most common mistake people make trying this.

Fixing amounts that import as text

Sometimes a total comes back as zero even though the numbers look fine. That happens when Sheets is treating the amount column as text, usually because a cell still contains a dollar sign, a thousands comma, or a negative wrapped in parentheses like (84.20). To fix it, select the amount column, then use Data, Split text to columns, or Format, Number to force a numeric format. For parentheses negatives, use Find and replace to swap the opening parenthesis for a minus sign and delete the closing one. Converting the statement cleanly in step one avoids all of this, because the amounts arrive as plain numbers in the first place.

Building a running year in one tab

For a full year in a single sheet, import the first month with Replace current sheet, then import every later month with Append to current sheet, keeping the same column headers each time. When the tab has all twelve months, select the whole range and use Data, Sort range to put it in date order. You can also convert several statements at once and stack them before importing, which saves clicking through the dialog twelve times.

What to do after the data lands

Rows in a tab are the raw material, not the finished report. The usual next move is to group the spending, and you can categorize the transactions into income and expense buckets before you total anything. From there, a running cash-flow tab or a simple monthly summary follows naturally, and if you also track receipts and card spend, an automated expense capture tool keeps those alongside the statement data without manual entry. To confirm nothing dropped in the import, total the amount column and compare it to the closing balance on the statement, the same check you would do in a full bank reconciliation.

Google Sheets or Excel?

The conversion is identical, so the choice is only about where the data goes next. Pick Sheets when you want a ledger you can share with a partner or accountant, edit from a phone, or link live with IMPORTDATA. Pick Excel for heavy pivot tables, large multi-year workbooks, or macros. Since the converter outputs both CSV and XLSX from one upload, you are never locked in, and the PDF bank statement to Excel converter covers that path if you change your mind later.