99b.in
Sign in Open workbench

Convert OFX to CSV

Turn OFX, QFX and QBO bank statements into clean CSV or Excel spreadsheets.

Convert OFX to CSV

Convert financial institution statement downloads in OFX, QFX, or QBO format into clean, readable CSV files or Excel spreadsheets. All transaction processing runs privately in your browser with zero server uploads, keeping your financial data secure.

How to use this tool

  1. Add your statement files: Open Convert OFX to CSV and drop your .ofx, .qfx, or .qbo statement files into the upload area or click Add files.
  2. Choose output format: Under Output format, select CSV (comma separated) or Excel workbook (XLSX).
  3. Configure columns and dates:
    • Amount columns: Select Single signed Amount column (negative for debits, positive for credits) or Separate Debit and Credit columns.
    • Date format: Choose YYYY-MM-DD (standard), MM/DD/YYYY (US), or DD/MM/YYYY (Europe).
    • Delimiter: For CSV exports, choose Comma (,), Semicolon (;), or Tab (TSV).
  4. Convert and download: Click Convert to spreadsheet to process the transactions and download your spreadsheet.

Worked example

When exporting monthly checking account activity from your bank:

  • Starting input: bank-statement-nov2026.ofx containing 42 checking account transactions.
  • Chosen settings:
    • Output format: CSV (comma separated).
    • Amount columns: Separate Debit and Credit columns.
    • Date format: YYYY-MM-DD (standard).
    • Delimiter: Comma (,).
  • Expected output: bank-statement-nov2026.csv. The file opens in Microsoft Excel or Google Sheets with structured columns: Date, Debit, Credit, Type, Payee, Memo, Check Number, and Transaction ID.

Batch processing

When converting a full year of bank or credit card statements:

  • Drop multiple .ofx or .qfx files into the tool at once.
  • The selected settings apply to all files by default.
  • Click an individual file's settings button to adjust options for that statement alone.
  • Click Download all as ZIP to collect all converted spreadsheets in a single archive.

Troubleshooting and limits

  • No transactions found: If the tool reports that no financial transactions were found, confirm that the file is an account statement rather than a sign-on profile or empty export.
  • File format errors: Ensure the file begins with standard OFX headers or XML tags (<OFX>).
  • Special characters: If payee names or foreign characters show incorrectly in older spreadsheet programs, check Add a byte order mark so Excel shows Hindi and other scripts correctly.

Authoritative specifications

The Open Financial Exchange specification is maintained by the OFX Consortium. Banking and credit card transaction aggregates follow the OFX 1.6 and 2.2 Standards.

Tags

ofx, qfx, qbo, bank statement, csv, excel, quicken, quickbooks, accounting, transactions

Add files while working

After selecting files, you can still drop more files into the visible drop area or choose Add files. They join the existing list for the next run.

Open Convert OFX to CSVTurn OFX, QFX and QBO bank statements into clean spreadsheets.Open tool