Spreadsheets

Import a bank statement CSV into Google Sheets with dates intact

Import a bank statement CSV into Google Sheets with the right locale and separator so dates such as 05/01 are read correctly, with a before and after.

Editorial illustration for Import a bank statement CSV into Google Sheets with dates intact

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?

  1. Choose File > Import and open the Upload tab. Drag the CSV in, or browse to it.
  2. For Import location, choose Replace spreadsheet for a fresh file, or Insert new sheet(s) to keep your existing tabs.
  3. 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.
  4. 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.
  5. 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 CSVRead with a month-first localeRead with the India locale
05/01/20261 May 2026, a real date but wrong5 January 2026
12/03/20263 December 2026, wrong12 March 2026
25/01/2026Left as text, because there is no 25th month25 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?

  1. Open File > Settings and change the Locale to India.
  2. Delete the sheet and import the CSV again, because the existing cells were already interpreted.
  3. 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.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports