How to convert a PDF bank statement to CSV

Updated 2026-10-10

Most banks let you download statements as PDF, but a PDF is made for reading, not for sorting, filtering or importing. A CSV (comma-separated values) file opens in Excel, Google Sheets, Numbers and is accepted by most accounting and budgeting tools. This guide shows how to get from one to the other and what to check on the way.

Option 1: export CSV from online banking

If your bank offers a CSV or Excel export for the period you need, use it. It is the most accurate source. The catch: many banks only offer a limited history (often 12–24 months) or no export at all for older months, and some only give PDFs for closed statement periods. That is where converting the PDF helps.

Option 2: convert the PDF in your browser

Download the statement PDF from your bank. It must be a text-based PDF (you can select and copy text in it), not a photo or scan.
Open LocalLedger and drop the PDF onto the page. The file is read inside your browser and is not sent to a server.
Review the table of transactions: date, description and amount.
Check the reconciliation message. Opening balance plus the transactions should equal the closing balance.
Download the result as CSV.

What to check before you use the CSV

Balances reconcile. If they do not, a row is missing, duplicated or has the wrong sign. See how to check converted transactions.
Dates. Statements often print 03/04/2026, which is 3 April in many countries and 4 March in the US. Compare the first and last rows with the statement period.
Signs. Money out should be negative (or in a separate column), money in positive. A flipped sign is the most common error.
Several months. If you combine statements, remove duplicate rows where periods overlap.

Opening the CSV in Excel without surprises

Excel decides how to read a CSV from your regional settings. In countries that use a comma as the decimal separator, Excel expects a semicolon as the list separator, so a comma-separated file may land in a single column. If that happens, use Data → From Text/CSV and pick the delimiter manually, or open the file in Google Sheets with File → Import. Long account or reference numbers can also lose leading zeros if Excel treats them as numbers; import those columns as text.

When CSV is not the best format

If your goal is an accounting system, a bank-feed format may save you work: see CSV to QIF, CSV to OFX, or the step-by-step guides for QuickBooks Online and Xero. If you want a spreadsheet to work in directly, read PDF to Excel.

Keep the files safe

Because conversion happens locally, nothing leaves your computer, but the CSV still contains your transactions. Store it like the original statement and delete copies you no longer need.

Try it with your own statement. LocalLedger reads the PDF or CSV in your browser, shows every transaction for review and checks the totals against the statement balances.

Convert your statement now — free preview, nothing uploaded