Skip to content
Your files never leave your device. Converted in your browser, never uploaded.How
Convert a file
Menu

into for Excel

FileInto turns a QuickBooks .QBO bank download into a CSV you can open in Excel or Google Sheets, in your browser. Nothing is uploaded.

  • Never uploaded, stays on your device
  • Free preview
  • Opens in Excel and Google Sheets
Drop your QBO file hereQBO, QFX or OFX file downloaded from your bank or card website.Stays on your device. Never uploaded.

Have a different file, or need a different one? Click or above.

How to open the CSV in Excel or Google Sheets

Excel

  1. Double-click the .csv file from FileInto, or open Excel and choose File, then Open.
  2. Each transaction is one row: Date, Description, Amount, Memo and Check number.
  3. To keep working in Excel, choose File, then Save As, and pick Excel Workbook (.xlsx).

Google Sheets

  1. Open a new spreadsheet and choose File, then Import.
  2. Choose Upload and pick the .csv file from FileInto.
  3. Choose Replace spreadsheet, then Import data.

What FileInto looks for in your file

ColumnExamplesNotes
Transactions<STMTTRN> ... </STMTTRN>Every transaction in the file. Older SGML files (OFX 1) and newer XML files (OFX 2) both work.
Date and amount<DTPOSTED>20261003, <TRNAMT>-5.75The posted date and the signed amount, exactly as your bank wrote them. No date or sign settings to check.
Payee and memo<NAME>, <MEMO>Kept in full, each in its own column.
Account<ACCTID>, <ACCTTYPE>, <CCACCTFROM>Sets the account type (checking, savings or credit card) and the last 4 digits for you.

Problems and fixes

Excel shows the amounts as text
Select the Amount column and choose Data, then Text to Columns, then Finish. Excel turns them back into numbers.
Dates show as #######
The column is too narrow. Double-click the line between the column letters to widen it.
FileInto says it couldn’t read the file
Open the file in a text editor. A real bank download starts with OFXHEADER or <OFX>. If it starts with something else (a web page, an error), download it from your bank again.
Some transactions are missing
FileInto converts every transaction in the file. Check the date range you picked on your bank’s download page; many banks cap one download at 90 days.

Questions

How do I open a QBO file in Excel?
Excel can’t open QuickBooks (.qbo) files as a table. Convert it to CSV here, then open the CSV in Excel: one row per transaction with date, description, amount, memo and check number.
Is my QBO file uploaded?
No. FileInto converts it inside your browser tab. Your file never reaches our servers, and nothing about it does either: not its name, its size or how many rows it has.
Which files work?
QBO, QFX and OFX downloads from any bank or card, old or new. They all hold the same data, so the same converter reads them.
Are the amounts signed?
Yes. Money out is negative and money in is positive, exactly as your bank wrote them.
Can I get a QuickBooks file instead?
Yes. Switch "Save as" to QBO for QuickBooks.
What are the limits?
Files up to 25 MB. Every file gets a full preview free. Downloads up to 25 transactions are free, no account needed; a Day Pass ($9 for 24 hours) or Unlimited ($7 a month) has no row limit. It works in current versions of Chrome, Edge, Safari and Firefox, on computers and phones.

Related converters

Guides: How to open a QBO, QFX or OFX file · What is a QBO file?