Your country

Tools that support it use your country for local currency, number formats, units and paper size. Your choice is saved only in this browser.

Type a name or a two-letter code. Use the up and down arrow keys to move through the countries, Enter to choose one and Escape to close.

Bank Statement PDF to Excel / CSV

Turn a statement PDF into a clean, checked transaction table for Excel.

Free preview, no sign-upIncluded in your pass Premium tool Premium pass: ₹799 / $19.99 for 30 days On this device: nothing is sent
+2 +1 more details No upload PDF

Free preview: a summary and the first rows of the result (up to 10; a single row is shown with its results hidden). Locked until you unlock it: download and copy.

Premium pass ₹799 for 30 days or ₹249 for 1 week, one‑time. Premium pass $19.99 for 30 days or $7.99 for 1 week, one‑time. How to unlock

Try before you buy.

  • Free preview: a summary and the first rows of the result (up to 10; a single row is shown with its results hidden).
  • Locked until you unlock it: download and copy.
  • Unlock: Premium pass, ₹799 for 30 days or ₹249 for 1 week, a one-time payment unless you choose automatic renewal. Unlock: Premium pass, $19.99 for 30 days or $7.99 for 1 week, a one-time payment unless you choose automatic renewal.

Ways to unlock shows how to get the full result.

See passes (opens in a new tab)

Printing this result is locked in the free preview.

Next steps Done. What next?

Start over

A Premium pass unlocks the full result. See passes

All PDF tools

How this tool is checked

Tests
22 automated tests check its results.
Found an error?
Report a problem or write to support@mysmartcopilot.com, with what you entered and the result you expected.

How we check our tools

About the Bank Statement PDF to Excel / CSV

Turn a bank or credit-card statement PDF into one clean transaction table — Date, Description, Debit, Credit, Balance — ready for Excel, Google Sheets or your accounts. The statement’s table is found by its header (Date, Narration, Particulars, Withdrawal, Deposit, Amount, Balance and similar labels), rows are collected across all pages, narrations that wrap over several lines are joined, repeated headers and page footers are left out, and amounts and dates are normalised whether they are written the Indian, US or European way.

Every row with a running balance is checked: previous balance + credit − debit must equal the balance printed. Rows that don’t add up are flagged, so a misread amount can’t slip through unnoticed. Password-protected statements open with your password on your own device — the file is never uploaded — and, with a pass, the table downloads as an Excel workbook (real dates and numbers, plus a summary sheet) or a CSV file.

How to use it

  1. Choose the statement PDF. If it is password-protected, type the password from the email the statement came with.
  2. Check the summary: number of transactions, period, totals and the balance check. Flagged rows are highlighted in the table.
  3. If something was read wrongly, open Reading options and columns to change how dates or amounts are written, or what a column holds.
  4. With a Premium pass, or once this table is unlocked, download Excel (.xlsx) or CSV, or copy the table to paste into a spreadsheet; the free preview shows the first rows.

Examples

A checking or current-account statement
Input
Date · Description · Withdrawals · Deposits · Balance — amounts like 1,250.00, dates like 04/13/2026
Result
One row per transaction with 1250 as a number, 2026-04-13 as the date (the 13 shows that the month comes first) and “OK” in the balance check
A statement with decimal commas (German, French, Dutch …)
Input
Buchungstag · Verwendungszweck · Soll · Haben · Saldo — amounts like 1.250,00, dates like 03.04.2026
Result
Date, Description, Debit, Credit and Balance columns, with 1250 as a number and 2026-04-03 as the date
An Indian savings-account statement
Input
Date · Narration · Chq./Ref.No. · Value Dt · Withdrawal Amt. · Deposit Amt. · Closing Balance — amounts like 1,25,000.00, dates like 03/04/26, narrations over two lines
Result
One row per transaction with the narration joined, 2026-04-03 as the date, 125000 as a number, and “OK” in the balance check
A credit-card statement
Input
Date · Transaction Details · Amount, with payments marked “Cr”
Result
Purchases in the Debit column, payments and refunds in the Credit column
A balance that doesn’t add up
Input
Previous balance 8,800.00, credit 300.00, balance printed 9,050.00
Result
Flagged: 8,800.00 + 300.00 − 0 = 9,100.00 expected, 9,050.00 shown — compare that row with the PDF

Common uses

  • Preparing your tax return or accounts from a year of bank statements.
  • Tracking spending in a budget spreadsheet without retyping transactions.
  • Reconciling invoices and payments for a small business or freelance work.
  • Sending a clean transaction list to an accountant, a lender or a visa application.

How the balance check works

