Convert a bank statement PDF to Google Sheets
Banks hand you statements as PDFs, and every reconciliation, budget and tax return needs them as rows. PDF to Sheets reads the transaction table and puts each transaction on its own row, in the spreadsheet you already have open.
4.5 out of 5 on the Google Workspace Marketplace
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 03/01 | Opening balance | 8,412.60 | ||
| 03/02 | Northside Hardware | 184.25 | 8,228.35 | |
| 03/04 | Client payment 1047 | 2,300.00 | 10,528.35 | |
| 03/05 | City Water Utility | 96.40 | 10,431.95 | |
| 03/09 | Payroll | 3,150.00 | 7,281.95 | |
| 03/12 | Client payment 1052 | 1,875.00 | 9,156.95 |
The short answer
To convert a bank statement PDF to Google Sheets, open the PDF to Sheets add-on from the Extensions menu, upload the statement and choose Google Sheets as the output. Each transaction becomes a row with its date, description and amounts in separate columns. Check that the opening balance plus credits minus debits equals the closing balance before you rely on the data.
What comes out of a statement
The columns depend on how your bank prints its statements. These are the ones most statements carry.
| Column | What it holds | What to check |
|---|---|---|
| Date | The posting or transaction date for each line | Dates that lost their year. Many statements print only day and month. |
| Description | Payee, reference or memo text | Long descriptions that wrapped onto a second line in the PDF. |
| Debit and credit | Money out and money in, in one column or two | Whether withdrawals are shown as negatives or in their own column. |
| Balance | The running balance after each transaction | The last balance should match the closing balance printed on the statement. |
Why statements are harder than they look
Tables run across page breaks
A three-page statement is one table printed in three pieces, with the header repeated on each page. A multi-page conversion gives you one continuous list instead of three pasted fragments.
Every bank lays it out differently
Column order, date format and where the summary box sits all change from bank to bank. The converter detects the table on the page rather than expecting a fixed layout.
Paper statements arrive as scans
Older statements and anything a client mailed you are usually scanned images. OCR reads the text off the page before the rows are built.
Copy and paste scrambles the columns
Pasting from a PDF viewer drops everything into one column or one cell. Converting the table keeps amounts in the amount columns.
How to convert a bank statement to Google Sheets
Add PDF to Sheets to Google Sheets
Install it from the Google Workspace Marketplace. It takes one click and adds nothing to your computer.
Open it from the Extensions menu
In any spreadsheet, go to Extensions, choose PDF to Sheets and open the converter in the sidebar.
Upload your PDF and pick an output
Choose the file, then choose where the data should go: the current Google Sheet, an Excel file, CSV or XLS.
Convert and check the totals
The tables land as rows and columns. Compare one total against the PDF before you build on the data.
Checking a converted statement
A converted statement is only useful if it matches the PDF. Three checks take a minute and catch nearly every problem.
- Tie out the balance. Add a cell with opening balance plus the sum of credits minus the sum of debits. It should equal the closing balance printed on the statement.
- Count the rows. Many statements print the number of deposits and withdrawals in the summary box. Your row count should match.
- Look at the page joins. Scroll to where page one ended in the PDF and confirm no transaction was skipped or repeated at the break.
Getting it into accounting software
Most bookkeeping tools that accept bank uploads want a CSV with a date column, a description column and either one signed amount column or separate debit and credit columns. If your statement came out with two amount columns and the software wants one, add a column with =D2-C2 (credit minus debit) and export that.
Dates without a year
Statements often print 03/04 and leave the year to the header. Add the year in a helper column with =DATE(2026, LEFT(A2,2), RIGHT(A2,2)), adjusting for your date order, so sorting and monthly totals work.
- Marketplace rating
- 4.5
- Installs
- 60K+
- Free to try
- 5 pages
Reviews
4.5 out of 5
Bank statements: common questions
How do I convert a PDF bank statement to Google Sheets for free?
Install PDF to Sheets from the Google Workspace Marketplace and convert the statement from the Extensions menu. The first 5 pages are free, which covers a typical monthly statement.
Can I convert a scanned bank statement?
Yes. Scanned statements are read with OCR and then placed into rows and columns. A clear, straight scan at normal print size converts best, so rescan anything that is skewed or faint.
Can I export the statement to Excel or CSV instead?
Yes. Choose Excel (.xlsx), CSV or XLS as the output. CSV is the format most accounting software accepts for bank transaction uploads.
Does it work with credit card statements?
Yes. A credit card statement is the same kind of document, a table of dated transactions, and converts the same way.
Why do my amounts not add up after converting?
The usual cause is amounts stored as text, often because of a currency symbol or a trailing minus sign. Select the column and set Format > Number > Number, or strip the symbol with Find and replace. Then compare your total against the statement.
Can I combine statements from several banks in one sheet?
Yes. Convert each statement into its own tab, give the tabs the same column order, then stack them in a summary tab. Add a column for the account name before you combine them so you can still filter by bank.
Related converters
- Accountants and bookkeepersConvert client bank statements, invoices and financial reports from PDF to Google Sheets, Excel or CSV. Less retyping at month end and tax time.
- ProcurementConvert supplier quotes, price lists and purchase orders from PDF to Google Sheets, Excel or CSV and compare vendors side by side without retyping.
- Real estateConvert rent rolls, T12 operating statements and closing statements from PDF to Google Sheets, Excel or CSV so you can underwrite instead of retyping.
Stop retyping PDFs into spreadsheets
Add PDF to Sheets to Google Sheets and convert your first 5 pages free.