Convert bank statement PDF to Google Sheets

Google Sheets is strict about types when you import. If a date column lands as text instead of a date, your filter views break and QUERY() refuses to group by month. We write the file so Sheets imports it correctly the first time.

Drag the downloaded file into Drive, right-click → Open with → Google Sheets. Sheets converts it into a native spreadsheet in place. No "tap here to convert format" nag, no column-type dialog, no lost formatting. The Transactions tab is the whole file — we don't ship extra sheets you'd need to delete.

If you prefer a single-step import, use File → Import → Upload from within a blank Google Sheet. Same result, one less Drive step.

Bank statement PDFs contain your full name, account number, statement address, and sometimes a routing or sort code in the header. Every time you email that PDF around, another inbox has a copy.

The converted Google Sheet only contains the four columns: date, description, amount, balance. Nothing about identity, nothing about account numbers. That's a meaningful privacy upgrade for routine workflows — sharing monthly numbers with your accountant, showing a partner last month's expenses, reviewing business spend with a co-founder.

Sharing controls are yours once the file is in Drive: view-only, comment, or edit, link-restricted or domain-restricted, time-limited expiry on Workspace plans. We don't touch any of that.

A few QUERY examples worth trying on a converted statement. Assume transactions land in A2:D100.

Top 10 merchants by total outflow:

=QUERY(A2:D, "SELECT B, SUM(C) WHERE C < 0 GROUP BY B ORDER BY SUM(C) LIMIT 10")

This month's spend only:

=QUERY(A2:D, "SELECT * WHERE A >= date '2026-04-01' AND A < date '2026-05-01'")

Running total of debits:

=SUMIF(C2:C, "<0")

None of these need helper columns or a pivot table. Write the formula, press enter, see the result. Update the raw data and the query refreshes automatically. Excel users move to Sheets for this one feature more often than any other.

A dedicated parser knows where a specific bank places value dates, how it wraps long merchant names, and whether it splits withdrawals and deposits across columns. For Google Sheets output that matters because bad row detection creates gaps that break QUERY() and filter views.

When your bank has its own page under /convert/[bank]-to-google-sheets, we've already tuned for those quirks. If it doesn't, the generic parser takes a first-page read, infers the column layout, and applies it across the file. When extraction fails, you see a "we couldn't read this" message and the free credit isn't used.

Three high-traffic bank converters:

The preview is ungated. You see exactly what the Sheet will look like before you pay — if the extraction is wrong, don't buy.

The paid options:

• Pay-per-document — $2.99. One statement, one sheet, no subscription.
• Starter — $29/month, 500 pages. Single file at a time. Fits a freelancer or small business tracking personal + business accounts.
• Professional — $49/month, 1,000 pages. Batch upload. For solo accountants and bookkeepers handling a handful of clients.
• Business — $79/month, 5,000 pages. Batch upload + API. For firms.

If you're reading this with Google Workspace in mind, Starter or Professional is usually the right fit. API access on Business opens up direct writes into a Sheet from Apps Script — useful if you're building a client dashboard. Full tier detail: pricing.

The Sheets-native pattern for multi-month work is a master sheet that pulls from monthly files with IMPORTRANGE.

Setup:

1. Create a folder in Drive called something like Finances / 2026 / Statements.
2. Convert each month and drop the Sheet into that folder.
3. In a new master sheet, write one IMPORTRANGE per month. Example for March:

   =IMPORTRANGE("https://docs.google.com/.../edit", "Transactions!A2:D")

4. Stack them below each other, or use =QUERY({March; April; May}, ...) to analyze across months in a single formula.

When April's statement lands, the same IMPORTRANGE pulls it in on refresh. No copy-paste, no version mismatch. If you run this for clients, the bookkeepers use case has the folder-per-client version of the pattern.

BankConv holds the file for 24 hours by default. Signed-in users can bump that to 72 hours per file in account settings — useful when you want to re-download the same Sheet to a different Drive or share it with someone who hasn't grabbed it yet.

After the retention window the file is deleted from our storage and not recoverable on our side. Once the Sheet is in your Drive, the retention question is Google's to answer, not ours. For the full policy — encryption at rest, sub-processors, EU region — the security and compliance page carries the detail your compliance reviewer will want.

We don't train models on your data, don't share with third parties, and don't index file contents.