For every row that has a balance, the balance before it plus the credit minus the debit must equal the balance printed: for example 8,800.00 + 300.00 − 0.00 = 9,100.00. When it doesn’t, the row is flagged with the balance that was expected. A flagged row usually means an amount was read into the wrong column, a line of the PDF is missing, or the statement itself has a correction entry.

The same check settles things the layout can leave open: whether the statement lists the newest transactions first (the table is then put in date order), whether an unlabelled amount column is a debit or a credit, and — for a single Amount column without Dr/Cr marks — which amounts are money in and which are money out. Card statements, where purchases raise the balance, are recognised the same way. When the statement shows no running balance, there is nothing to check against: compare the totals with the statement’s own summary.

Number and date formats

  • US / international: 1,234,567.89.
  • European: 1.234.567,89 or 1 234 567,89 (decimal comma).
  • Indian: 1,23,456.78 — lakh and crore grouping is kept in the Excel number format.
  • Debits written as −500.00, (500.00), 500.00 Dr or 500.00- and credits as 500.00 Cr are all recognised.

Dates such as 03/04/2026, 03-04-26, 03.04.2026, 3 Apr 2026, 03-Apr-26, Apr 3, 2026 and 2026-04-03 are read. Whether 03/04 means 3 April or March 4 is worked out from the dates themselves (a day above 12 settles it; otherwise the order that keeps the dates in sequence); you can set it yourself. Dates printed without a year take it from the statement period, moving into the next year where a statement runs from December into January.

What is recognised

Header labels such as Date / Txn Date / Transaction Date, Value Date, Narration / Description / Particulars / Details / Remarks, Chq./Ref. No., Withdrawal / Debit, Deposit / Credit, Amount, Dr/Cr and Balance / Closing Balance — and the usual labels of German, French, Spanish, Italian, Dutch and Portuguese statements (Buchungstag, Verwendungszweck, Soll, Haben, Libellé, Débit, Crédit, Solde, Saldo …). Header labels that wrap onto two lines are joined. Opening-balance lines are used for the check; closing-balance, total and summary lines are not taken as transactions; sections headed “Deposits” or “Withdrawals” sign the amounts under them.

Limitations

  • Scanned statements (pictures of pages) have no text to read: make them searchable with OCR PDF first.
  • Layouts without a header row, statements with several accounts in one file, or headers in other languages than those listed may not be read correctly — check the result, or use PDF to Excel for a plain table.
  • Long narrations are sometimes cut mid-word by the bank’s PDF; the pieces are joined back as well as possible, but a space may be missing or extra.
  • A single Amount column without Dr/Cr marks, minus signs or a running balance can’t say which amounts are money in: they are all listed as debits, as on card statements.
  • This tool reads what the statement shows. Always compare the totals with the statement before relying on them; it is not an accounting or tax service.

Privacy

On this device: nothing is sent

Everything happens in your browser. What you enter or open here is not uploaded or stored by MySmartCoPilot.

How to check that nothing is uploaded

Frequently asked questions

What do I get without a pass?

Without a pass, Bank Statement PDF to Excel / CSV shows a summary and the first rows of the result (up to 10; a single row is shown with its results hidden). Until you unlock it, the result can’t be downloaded or copied. A Premium or Ultimate pass, a one-time payment unless you choose automatic renewal, unlocks the full result. The pricing page lists the passes and their prices.

Is my bank statement uploaded anywhere?

No. The PDF is opened and read by your browser on your device, and the Excel and CSV files are made there too. Nothing — not the file, not the password, not the transactions — is sent to MySmartCoPilot or anyone else.

My statement is password-protected. What is the password?

The bank chooses it and usually explains it in the email that came with the statement — often part of your name, your date of birth, your customer ID or the last digits of your account or card number. Type it when asked; it is used only on your device.

What does “Check — expected …” mean?

That row’s balance doesn’t equal the previous balance plus its credit minus its debit. Look at the row in the PDF: usually an amount was read into the wrong column or a line is missing. Rows that add up show “OK”.

The dates came out as month and day swapped. How do I fix it?

Open Reading options and columns and set Dates are written to Day first or Month first. The table is read again at once.

Does it work with my bank?

It doesn’t use a list of banks: it reads the statement’s table from its column headers, so it works with the common layouts — separate Withdrawal/Deposit (Debit/Credit) columns, or one Amount column with Dr/Cr marks, signs or a running balance. If a column is read wrongly, change it under Reading options.

Can I import the result into Tally or QuickBooks?

The Excel and CSV files are plain transaction tables, which most accounting software can import with its own import tool or a mapping template. Tally, QuickBooks and OFX formats aren’t created here.

Quick answers and tool search

Type to search tools or to get a quick answer, for example 18% of 2500. Use the up and down arrow keys to move through the results, Enter to choose, and Escape to close.