Convert a bank statement to Google Sheets
Google Sheets imports CSV files directly via File → Import. Convert your statement PDF to a categorized CSV first, then import it into a new or existing sheet.
Fictional sample output
Preview the CSV before importing into Google Sheets
Statently turns separate withdrawals and deposits into one signed Amount column, cleans descriptions, and adds a category. This preview uses a fictional statement.
| Date | Description | Amount | Category |
|---|---|---|---|
| 2026-06-03 | Northwind Payroll | +3,450.00 | Income |
| 2026-06-04 | Harbor Market | -84.21 | Groceries |
| 2026-06-06 | City Utilities | -126.40 | Utilities |
| 2026-06-08 | Cloudwork | -18.00 | Software |
Private by design. Your uploaded PDF is processed in memory to create the CSV and is not stored.
Always review before importing. Compare totals and a sample of transactions with the original statement before reconciliation, tax filing, or accounting import.
How to import a statement into Google Sheets
- 1. Convert the statement. Upload the statement PDF and download the CSV.
- 2. Import into Sheets. In Google Sheets: File → Import → Upload, and select the CSV.
- 3. Choose import options. Pick 'Insert new sheet' or 'Replace current sheet' and confirm.
Frequently asked questions
- Can I import straight from a PDF into Google Sheets?
- No — Google Sheets imports CSV/XLSX, not PDF. Convert the statement to CSV first.
Export to other tools
Convert a statement from your bank
Related guides
- How to Convert a Bank Statement PDF to CSV
The fastest way to turn a bank statement PDF into a clean CSV — what a CSV needs to contain, why manual methods break, and how to do it in seconds.
- How to Convert a Scanned Bank Statement to CSV
Scanned or photographed bank statements have no selectable text, so most converters choke on them. Here's how to turn an image-only PDF into a clean CSV.
- How to Import Bank Statements into QuickBooks
How to get transactions from a PDF bank statement into QuickBooks Online using a CSV — the format QuickBooks expects, and how to prepare it in seconds.
- How to Import Bank Statements into Xero
How to get transactions from a PDF bank statement into Xero using a CSV — the exact column format Xero expects and how to prepare it in seconds.