Import Bank Statement into Google Sheets: Quick Guide
Google Sheets is one of the most popular tools for managing personal and business finances. But getting your bank statement data from a PDF into Google Sheets has always been painful -- until now. This guide shows you how to import bank transactions into Google Sheets in under a minute.
Why Google Sheets for Bank Statement Analysis?
- Free and accessible: No software to install. Works on any device with a browser.
- Collaboration: Share with your accountant, bookkeeper, or business partner in real time.
- Powerful formulas: Use SUMIF, VLOOKUP, pivot tables, and charts to analyze spending.
- Apps Script automation: Automate categorization, reporting, and reconciliation with Google Apps Script.
Method 1: Convert PDF to CSV, Then Import (Recommended)
The fastest and most reliable method is to convert your PDF bank statement to CSV first, then import the CSV into Google Sheets. Here is how:
Convert your PDF to CSV
Go to our converter page and upload your PDF bank statement. Select CSV as the output format and download the result.
Open Google Sheets
Go to sheets.google.com and create a new blank spreadsheet. Or open an existing spreadsheet where you want to add the transactions.
Import the CSV
Go to File → Import → Upload. Select the CSV file you downloaded. Choose "Replace current sheet" or "Append to current sheet" depending on your needs. Set the separator type to "Comma" and click Import Data.
Format and analyze
Your transactions are now in Google Sheets with columns for Date, Description, Amount, and Balance. Format the date and currency columns, add filters, and start analyzing.
Method 2: Copy-Paste from Excel
If you prefer working with Excel first, you can convert your PDF to Excel (.xlsx), open it in Excel or Google Sheets, and then copy-paste the data into your master spreadsheet.
- Convert your PDF to Excel using our converter
- Open the Excel file in Google Sheets (File → Open → Upload)
- Select all transaction data (Ctrl+A)
- Copy and paste into your target spreadsheet
Supported Banks
Our converter works with all major Nordic banks and many international banks:
Google Sheets Formulas for Bank Statement Analysis
Once your transactions are in Google Sheets, here are some useful formulas:
Total spending (negative amounts)
=SUMIF(C2:C1000,"<0",C2:C1000)Total income (positive amounts)
=SUMIF(C2:C1000,">0",C2:C1000)Count transactions containing a keyword
=COUNTIF(B2:B1000,"*Swish*")Sum of transactions by category keyword
=SUMIFS(C2:C1000,B2:B1000,"*ICA*")Tips for Managing Multiple Months
- One sheet per month: Create a new tab for each month to keep things organized.
- Summary dashboard: Create a summary tab that pulls totals from each monthly sheet using INDIRECT formulas.
- Consistent column order: Always use the same column order (Date, Description, Amount, Balance) so formulas work across sheets.
Frequently Asked Questions
Can I import directly from my bank into Google Sheets?
Most Swedish banks do not offer direct Google Sheets integration. The fastest method is to download your PDF kontoutdrag, convert it to CSV using our tool, and then import the CSV into Google Sheets.
Will Swedish characters (a, a, o) display correctly?
Yes. Our CSV exports use UTF-8 encoding, which Google Sheets fully supports. All Swedish, Norwegian, and Danish characters will display correctly.
Can I automate this process?
Yes. Our Pro plan includes API access, so you can build a Google Apps Script that calls our API to convert PDFs and populate your spreadsheet automatically.
Related Guides
Excel Import Bank Transactions
Best practices for importing transactions into Excel.
Automate Bank Statement Import
Save hours every month with automated PDF conversion.
Handelsbanken to Excel
Convert Handelsbanken kontoutdrag to spreadsheet format.
Import into Fortnox
Step-by-step Fortnox bank reconciliation guide.