Google Sheets cannot read a PDF, so a bank statement drops in as a blob of unaligned text or not at all. Convert the PDF here first and you get a clean CSV: one row per transaction with date, description, amount, and running balance. Then File, Import in Sheets, or paste an IMPORTDATA link, and the data lands in real columns. Start free, no credit card.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Sheets is built to read tables, and a bank statement PDF is not a table. That mismatch is where every failed copy-paste comes from.
Google Sheets has no menu option to open a PDF. File, Import accepts CSV, XLSX, ODS, TSV, and TXT, but never PDF, so the statement has to become one of those first.
Paste a page from a PDF and the date, description, and amount all land in a single column, because the PDF positions text by coordinates rather than in fields.
The IMPORTDATA function pulls a CSV or TSV from a URL, not a PDF. Point it at a statement PDF and it returns an error or a wall of unreadable characters.
Dollar signs, commas, and parentheses for negatives make Sheets treat an amount as text, so SUM returns zero until every cell is cleaned.
A scanned or photographed statement is an image. There is nothing to select or paste, so it needs OCR before Sheets can use a single number from it.
Rough conversions return date, description, and amount but drop the running balance column, which is the one figure you tie back to when you reconcile.
Upload the PDF and the converter returns a CSV shaped for a spreadsheet, so the Sheets import is the easy part.
Date, description, amount, and running balance each land in their own column, ready to import as a clean table.
Download a UTF-8 CSV that File, Import reads without a mapping step, or feed a hosted copy to IMPORTDATA for a live link.
Amounts come through as plain numbers with no dollar signs or stray commas, so SUM and pivot tables work the moment the data lands.
OCR pulls transactions out of a scanned statement or a phone photo, so image-only PDFs work too.
Convert several months at once and stack them into one tab instead of importing twelve files by hand.
256-bit encryption in transit and you can delete your uploaded files whenever you want.
No add-on to install and no credit card to start.
Upload your bank statement above and download the result as CSV. The converter reads every transaction line into a row.
Tip: A scanned statement works, the OCR handles it.
In Google Sheets open File, then Import, then Upload, choose the CSV, and pick Replace current sheet or Insert new sheet. Leave the separator on Detect automatically.
Tip: Append to current sheet stacks a new month under an existing one.
Total the amount column and compare it to the closing balance on the statement so you know nothing was dropped.
Tip: A matching balance proves the import is complete.
Sheets is the ledger of choice for people who want their numbers shared, live, and free of a desktop install. The statement still arrives as a PDF, so the conversion step is the bridge.
Track income and expenses for a Schedule C in a Sheet they can open anywhere, without buying Excel.
Keep a shared cash-flow tab the whole team can see, updated from each month's statement.
Work entirely in Sheets across clients and drop each converted statement into the right tab.
Feed real transactions into a Sheets budget template instead of typing them in by hand.
Split rent, deposits, and repairs per property in a Sheet that doubles as the year-end record.
Give a treasurer a plain, shareable transaction log without paying for accounting software.
Not directly. Google Sheets has no native PDF import and its File, Import menu accepts only CSV, XLSX, ODS, TSV, and TXT. A PDF stores text by coordinates on a page, mixed with logos and headers, with no underlying table for a spreadsheet to read. The reliable path is a two-step one: convert the statement PDF to a CSV, then import that CSV. Once the file is a CSV, Sheets reads it in seconds and you get dated rows with amounts you can total, chart, and reconcile.
After you have converted the statement to a CSV, any of these three routes puts it into Google Sheets. They differ mainly in whether you want a one-time paste or a live link.
| Method | How | Best for |
|---|---|---|
| File, Import | File then Import then Upload, choose the CSV, pick Replace, Insert new sheet, or Append. | A one-time load of a downloaded statement. |
| IMPORTDATA | Host the CSV at a public URL and put =IMPORTDATA("url") in a cell. | A sheet that should refresh when the CSV changes. |
| Copy and paste | Open the CSV, select all, paste into Sheets, then Data, Split text to columns if needed. | A quick check when you only need a few rows. |
File, Import is what most people want. The Append to current sheet option is the one to remember when you are building a running year: convert January, import it, then convert February and append it under the same headers. IMPORTDATA is useful when the same CSV lives on Drive and gets replaced each month, because the Sheet updates itself. Note that IMPORTDATA reads a CSV or TSV only, never a PDF, which is the mistake behind most of the error messages people hit here.
Import a raw statement export and the amount column often lands as text, because Sheets sees a dollar sign, a comma every three digits, or a negative wrapped in parentheses and stops treating the cell as a number. SUM then returns zero. Converting the statement here strips those out, so an amount arrives as a plain number such as 1250.00 or negative 84.20 that adds up straight away. If you ever import a file that still has the symbols, select the column and use Format, Number, or Data, Split text to columns, then find and replace the parentheses with a minus sign.
The conversion is the same either way, the difference is where the file goes next. Choose Google Sheets when the ledger needs to be shared with a partner or an accountant, edited from a phone, or linked live with IMPORTDATA and IMPORTRANGE. Choose Excel when you are running heavy pivot tables, large multi-year workbooks, or macros. Because the converter outputs both CSV and XLSX, you are not locked in: import the CSV to Sheets today and open the XLSX in Excel later from the same conversion. The PDF bank statement to Excel converter covers the Excel path in full, and the PDF bank statement to CSV converter details the CSV that Sheets imports.
Rows in a tab are the starting point, not the finish. Grouping the spend is usually next, and the categorize transactions page assigns each line an income or expense category before you build a total. To turn the tab into a monthly summary, the bank statement to profit and loss page shows the layout, and to tie the sheet back to the statement, see reconcile bank statements. Banking with a major name? Start from its page, such as Chase, Bank of America, or Wells Fargo, then import the CSV to Sheets. If your books actually live in QuickBooks rather than a spreadsheet, you can skip Sheets and convert straight to a QuickBooks-ready statement file.
Not directly. Google Sheets cannot read a PDF, and File, Import accepts only CSV, XLSX, ODS, TSV, and TXT. Convert the statement PDF to a CSV first, then import that CSV. The conversion turns the PDF into dated rows with amounts, which Sheets reads in seconds.
Upload the PDF here and download the result as CSV, then in Google Sheets choose File, Import, Upload, select the CSV, and pick Replace current sheet or Insert new sheet. The transactions land in real columns with date, description, amount, and running balance.
IMPORTDATA can read a bank statement only after it is a CSV or TSV at a public URL. It cannot read a PDF. Convert the statement to CSV, host it, then use =IMPORTDATA("url") in a cell for a link that refreshes when the file changes.
Sheets treats an amount as text when it contains a dollar sign, a thousands comma, or parentheses for a negative, so SUM returns zero. Converting the statement here removes those symbols so amounts import as plain numbers. If a raw file still has them, use Data, Split text to columns and replace parentheses with a minus.
Yes, but not by pasting. A scanned or photographed statement is an image with no selectable text, so it needs OCR first. The converter reads the image, extracts the transactions, and gives you a CSV you import into Sheets the normal way.
Convert each month, then import the first CSV with Replace current sheet and every later one with Append to current sheet, keeping the same headers. You can also convert several statements at once and stack them, then sort the whole tab by date.
The conversion runs over 256-bit encryption and you can delete your uploaded files at any time. Your Google Sheet itself is private to your account unless you share it, so keep sharing off for a tab that holds account activity.
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 |
