How to Import Commonwealth Bank Bank Statement into Google Sheets
To import your Commonwealth Bank statement into Google Sheets: download your PDF from commbank.com.au → NetBank → Accounts → eStatements, convert it to CSV using Bank Statement Converter (free, under 20 seconds), then upload via Google Sheets → File → Import → Upload. No manual re-keying — all transactions transfer automatically.
Step 1: Download Your Commonwealth Bank Statement
- 1. Log in to NetBank at commbank.com.au and go to your accounts overview
- 2. Select the account you need a statement for
- 3. Click 'eStatements' from the account menu or 'Statements' tab
- 4. Choose the statement period from the dropdown list
- 5. Click 'View' or 'Download PDF' to save the statement to your device
Step 2: Convert PDF with Bank Statement Converter
Upload your PDF to Bank Statement Converter — select CSV output — download in under 20 seconds.
Step 3: Import into Google Sheets
- 1. Open Google Sheets (sheets.new) and create a new blank spreadsheet
- 2. Click File → Import → Upload
- 3. Drag and drop the CSV file from Bank Statement Converter
- 4. Choose 'Replace current sheet' or 'Insert new sheet(s)'
- 5. Click 'Import data' — all transactions appear with correct columns
Frequently Asked Questions
- How do I download my Commonwealth Bank bank statement?
- Log in to NetBank at commbank.com.au and go to your accounts overview → Select the account you need a statement for → Click 'eStatements' from the account menu or 'Statements' tab → Choose the statement period from the dropdown list → Click 'View' or 'Download PDF' to save the statement to your device
- Should I import as CSV or Excel into Google Sheets?
- Either works. CSV is slightly simpler — File → Import → Upload. If you download Excel (.xlsx) from Bank Statement Converter, you can also open it in Google Sheets via File → Import → Upload and select the .xlsx file.
- Does Google Sheets automatically detect dates in CSV imports?
- Usually yes. If dates import as plain text, select the date column, click Format → Number → Date to apply proper date formatting. Then you can use MONTH() and YEAR() formulas for analysis.
- Can I use Google Sheets formulas on the imported data?
- Yes. All Google Sheets functions (SUMIF, QUERY, VLOOKUP, FILTER) work immediately on the imported transaction data. QUERY is especially powerful for date-range filtering.
- Is my Commonwealth Bank data safe to upload?
- Yes. Bank Statement Converter processes files in-memory and deletes them immediately after conversion. No data is stored, logged, or used for model training. No account is required.
Convert Free — No Signup