Get any PDF bank statement into Google Sheets without retyping a line. Upload your statement and BankXLSX returns a clean CSV with date, description, debit, credit, and running balance columns that import into a Google Sheet in one step. Start free, no credit card.
Last updated June 2026
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Google Sheets cannot read a PDF directly, so the reliable path is to convert the statement to CSV first, then import it. Upload your PDF to BankXLSX and download a clean CSV with date, description, debit, credit, and running balance columns. In Google Sheets, open File, then Import, then the Upload tab, drop the CSV in, and pick Replace spreadsheet or Append to current sheet. The whole thing takes under a minute and works for digital PDFs, scanned statements, and phone photos from more than 90 US banks.
Google Sheets imports CSV and Excel files, not PDFs. A bank statement PDF locks every transaction inside a fixed page layout built for printing, so there is no clean way to pour it into a sheet. Here is what usually goes wrong.
File, then Import accepts CSV, XLSX, ODS, and TSV, but not PDF. Without converting first, there is no menu path that puts your statement into a sheet.
Paste a PDF table into Sheets and the date, description, and amount jam into a single cell per row, so you spend the afternoon using Split text to columns instead of working.
Numbers pulled from a PDF arrive with stray dollar signs and commas, so Sheets reads them as text and SUM returns zero until you scrub every cell.
Sheets often misreads a pasted date or treats it as plain text, which breaks sorting and any formula that depends on the transaction date.
Most online banking exports reach back only 90 days to about 18 months, so for older or closed periods the PDF statement is the only source you have.
A scanned or photographed statement has no copyable text at all, so there is nothing to paste and you are stuck retyping every line by hand.
Upload the PDF and the converter reads the transaction table directly, then writes a clean CSV (and an Excel file) shaped exactly the way Google Sheets imports cleanly, with each field in its own column.
A standard comma-delimited, UTF-8 CSV with one transaction per row, so File, then Import drops it into a Google Sheet without a one-column mess.
Date, description, debit, credit, and running balance each land in their own column, ready to sort, filter, and total.
Dates come through in a consistent format and amounts as plain numbers, so QUERY, SUMIF, and pivot tables work the moment the data lands.
OCR pulls transactions from scanned PDFs and phone photos in JPG, PNG, HEIC, and TIFF, not just digital PDFs.
Prefer Drive? Download the Excel file, drop it in Google Drive, and open it with Google Sheets to skip the import dialog entirely.
256-bit encryption in transit and you can delete your uploaded files whenever you want.
No software to install and no credit card to start.
Drag your PDF, scanned statement, or photo into the box above. Password-protected PDFs work too.
Tip: Multi-page and multi-month files are fine.
The AI reads every transaction and builds clean, comma-separated rows automatically.
Tip: Most statements finish in under a minute.
In Google Sheets open File, then Import, then Upload, and drop in the CSV.
Tip: Choose Replace spreadsheet for a fresh sheet or Append to add to existing data.
Google Sheets is where a lot of US small businesses, founders, and bookkeepers actually keep their numbers, because it is free with a Google account and easy to share.
Teams that run on Google Workspace instead of Microsoft 365 and want transactions in a Sheet, not an Excel file.
Track burn, runway, and spend in a shared Sheet without paying for accounting software yet.
Build a simple income and expense tracker in Sheets from a year of statement PDFs.
Collaborate live with clients in one Sheet instead of emailing Excel files back and forth.
Because Sheets will not read a PDF, you convert the statement first and then bring the file in one of two ways. Both start from the same BankXLSX conversion, so pick whichever fits how you work. The CSV import is the most reliable; opening an Excel file from Drive is the fastest if you already keep files there.
| Method | How it works | Best when |
|---|---|---|
| CSV import | Convert to CSV, then File, Import, Upload in Sheets | You want the cleanest columns and full control over Replace or Append |
| XLSX in Google Drive | Convert to Excel, upload to Drive, open with Google Sheets | You already store files in Drive and want one click |
| Marketplace add-on | A third-party add-on extracts the PDF inside Sheets | You are fine granting an add-on access to your sheets and data |
| Manual copy and paste | Paste from the PDF, then Split text to columns | Never the best option for a real statement; columns break |
Once you have the CSV from BankXLSX, the import takes about thirty seconds. Open a Google Sheet, then click File, then Import. Switch to the Upload tab and drag the CSV in, or click Browse to pick it. Choose an import location: Replace spreadsheet for a clean sheet, or Append to current sheet if you are adding a new month under data you already have. Leave the separator type on Detect automatically, keep Convert text to numbers and dates turned on, and click Import data. Your transactions land in neat columns, ready to filter and total.
BankXLSX writes clean values, but Google Sheets sometimes formats a column its own way, so a quick check saves headaches later. If a date column shows as plain text or a serial number, select it and use Format, then Number, then Date. If amounts will not add up, select the column and use Format, then Number, then Currency so Sheets treats them as numbers. Then sanity-check the data: compare the last running balance in your sheet against the closing balance on the PDF, and scan for any missing or duplicated rows before you build formulas on top of it.
This is where Google Sheets earns its place. With the data in columns you can write a QUERY to pull one vendor or one month, use SUMIF to total a category, drop in a pivot table to summarize spend, or add a category column and tag each transaction for a simple budget. Sharing is the other win: send the Sheet to a partner or accountant and you both work in the same live file instead of trading Excel attachments. If you would rather the categories be filled in before you start, the transaction categorization tool assigns them during conversion.
If your team actually lives in Excel rather than Sheets, the PDF bank statement to Excel converter produces the same clean rows as a formatted .xlsx workbook, and the PDF bank statement to CSV converter covers any other import. The converter is tuned to how US banks print statements, so start from your bank if it has a page: Chase, Bank of America, or Wells Fargo. For a wider look at accuracy and price across tools, see the guide to the best bank statement converter software, and the general bank statement converter handles every format from one upload.
A Google Sheet is often the working copy, not the final home for your books. If you run QuickBooks, you can skip the spreadsheet and convert the statement straight to a QuickBooks bank statement file instead of importing rows by hand. To back up the spending with proof, an invoice and receipt OCR tool turns paperwork into the same kind of structured rows you can keep alongside the statement. And for any other PDF you need in a sheet, a general PDF to Excel converter does the same job for reports and tables.
Convert the PDF to CSV first, because Google Sheets cannot read a PDF. Upload your statement to BankXLSX, download the CSV, then in Google Sheets open File, then Import, then the Upload tab, and drop the file in. Choose Replace spreadsheet or Append, leave the separator on Detect automatically, and click Import data. The transactions land in clean date, description, and amount columns.
No. Google Sheets imports CSV, XLSX, ODS, and TSV files, but it has no option to read a PDF directly. You have to convert the statement to CSV or Excel first, then import that file. BankXLSX does the conversion and gives you a CSV that imports into a Sheet in one step.
Open a Google Sheet and click File, then Import. Switch to the Upload tab, drag in your CSV, and pick an import location: Replace spreadsheet for a fresh sheet or Append to current sheet to add to existing data. Keep the separator on Detect automatically and click Import data, and your rows appear in their own columns.
You do not really need a template once the data is structured. Convert the PDF to CSV with BankXLSX and import it, and you get date, description, debit, credit, and balance columns you can build a tracker on with a pivot table or a SUMIF. A blank template only helps if you are still typing transactions by hand, which the converter removes.
You can start on BankXLSX free with no credit card, which is enough to convert a statement and import it into Sheets to see the output. Free browser tools and add-ons exist too, but they often break the columns or want broad access to your Google account, so check the result against your PDF before trusting it.
Sheets sometimes reads a column as text when amounts carry dollar signs or commas, or when a date format is ambiguous. Select the amount column and use Format, then Number, then Currency, and select the date column and use Format, then Number, then Date. BankXLSX writes plain numbers and consistent dates to keep this to a quick check rather than a cleanup.
Yes. A scanned or photographed statement is an image with no copyable text, so BankXLSX uses OCR to read the transactions. Upload the scan as a PDF, JPG, PNG, HEIC, or TIFF, download the CSV, and import it into Sheets the same way you would a digital statement.
Some add-ons offer a live bank feed into Sheets, but feeds skip older periods, closed accounts, and many smaller banks, and they require granting access to your accounts. Converting the PDF statement gives you every transaction for the period from a document you already have, with no third-party access to your bank login.
Yes. Convert a full year or several accounts at once, then import the first CSV with Replace spreadsheet and each later one with Append to current sheet, so everything stacks into one sheet you can filter by month or account. That makes a year-long tracker or a loan file practical without importing each PDF separately.
Convert to a formatted Excel workbook instead.
Export a clean CSV for any software import.
Built for high-volume bookkeeping work.
From the same family of tools
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
