Menu
PDF Tools
Image Tools
Converters & Utilities
Seller & Print Tools
Accounting & Business
Calculators
Text & Writing Tools
Developer & Web Tools
Creator & Social Tools
Browser Utilities & Games
Document & Design Makers
Text & Developer Tools
Exam & Form Tools

Bank Statement to CSV

Paste the text copied from your statement PDF and get a table and a CSV with date, description, money out, money in and balance. The page checks the running balance and marks lines it is unsure about.

How to use Bank Statement to CSV online

  1. Copy the text from the PDF. The transaction lines.
  2. Paste it here. Add the opening balance if you have it.
  3. Check the table. Look at marked lines and totals.
  4. Copy the CSV. Open it in a spreadsheet.

Why use this free Bank Statement to CSV

  • Date, description, debit, credit and balance
  • Running balance check
  • Marks uncertain lines
  • Totals to compare
  • Safe against formula injection

From statement text to a table

Open your statement PDF, select the text of the transactions, copy it and paste it here. The page looks for lines that start with a date and end with amounts, works out the description in between, and decides for each line whether the money went out or came in. The result is a table you can copy as a CSV for a spreadsheet.

How it tells money out from money in

Some statements have separate debit and credit columns, some mark amounts with Dr and Cr, some use brackets or a minus sign, and many show one amount and a running balance. In that last case the page compares each balance with the one before: if the balance went up by the amount, it was money in. An opening balance line, or the opening balance you type in, gives the starting point.

The checks

The page recomputes the running balance line by line. If the balance before, plus the money in, minus the money out, does not equal the balance shown, that line is counted as a mismatch, which usually means a line is missing or misread. Lines whose direction cannot be told are marked so that you can fix them. Totals of money out and in are shown so you can compare them with your statement.

Dates

Dates are written to the CSV as year, month, day. Day-first dates are the default; switch to month-first if your statement uses it. Dates such as 12 Mar 2024, 12-Mar-24 and 2024-03-12 are understood. Lines without a date are treated as the continuation of the line above, such as a long description.

Honest limits

Statements from different banks look very different, and copying text from a PDF can scramble the columns. This page reads the common line-based layouts and will miss others, so treat the result as a first draft and always compare the totals with the statement. It cannot read a scanned statement, and it works only on the text you paste. Nothing leaves your browser.

Using the tool

The result shows under the boxes and refreshes as you edit. Press Try a sample to see how it behaves.

Bank Statement to CSV: frequently asked questions

Does it read the PDF directly?
No. You copy the text from the PDF and paste it. This keeps it simple and private.
Why are some lines marked check?
The page could not tell whether the amount was money out or in. Fix those lines by hand.
What does a balance mismatch mean?
The running balance does not add up, so a line may be missing or misread.
Will it work for every bank?
No. It reads common layouts with a date at the start and amounts at the end. Others may need editing.
Does the statement text go to a server?
It is processed inside this browser window and then forgotten.
Is the text I paste into the Bank Statement to CSV uploaded?
Your text stays on this device when you use the Bank Statement to CSV. The editor may keep the last text locally and offers to bring it back; you can dismiss it.
Is there a way to reuse the Bank Statement to CSV result?
Yes. Use the copy button on the Bank Statement to CSV result, or select it and copy it by hand.

Related searches for Bank Statement to CSV

  • Bank Statement to CSV online
  • free Bank Statement to CSV
  • Bank Statement to CSV online free
  • Bank Statement to CSV for mobile
  • Bank Statement to CSV without sign up
  • convert bank statement to csv
  • bank statement to csv converter
  • Bank Statement to CSV – Loans & Investing

Bank Statement to CSV is a free online tool on MAITBOX, in the Loans & Investing group. It runs in your browser, so what you type is not sent to a server. It works on Android and iPhone, and on Windows, Mac and Linux, with no download and no account.

More tools in Loans & Investing →

Search tools