Getting started

Where to find the CSV or Excel statement option in net banking

Where to find the CSV or Excel statement option in net banking: the usual route via statement, custom period and format drop-down, and the PDF fallback.

Editorial illustration for Where to find the CSV or Excel statement option in net banking

In most Indian net banking portals and card sites, the route is the same: open the account, choose account statement, set a custom period, then pick a format from a drop-down before downloading. Look for CSV, Excel or a spreadsheet label. If you only see PDF, use the fallbacks below.

The general pattern

  1. Sign in to your bank's own site or app, using your usual login, and never through a link someone sends you.
  2. Open the account you want and find a section called something like account statement, e-statement or transaction history.
  3. Choose the period: a month, a quarter or a custom date range.
  4. Look for a format option, often a drop-down or a row of small icons.
  5. Select CSV, Excel or XLS and download.

Names differ from bank to bank, and menus change, so treat the steps above as a map. Check your own portal rather than trusting any guide, including this one, for exact wording.

Why is the machine-readable option better?

A PDF is a picture of a page with text on top. A CSV or Excel file is a table, with a column for the date, one for the narration and one for the amount. When your tracker reads the table, there is nothing to guess about page breaks, wrapped lines or repeated headings. That is why SpendixAI accepts all three formats but the spreadsheet types usually import more cleanly.

FormatReads cleanly?Watch for
CSVUsuallyLines of text above or below the table
ExcelUsuallySeveral sheets, merged cells
PDFSometimesPage breaks, wrapped narrations, locks

What if only PDF is offered?

  • Look at a different part of the site: card portals, app statements and branch requests can differ.
  • Try a different period length, since some sites allow spreadsheet export only for shorter ranges.
  • Use the PDF anyway and review the rows carefully before saving.
  • Ask customer care which formats the bank can provide for your account type.

Which period should I pick?

Pick calendar months for bank accounts, and the card's own billing cycle for cards. Each file should start the day after the previous one ended, so months join without overlaps or gaps.

Checking the file after download

Open it before uploading. You should see a table with columns for date, description, debit and credit or amount, and a balance. Check that the dates match your chosen period and that the first and last rows are what you expect.

Say you download a CSV for 1 to 30 April and it has 41 lines. If the statement states 38 transactions, the extra three are probably headings or summary lines, since 41 - 38 = 3. That kind of check is why the review step is worth doing.

A reminder

Some banks also limit how many months you can download at once, or how far back the spreadsheet option goes. If a long range is refused, try shorter ones. Downloading month by month is also what makes your files join without overlaps.

Cards and wallets follow the same idea

Credit card portals and wallet apps work in a similar way: find statements or transactions, choose the billing cycle or a date range, then look for a download option. Cards often list statements by billing cycle rather than by free dates, so you may need to pick the statement for each cycle in turn. Wallets sometimes offer only an in-app history with no export at all, in which case a screenshot is no use, and your best option is to add rows by hand or rely on the bank statement that funded the wallet.

A bank may change its portal without warning, so the option that was in one place last year may sit somewhere else now. If you cannot find it in two or three minutes, ask the bank.

SPENDIXAI JOURNAL

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

Explore your reports