How to get a bank statement PDF into Google Sheets (checked to the balance)

Google Sheets can't open a PDF. Its File → Import takes spreadsheet and text files (.xlsx, .xls, .ods, .csv, .tsv, .txt), so a bank statement has to become one of those first. The quickest way: convert the PDF to a CSV that's already checked against the statement's beginning and ending balance, then import that CSV into Sheets. Below: the import settings that keep dates and amounts as real numbers, a formula that proves the sheet still balances, how to stack several months without duplicates, and what changes for credit card statements and scans.

1. Why Sheets can't read the PDF

Google's help page for importing into Sheets lists the file types it accepts, and PDF isn't one of them. The other Google route people try is Google Drive's Open with Google Docs, which runs text recognition on a PDF. That gives you a document, not a sheet: Google's own help says tables and columns are not likely to be detected, and it asks for files of 2 MB or smaller. A statement's columns come out as lines of text that you'd still have to split, line up and add up by hand.

Copying the text out of the PDF and pasting it into Sheets has the same problem. Each row usually lands in one cell, long descriptions wrap onto a second line, and the debits and credits columns lose their sign, so nothing tells you whether a row went missing on the way.

2. Check your bank's own download first

Most online banking lets you download recent activity as a CSV, and that file imports into Sheets directly. It's the right choice when it covers the dates you need. A converter is for the cases it doesn't cover:

3. Convert and import, step by step

1. Upload the PDF on the bank statement to CSV page. The free preview shows the first 5 rows and Balanced ✓ (beginning balance plus every row equals the ending balance) or Off by an exact amount, before you pay anything.
2. Download the CSV / Excel file. Its columns are Date (written YYYY-MM-DD), Description, Amount (negative for money out) and Balance where the statement prints one. One credit covers the whole statement.
3. In Google Sheets, open a new or existing spreadsheet and choose File → Import, then the Upload tab, and drop the CSV in. (Uploading the CSV to Google Drive and opening it with Google Sheets works too and creates a new spreadsheet.)
4. Pick where it goes. Create new spreadsheet or Insert new sheet(s) for a first month; Append rows to current sheet to add the next month under the last one (see several months).
5. Separator: choose Comma (automatic detection also works on these files). Leave the option to convert text to numbers and dates ticked so the amounts add up, then click Import.
6. Freeze the header row (View → Freeze → 1 row) and format column C as a number with 2 decimal places if Sheets shows fewer.

4. Check the sheet still balances

The converter has already checked the rows against the statement, but a quick formula in Sheets proves nothing was lost when you imported, sorted or deleted rows later. Put the statement's beginning and ending balance in two spare cells, for example F1 and F2, then:

F3 should be 0. Anything else is the amount of a missing, doubled or edited row; the Balance column helps you find where, because each row's balance should equal the row above plus its own amount. In row 3: =ROUND(D2+C3-D3,2), filled down, shows 0 on every good row. Money in and money out also let you tick the statement's own deposit and withdrawal totals, which most banks print on page 1.

5. When amounts or dates come in as text

If the amounts sit on the left of their cells, SUM returns 0, or dates don't sort, Sheets read them as text. The usual causes:

• The spreadsheet's locale. Google says a spreadsheet's locale sets its date and number formatting. In a locale that writes decimals with a comma (much of Europe and Latin America), an amount like -6420.18 may not be read as a number. Change it under File → Settings → Locale, or import into a spreadsheet set to a locale that uses a decimal point. Our CSV writes dates year first (2026-09-01), which avoids the day/month swap that 09/01 can cause.
• Conversion was switched off during import. Re-import with the option to convert text to numbers and dates ticked.
• A bank CSV with currency symbols or parentheses, such as $1,234.56 or (85.00). Converting the PDF sidesteps it, because the CSV has plain signed numbers; for a bank file, the CSV converters read those layouts.

Keeping the data intact matters more than the look of the sheet: a date stored as text sorts as text, and an amount stored as text silently drops out of every total.

6. Several months or accounts in one sheet

1. Convert each statement separately. Each one gets its own balance check, so you know every month is complete before you combine them.
2. Import the first month, then for each next month use File → Import → Append rows to current sheet. Delete the extra header row each import adds, or sort it away.
3. Add a Month or Account column if you'll filter or pivot later (Insert → Pivot table, rows by month, values SUM of Amount).
4. Check for duplicates when statement periods overlap or a month was imported twice. In a spare column, =COUNTIFS(A:A,A2,B:B,B2,C:C,C2)>1 filled down marks TRUE on rows that have an identical twin. Two identical card purchases on the same day can be real, so compare with the statement before deleting.

A statement with checking and savings on it comes out as one CSV per account, each balanced on its own, plus a single all accounts CSV with an Account column if you'd rather keep everything in one sheet.

7. Credit card statements

The same converter reads credit card statements, checked against the previous and new balance. In the CSV, charges, fees and interest are negative and payments and credits are positive, so money out of your pocket is always negative across bank and card sheets. Card statements don't print a running balance, so the Balance column is empty. The check formula becomes: previous balance owed minus the sum of the amounts equals the new balance owed. On the fictional sample card statement, 2,846.12 − (−397.76) = 3,243.88. The credit card statement to Excel guide covers the card layouts, and everything in it applies to Sheets once the CSV is imported.

8. Other ways, and where they stop

• Bank-feed services for Sheets. Google Sheets has no built-in bank connection. Paid services such as Tiller connect bank accounts and add new transactions to a sheet. They're good for ongoing tracking, but they start from when you connect and from what the bank's connection shares, so past statements and closed accounts still need the PDFs.
• Excel's Get Data → From PDF (Microsoft 365 on Windows) imports tables from a text PDF, which you could then save as .xlsx and import into Sheets. Expect clean-up and do the balance check yourself; see the DIY section of bank statement PDF to Excel.
• Typing it in. For a statement with a handful of rows, the free bank statement Excel template imports into Sheets (File → Import accepts .xlsx) with its formulas working, and has a blank statement sheet to type into.
• Reconciling against your books. If the goal is matching the statement to a QuickBooks or Xero export rather than keeping a sheet, the bank reconciliation checker does the matching directly, or use the bank reconciliation template in Sheets.

Sources, checked November 5, 2026: Google Docs Editors Help, Import data sets & spreadsheets and Set a spreadsheet's location & calculation settings; Google Drive Help, Convert PDF and photo files to text. Sample statements are fictional.

FAQ

Related guides

• Free sample bank statement CSV (fictional, with known totals)
• Convert a scanned bank statement PDF to Excel (OCR, checked to the balance)
• How to convert a credit card statement PDF to Excel
• Free sample bank statement in Excel (with a blank template)
• Free bank reconciliation template for Excel (with a worked example)
• Catch-up bookkeeping: getting 12 months of bank statements into QuickBooks or Xero and reconciled

Related tools

• Bank reconciliation checker: compare a bank statement to your books and list missing, duplicate and mismatched transactions.
• Receipt to CSV: turn PDF or photo receipts and invoices into CSV, Excel, or QuickBooks and Xero bill imports.