To import a statement CSV into Google Sheets with dates intact, set the spreadsheet's locale first, then use File > Import, choose the separator and import into a sheet. The locale decides whether 05/01/2026 is read as 5 January or 1 May, so set it to India before importing, not after.
Which settings matter before you import?
Open a new spreadsheet and choose File > Settings. On the General tab, set Locale to India. Sheets uses this setting to read dates and numbers while importing, so it controls the result. Save the setting, then continue.
How does File > Import work for a statement?
- Choose File > Import and open the Upload tab. Drag the CSV in, or browse to it.
- For Import location, choose Replace spreadsheet for a fresh file, or Insert new sheet(s) to keep your existing tabs.
- For Separator type, avoid relying on Detect automatically if the columns look wrong. Choose Comma, Semicolon, Tab or Custom to match the file as seen in Notepad.
- Decide on Convert text to numbers, dates, and formulas. Leave it ticked for amounts and dates, and untick it if reference numbers must stay exactly as written.
- Click Import data.
The unticked option loads every cell as text. You can then convert only the date and amount columns, which protects long UPI references and cheque numbers with leading zeros.
Why does 05/01 become the wrong date?
The slash is ambiguous. Indian bank files write day first, so 05/01/2026 means 5 January 2026. A sheet set to a month-first locale reads the same text as 1 May 2026. Worse, a date such as 25/01/2026 cannot be a month-first date, so it stays as text. You end up with a column where some rows are real dates and others are not.
| Text in the CSV | Read with a month-first locale | Read with the India locale |
|---|---|---|
| 05/01/2026 | 1 May 2026, a real date but wrong | 5 January 2026 |
| 12/03/2026 | 3 December 2026, wrong | 12 March 2026 |
| 25/01/2026 | Left as text, because there is no 25th month | 25 January 2026 |
A quick test: real dates sit on the right of the cell and text sits on the left. If a single column has both, the locale is wrong. Note that a file that already uses year-month-day text, such as 2026-01-05, reads correctly either way.
How do you fix a sheet that is already wrong?
- Open File > Settings and change the Locale to India.
- Delete the sheet and import the CSV again, because the existing cells were already interpreted.
- If you only have text left, use =DATEVALUE(A2) in a helper column. It follows the sheet's locale, so with the India locale it reads 25/01/2026 correctly.
What about amounts and the first row?
Amounts such as 41,550.00 should convert to numbers and sit on the right of their cells. If they stay on the left, the box for converting text was unticked, or the file's separator is not what you chose. Import again with the correct choice.
Once the data looks right, choose View > Freeze > 1 row so the header stays visible, and format the amount columns with a number format. Keep the Locale on India for the whole spreadsheet, because formulas such as DATEVALUE and TEXT also follow it.
If you import several months, use Insert new sheet(s) for each file and name each tab after the month. Combining them later is easier when every tab has the same column order, so avoid adding or deleting columns in only some of them.
Checks before you build anything on it
- Sort the date column. A mixed column will sort in two clumps.
- Add the amount column and compare the sum to the statement total.
- Confirm the first and last dates equal the statement period.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
