Cosmovex/tools

Turn a bank statement PDF into an Excel file with real dates and numbers

PDF to Excel with Statement to Spreadsheet

This page opens with a bank statement that has one signed Amount column and a running Balance, and Excel (.xlsx) as the download. Drop in your own PDF and it finds the table, follows it across pages and gives you a workbook where dates are real dates, amounts are numbers and descriptions are text.

  1. Drop your statement PDF on the tool, or press Choose a PDF. It is read in your browser and never uploaded.
  2. Look at the preview. Rows marked in amber could not be read cleanly and stay out of the file until you tick them.
  3. If a note about the date order or the year appears, pick the right option so every date is read the way your bank printed it.
  4. Check the line that says whether the running balance adds up, then press Download Excel.
bank statement pdf to excel convert bank statement to excelpdf bank statement to xlsxbank statement to spreadsheetextract transactions from bank statement pdf
Open Statement to Spreadsheet Free to start · no account

What to know

Banks print transactions as text laid out in columns, and the PDF only stores where each piece of text sits on the page. The tool groups the pieces into lines, then into cells, finds the header row (Date, Description, Amount or Debit and Credit, Balance) and assigns every cell to its column by position. That is why it works across pages, and why a header repeated at the top of each page is recognised and not read as a transaction.

The Excel file is built with typed cells. A date is stored as a date serial with a yyyy-mm-dd format, an amount as a number with two decimals, and a description as text, so SUM, filters, pivot tables and date sorting work immediately. Money out is a negative number in the Amount column, and the Debit and Credit columns are filled alongside it.

A converter is only useful if you can trust it, so the tool checks its own work where it can. If the statement has a Balance column, it adds each amount to the previous balance and compares the result with the printed balance. When every row matches you will see that it adds up; when one does not, the row is marked, which usually means a line was missed or read wrongly.

Updated · Cosmovex

Questions

Does the bank statement PDF get uploaded?

No. The file is opened and read by code running in your browser tab and the Excel file is built there too. Nothing from the statement is sent to our servers.

Why are the amounts negative for money out?

The Amount column is signed: money out is negative and money in is positive, so a plain SUM gives the net movement. Debit and Credit columns with positive numbers are filled in next to it if you prefer that layout.

What if my PDF is a scan?

A scan or a photo of paper has no text for the tool to read, and it does not do OCR. It will tell you so. Download the statement as a PDF from your bank's website instead; those have selectable text.

How many rows can I convert for free?

Free reads the first 2 pages and exports 25 transactions, up to 3 times a day. Pro reads every page, with no row limit.

Why is one row marked and left out?

The tool keeps every line that looks like part of the table. If a line has a date but no amount, or an amount but no date, it is shown with a note and excluded from the file until you tick it, so nothing disappears silently.

The free plan covers everything on this page. Statement to Spreadsheet Pro ($9/mo, billed monthly) is described on the Statement to Spreadsheet page.