Bank Statement PDF to CSV: Easy Free and Fast Ways

Your bookkeeper asks for your bank transactions "as a CSV." Or your budget app says it can import a CSV file. But your bank only gives you a PDF. Typing every line by hand takes a long time, and one slip can throw off the whole month.

This guide shows a free way to do it and a faster way with MyBankToExcel, which turns a bank statement PDF into a CSV file. At the end there is a quick check to make sure nothing was missed.

What is a CSV file?

CSV is a plain table saved as text. Each line is one row, and commas split the columns. It has no colors, no bold and no formulas. That is why almost every program can open it: Excel, Google Sheets, Numbers, and most bookkeeping and budget apps.

Before you start: is your PDF real text or a picture?

Open your statement and try to highlight one word with your mouse.

• If the word highlights, your PDF has real text. The ways below can work.
• If you can only draw a box, your statement is a scan (a photo of paper). Neither way below can read it. Download the statement again from your bank's website instead.

Way 1: Use Excel, then save as CSV (free, Windows only)

Newer Excel for Windows (Microsoft 365) can open a PDF. Excel for Mac and Excel on the web can't.

1. Open a blank Excel workbook.
2. Click Data, then Get Data, then From File, then From PDF.
3. Pick your statement and click Import.
4. Click each item in the list to preview it. Find the one that shows your transactions.
5. Click Transform Data and delete rows that aren't transactions, like page numbers and headings.
6. Click Close & Load.
7. Click File, then Save As. Under file type, choose CSV (Comma delimited). Save.

The honest catch: bank statements have no lines between rows. Excel often joins a description with an amount, or splits one purchase over two rows. Headings that repeat on each page can land in the middle of your data. For a short statement this can be fine. For a long one, plan on some clean-up.

Way 2: Use MyBankToExcel (fastest)

MyBankToExcel is made for bank statements. It keeps each purchase on one row, even when the description wraps onto two lines.

1. Go to tools.ltd/my-bank-to-excel.
2. Click Choose a PDF and pick the statement from your bank.
3. Press Read my statement.
4. Look over the rows it found. You can see the first rows for free. If some rows can't be read, it tells you.
5. Leave the file type on Excel or Google Sheets (CSV). Most people use this one.
6. Press Download and save your CSV file. Downloads are a paid step, and the tool page shows the cost before you pay.

Your CSV has four columns: Date, Description, Amount and Balance. Money out is a minus number and money in is a plus number. Every date is written the same way, year first (like 2026-08-01), so dates sort in the right order.

Need a file for QuickBooks or Quicken instead? Open More options in step 3 to pick a QBO or OFX file.

Check that the numbers add up

Do this quick check whichever way you choose. It catches almost every mistake.

1. Find the starting balance on your statement.
2. Open your CSV in Excel or Google Sheets.
3. Add up the Amount column. (Minus numbers take away on their own.)
4. Add that total to the starting balance.
5. The answer should match the ending balance on your statement, to the penny.

If it doesn't match, look for a missing row, a row that shows up twice, or a number in the wrong column.

Tips

• One file per month. Name them like "Checking 2026-08" so they sort in order.
• Keep the PDF. It is your record if you ever need to check something.
• Sharing the statement itself? Hide your account number first with TrueRedact.
• Not a bank statement? For price lists, reports and other PDF tables, use Sheetsnap instead. It makes an Excel file.

Which way should I pick?

Your situation	Best choice
Short statement and Excel for Windows	Excel, then Save As CSV
Mac, Chromebook or Excel on the web	MyBankToExcel
Long statement or many months	MyBankToExcel
Statement is a scan	Download a new PDF from your bank first

Frequently asked questions

What is a CSV file?

CSV is a plain table file. Each line is one row, and commas split the columns. Excel, Google Sheets, Numbers and most money apps can open it.

Is CSV the same as Excel?

Not quite, but close. A CSV holds only the table, with no colors or formulas. Excel opens it like any other sheet, and you can save it as an Excel file if you want.

My statement is a scan. Will this work?

No. If you can't highlight the words in your PDF, it is a picture of a page. MyBankToExcel needs the PDF you download from your bank's website.

Does MyBankToExcel keep my statement?

No. Your PDF never leaves your device. It is read right in your browser, and only the words are sent to put them in rows. They are never stored.

Related guides: How to convert a bank statement PDF to Excel · Import a bank statement into QuickBooks · More bank statement guides