To import a CSV bank statement into Google Sheets, open a sheet, choose File, then Import, then Upload, and pick an import location and the separator. Tick the option to convert text to numbers and dates, and check the sheet's locale first, so that dates read the way your statement writes them.
What are the import steps and options?
- Open a new or existing spreadsheet and choose File, then Import.
- Upload the CSV, either by dragging it in or by browsing to it.
- Choose an Import location (below).
- Set Separator type. Detect automatically usually works; pick Comma if columns collapse into one.
- Decide on Convert text to numbers, dates, and formulas. Leave it ticked for statements.
- Choose Import data.
| Import location | Use it when |
|---|---|
| Create new spreadsheet | First time, or you want a clean copy |
| Insert new sheet(s) | Keeping each month's file as its own tab |
| Replace current sheet | Re-importing a corrected file |
| Append rows to current sheet | Adding next month's rows under old ones |
| Replace data at selected cell | Dropping data into a prepared layout |
Why do the dates come in wrong?
Sheets reads dates according to the spreadsheet locale, which you find under File, Settings. A statement date of 03/04/2026 means 3 April in India and 4 March in the United States, and if the locale does not match, Sheets may swap the day and month or leave dates as text. Set the locale to India before importing, and spot-check a date with a day above 12, such as 25/04/2026, since that cannot be misread. Left-aligned dates are a warning that they remain text.
What is wrong with the first rows?
Many statement files begin with account details, a period line or the bank's name before the real header row. Delete those rows so that row 1 is the header, and one header row sits above the data. Also look at the bottom for a totals or closing line, and remove or move it, otherwise it gets added into your sums. Do not paste the account number anywhere else.
What are the first clean-up formulas?
Work in helper columns to the right so the raw import stays untouched:
- Text date to date: =DATEVALUE(A2) if the date is still text in a format Sheets recognises.
- Amount with commas as text: =VALUE(SUBSTITUTE(D2,",","")).
- Extra spaces in the narration: =TRIM(C2).
- Debit and credit in separate columns: =F2-E2 for net movement, where E is debits and F is credits.
Row counts are a quick sanity check as well. The import dialog does not show one, so look at the last row number and compare it with the number of transactions your statement summary mentions, where it gives one.
If your bank offers only a PDF, Sheets cannot import it directly. Look in your net-banking statement section for a CSV or Excel download; where that option sits varies, so check your own account. Whatever you import, keep the untouched import on its own tab and do all your clean-up on a copy. That way, if a formula goes wrong, the original rows are still there to start again from.
How do I add next month without duplicates?
Choose Append to current sheet, but note that statements often overlap by a day. Keep a Check column with =COUNTIFS($A$2:$A$2000,A2,$C$2:$C$2000,C2,$D$2:$D$2000,D2)>1 and filter for TRUE. Real repeats exist, such as two identical bus fares, so look at the pair before deleting. Never rely on dates alone.
Where a sheet stops being enough
Spreadsheet imports work well for one account and a few months. When you have several accounts and want categories, duplicates and reports without maintaining formulas, SpendixAI accepts statement files as PDF, CSV or Excel, asks you to review rows before saving and flags possible duplicate imports. It is an option for later, not a reason to abandon a sheet that is working for you.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


