Getting started

Kotak Mahindra bank statement to CSV: ways to get a clean file

Turn a Kotak Mahindra bank statement into a clean CSV: pick the right download, convert a PDF in Excel, fix dates and amounts and check totals.

Editorial illustration for Kotak Mahindra bank statement to CSV: ways to get a clean file

To get a Kotak Mahindra statement into CSV, first look for a CSV or Excel download in your own net-banking or app statement options, and use the PDF route only if no spreadsheet format is offered. Then fix dates and amounts and check that the row count and totals match the original. Menus and formats change, so follow what your own screen shows.

Which statement format should I choose?

When your bank gives you a choice, a spreadsheet-style file is easier to work with than a PDF, because the columns are already separated. Look for words such as CSV, XLS or Excel near the statement download button. If the only option is PDF, that works too, but plan a little more checking. Exact screens can differ between net banking and the mobile app, so read the options your own account shows.

How do I convert a PDF statement to CSV in Excel?

Excel for Microsoft 365 and recent versions can read tables from a PDF. The steps are general, and names of buttons can differ slightly by version.

  1. Open a blank workbook and use Data, then Get Data, then From File, then From PDF.
  2. Pick the statement file. If the PDF is password-protected, open it first in a PDF reader and save an unlocked copy for yourself.
  3. In the navigator, choose the table that holds the transactions; multi-page statements may show one table per page.
  4. Load or transform the data, then combine the page tables into one list.
  5. Delete opening-balance, closing-balance and page-total lines, so only transactions remain.
  6. Save as CSV (comma delimited) using File, then Save a Copy.

Google Sheets cannot import a PDF directly. Open the PDF in a reader, copy the rows, and check the pasted columns carefully.

What usually goes wrong in the converted file?

  • Dates stay as text such as 05/04/2026 and sort wrongly.
  • Amounts are text with Indian-style commas, so SUM returns zero.
  • Debit and credit sit in two columns, and one is blank on each row.
  • A long narration wraps into the next row and creates a row with no date.
  • Repeated header lines appear at the top of every page.

For text dates in dd/mm/yyyy in cell A2, this formula makes a real date: =DATE(RIGHT(A2,4),MID(A2,4,2),LEFT(A2,2)). For text amounts in C2 such as 1,24,500.00, use =VALUE(SUBSTITUTE(C2,",","")). Fill both down, then copy and paste as values.

How do I check the CSV against the original?

Do two checks before trusting the file. Count: if the PDF shows 52 transactions, your sheet should have 52 data rows. Total: add the debit column and the credit column and compare them with the totals printed on the statement, if it prints them. Say your sheet shows debits of ₹58,400.00 and the statement says ₹58,400.00 while credits differ by ₹1,250. A row with a credit has probably been shifted into the wrong column, so filter for blank dates and look near them.

Do I need a CSV at all?

If your goal is tracking spending, maybe not. SpendixAI accepts PDF, CSV or Excel statements and lets you review the rows before saving, after you pick the account the statement belongs to. It does not promise every layout will read perfectly, which is why the review step exists. A CSV is worth making when you want your own pivot tables or your CA asks for a spreadsheet.

Before you use the file

  • Dates are real dates, amounts are real numbers.
  • Row count and totals match the statement.
  • Opening and closing balance rows removed.
  • File saved with the month and account in its name.
SPENDIXAI JOURNAL

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

Explore your reports