Free QBO to Excel Converter for QuickBooks Files
Turn a QuickBooks Web Connect (.QBO) bank or credit-card download into a real Excel workbook: one row per transaction, with the amounts written as numbers Excel can total without a re-type.
A .OFX or a Quicken .QFX download is read the same way, because all three are Open Financial Exchange under three different extensions. Nothing is uploaded: the file is read in your browser and the workbook is written there.
Choose your file
Drop your .QBO or .OFX file here
Your file is never uploaded. We never receive it or store it.
Three Things Worth Knowing First
- A download holding more than one statement is read into a single table rather than a sheet per account.
- An empty field is left out of the workbook rather than written as a blank, so a gap in a column is a gap in what the bank sent.
- Keep the original .qbo. The workbook is a copy made for reading, and a bank feed later still wants the download itself.
Important: “QBO file” does not mean your QuickBooks Online company. This tool reads QuickBooks Web Connect (.QBO) bank and credit-card transaction files, the kind your bank publishes for a bank feed. It does not export a QuickBooks Online company, a Desktop company file, invoices, bills, payroll or your chart of accounts.
Why a .QBO Will Not Open in Excel
Converting a QBO file to Excel needs a reader, because a .qbo is not tabular text. It is Open Financial Exchange: a tag-based format where one transaction is a nested STMTTRN block spread over six or more lines. Rename it .csv and Excel shows you a single column of tags. This page reads that structure and writes one row per transaction instead.
What comes back is a spreadsheet file rather than delimited text with a spreadsheet extension on it, and every cell is typed before Excel ever opens it. Exactly two columns arrive as numbers, and the rule that decides which is one line long: a header whose name ends in AMOUNT is a number, and nothing else is.
The date is deliberately not one of them. It arrives as 3/2/2026 rather than as the raw OFX timestamp, and it is written as text, because the workbook carries no cell formats at all. Keeping everything outside the two amount columns as text is the same decision that stops a check number losing its leading zero on the way in.
| Column | Example | Arrives as |
|---|---|---|
| Txn | 1 | text |
| TRNS.DATE | 3/2/2026 | textnot an Excel date |
| TRNS.ACCNT | Checking | text |
| TRNS.NAME | CITY POWER AUTOPAY | text |
| TRNS.AMOUNT | -89.50 | NUMBERtotals as it stands |
| TRNS.DOCNUM | 0042 | textleading zero survives |
| SPL.ACCNT | Uncategorized Expense | text |
| SPL.AMOUNT | 89.50 | NUMBER |
One rule decides all of it: a header whose name ends in AMOUNT is written as a number, and nothing else is. The workbook carries no cell formats, so there is no third answer and no date type to arrive in.
What You Get Back
A QuickBooks Web Connect to Excel conversion returns bookkeeping entries, not statement lines, because it runs through double-entry.
Two Account Columns
Your bank account is named on one side of the row and a category on the other, because every transaction is written as a balanced pair rather than as a single line. The category arrives as Uncategorized Expense for money out and Uncategorized Income for money in, unless you name your own before you convert.
The Amount Sits in the Row Twice
TRNS.AMOUNT carries the figure your bank stated. SPL.AMOUNT carries the same figure negated, on the category's side. Total one column and you have the period's net movement. Total both and you have zero, which is the arithmetic working rather than a fault in the file.
The Headers Are Field Names
TRNS.DATE, SPL.ACCNT and the rest are QuickBooks IIF field names rather than Date and Category, because the reader builds an accounting document on the way through and nothing is renamed for presentation. Rename the header row once in the workbook and the sheet reads the way you want it to.
How to Convert QBO to Excel
Four steps. Two of them are settings you can leave exactly as they arrive.
Drop the Bank Download
A Web Connect download from your bank or card issuer, which is the file published for a bank feed rather than anything QuickBooks produced. A plain .ofx, a Quicken .qfx, or a .txt holding one of those goes through the same reader.
.qbo · .ofx · .qfx · .txt
Name Both Sides of the Entry
Three names decide what the two account columns say. One is the bank or credit-card account the transactions belong to. The other two are the categories money out and money in post against. Type the names your own books use and both columns are written with them before the workbook is built.
account · money out · money in
Choose Where the Payee Comes From
The payee column is taken from each transaction's name field, or from its memo field instead, which matters when your bank puts the useful text in the second one. The bank's own transaction id stays off unless you ask for it, and asking appends it to the end of the memo in square brackets.
name or memo · id off by default
Download One File
The transaction count and any warnings are listed before the file is written, so a period that read short is visible here rather than after the workbook is already open. There is no output to pick and no layout to choose: one .xlsx comes back.
one sheet, or three if you keep the raw tables
The Tenth Workbook Is No Faster Than the First
One workbook is a few minutes. The tenth is the same few minutes over again.
| Need | Free converter | Autymate |
|---|---|---|
| A single download you want to look at | Drop it in, read the count, open the workbook | Nothing here is worth arranging for one file |
| The same download every period | The three account names typed in again on every pass | Named once, then written the same way each period |
| Headers someone else has to read | The header row renamed by hand in every workbook | Column names agreed once and applied on every run |
| Transactions that have to be coded, not only read | Every row arrives against a placeholder category | Coding rules held between runs where the source supports them |
| A period nobody downloaded | Absent from the workbook, with nothing in it to say so | Checked for gaps before the period is called done |
You May Already Have a Shorter Route
Two routes that skip a QBO to Excel converter entirely, and the case where converting is right.
QuickBooks Desktop Exports to Excel Itself
If the transactions are already in your company file, Intuit's own report export sends them to a worksheet and there is nothing here to convert. That route is shorter, and it keeps your account names and your coding, which a converter reading a bank download has no way to know.
Web Connect Already Takes This File
If the destination is a bank feed rather than a spreadsheet, .QBO is the format Intuit publishes for exactly that. The file you already hold goes in as it stands, and this page is a detour.
Convert When the Destination Is Not QuickBooks
A workbook earns its place when a person has to read the period: a review, an analysis, a handoff to an accountant, or a month that can no longer be downloaded. Where the only copy left is the printed statement rather than the bank's download, reading the statement itself is the shorter way round.
What the Converter Decided for You
Four decisions made inside the file, each worth knowing before the workbook is used for anything.
The Date Is a Text Cell
It reads 3/2/2026 rather than the raw OFX timestamp, and it is still text, because the workbook carries no styles table and no cell in it can hold a date format. Sorting that column sorts strings, so a December row climbs above a March one. Put the period in order yourself before you trust the sequence.
The Category Is a Placeholder
Uncategorized Expense and Uncategorized Income are what the converter writes when you name nothing. They are not a reading of your chart of accounts and not a guess at what each transaction was for. Someone will recode every row, and nothing in the workbook marks which ones are still waiting.
No Transaction Id Unless You Ask
The bank's own id is off by default, and switching it on appends it inside the memo in square brackets rather than giving it a column of its own. Where matching rows between two files is the actual job, the QBO to CSV Converter is the page that treats that id as the point.
A Clean Open Is Not a Check
Nothing in the workbook has been compared with anything: not your books, not the paper, not the period before it. A file that opens without complaint has only been read. Whether every transaction arrived, and whether any of them is coded correctly, are two jobs that have not started.
Every Account Opens Its Own Workbook
Opening one download to look at it is a viewer's job, and a .QBO file viewer is what most people want when they land here. One account is one file and one workbook. What multiplies is everything wrapped around it, once every operating account, every card and every location produces one of these each period.
- A separate download per institution and per card, each arriving named by the bank rather than by the account it covers
- The same three account names typed into the panel again for every file and every period
- Separate company files and separate entities, each wanting the accounts named the way that entity's books name them
- A period pulled twice, or pulled after the close, with a workbook that reads identically either way
- A location opens, and nobody knows which of its accounts publish a Web Connect download until someone checks
- Years of back periods read in one planned pass rather than one workbook at a time
Common Questions
What people ask before they trust a converter with their accounting system.
Not as a table. Excel will open a .qbo as text and show you one column of OFX tags, because the transactions are nested blocks rather than rows, and renaming the file to .csv changes nothing: the extension is not what makes a file tabular. The request behind “open QBO file in Excel” is really a request for a reader, and that is what this page is. It follows the structure and writes the table before Excel is involved at all.
The .QBO file extension, which is QuickBooks Web Connect: the transaction file a bank or card issuer publishes so accounting software can take a feed. One file holds one account's transactions for one period and nothing else, which is why it can be read quickly and why it cannot tell you anything about the rest of your books.
Yes. Intuit publishes .QBO as the file type QuickBooks Desktop bank feeds accept, and Desktop imports one from its Bank Feeds menu with nothing converted first. The limit is what a Web Connect file can carry: one account, one period, transactions only. It brings no chart of accounts, no invoices, no payroll and no history beyond what the bank put in it.
Yes. Desktop sends a report to a new or an existing worksheet from the report window itself, and Intuit documents the steps. The two routes answer different questions, which is worth knowing before you pick one: an export shows what your books say about a period, and this converter shows what the bank sent. Where those two disagree, having both is the point.
Yes. It is Office Open XML, the same thing Excel writes when you save, packaged as a genuine .xlsx rather than a text file wearing the extension. Excel 2007 and later opens it with no compatibility prompt, as do Google Sheets, LibreOffice and Numbers. What it deliberately does not carry is formatting: no styles, no column widths, no frozen header row. The structure is written for you and the presentation is yours.
No. Everything happens inside the browser tab: the .qbo is parsed there, the workbook is assembled there, and the download comes off your own machine. No copy is sent anywhere, so there is no account to create, no file to delete afterwards and nothing of yours on a server to ask about later.
Written and maintained by The Autymate integrations team. We build and run accounting integrations for multi-location franchises, ISVs and bookkeeping firms: QuickBooks Desktop and Online, POS, payroll and ERP. These converters exist because we kept writing the same ones for customers, and there was no reason to keep them to ourselves.
Last reviewed
When Every Period Starts With the Same Typing
One download opened as a workbook is a job this page finishes in a few minutes. A workbook rebuilt for every account and every period, with the same three names typed in and the same header row renamed each time, is a workflow. Tell us where the downloads start, who has to read them, and how many accounts and company files are in play.
Exact source access, fields, permissions, QuickBooks behaviour and service scope are confirmed during discovery.