Getting started

SBI statement to CSV: get a clean file that other tools can read

How to get an SBI account statement into CSV: use a direct download if offered, save from Excel correctly, and fix commas, dates and encoding problems.

Editorial illustration for SBI statement to CSV: get a clean file that other tools can read

Checking whether the net-banking statement page offers a CSV or Excel download is the first step to getting an SBI statement as CSV. If it does, download that. If you only have an Excel file, open it and use Save As, choosing CSV. A PDF has to be converted first, and that route needs more checking, because a CSV is only as good as the table you put into it.

What is a CSV, and why do tools ask for it?

CSV stands for comma-separated values. It is a plain text file where each line is one row and each comma starts a new column. Because it holds no formatting, almost every spreadsheet, accounting tool and expense tracker can read it. That is also its weakness: a CSV cannot tell a reader that a number is a date or that a comma belongs inside a description.

Method 1: a direct download

  1. Sign in to your bank's website the way you normally do, on your own device.
  2. Open the account statement section and choose the period you need.
  3. Look at the list of download formats. Options differ by bank and change over time, so go by what your page shows.
  4. If CSV is listed, download it. If only Excel is listed, go to method 2.

Method 2: Excel to CSV without damage

Open the Excel file and look at it once before saving. Then use File, Save As, and pick CSV UTF-8 (Comma delimited) if your Excel offers it. UTF-8 keeps rupee signs and special characters in narrations from turning into odd symbols. Excel will warn that only the active sheet is saved; that is expected, so make sure the sheet holding transactions is the one on screen.

Why did my CSV break, and how do I fix it?

Say a narration reads PAYMENT TO ANAND STORES, KOCHI REF 4471 and sits in one cell. In a CSV that comma would split the cell in two unless the text is wrapped in quotation marks. Good tools add the quotation marks for you. If a row looks shifted by one column in your import preview, an unquoted comma is the likely cause.

Problem you seeLikely causeWhat to do
Rows shifted to the rightComma inside the descriptionRe-export from the spreadsheet, which quotes text, rather than editing the text file by hand
Dates appear as numbers like 45231Date stored as serial numberFormat the column as Date before saving, or as text in the order DD/MM/YYYY
Odd symbols in narrationWrong text encodingSave as CSV UTF-8
Cheque number lost leading zerosTreated as a numberFormat that column as Text before saving
Opening balance row missingHeader rows deleted too farKeep one row for the first transaction and note the balance separately

How do I check the CSV before I use it?

Open the CSV in a plain text editor such as Notepad, not Excel. You should see the headings on line one and one transaction on each following line. Then confirm the arithmetic. Say the statement shows an opening balance of ₹14,200, three debits of ₹1,200, ₹850 and ₹2,300, and one credit of ₹5,000. The closing balance should be 14,200 minus 4,350 plus 5,000, which is ₹14,850. If your file's total does not agree with the bank's closing balance, find the missing row before importing.

What if I only have a PDF?

Convert it to a sheet first, using the steps for a PDF statement, then save as CSV. You can also upload the PDF straight into SpendixAI, which accepts PDF, CSV or Excel statements and lets you review each row before saving. That skips the CSV step when the only reason for it was getting data into a tracker, though it does not promise every layout will read perfectly, which is why you review.

A final checklist

  • One header row, one transaction per line, no totals row at the bottom.
  • Dates in one consistent order.
  • Debit and credit either in two columns or one signed column, never mixed.
  • File name with the account and month, such as savings-nov-2026.csv saved in a folder only you can open.
SPENDIXAI JOURNAL

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

Explore your reports