QBO Export to Excel Not Working

The short answer

If the Export to Excel option is greyed out in QuickBooks Desktop, QuickBooks cannot see a copy of Excel it recognises. That is almost always a web-only Office subscription, a 32-bit and 64-bit mismatch, or an Office installation that needs repairing, not a problem with your company file.

If you are in QuickBooks Online and nothing seems to happen when you export, the file has usually been produced and handed to your browser, where a pop-up blocker or a download setting has quietly caught it.

And if what you actually have is a .qbo file that Excel refuses to open, that is not an export problem at all: it is a file format one, and it has a different answer entirely.

First, which problem do you have?

These three get described in exactly the same words and share almost nothing else. Find yours before trying anything.

The last two are the ones people most often misdiagnose, because both look like a broken export and neither is one.

Desktop: why the Excel option greys out

QuickBooks Desktop checks for a locally installed, supported copy of Excel before it offers to export to one. When that check fails the menu item is disabled rather than erroring, which is why it looks like a QuickBooks fault when it is usually an Office one.

• Office is web-only. A subscription that gives you Excel in a browser gives QuickBooks nothing to hand a workbook to. The desktop application has to be installed.
• A 32-bit and 64-bit mismatch. This one catches people out, because both halves are perfectly good software. Several users report the options coming back after reinstalling Office as 32-bit.
• The Office installation is damaged. Repairing it re-registers the components QuickBooks looks for, which is why a repair fixes this so often without anything else changing.
• Excel is not the default for spreadsheets. Setting it as the default application in Windows settings is sometimes enough on its own.
• User Account Control is set very high. Over-restrictive UAC can block the handoff between the two programs.
• The two versions are not a supported pair. Each QuickBooks Desktop release supports particular Office versions, and an old QuickBooks with a new Office is a common combination.

What to check, in order

Cheapest and least disruptive first. Most people stop at step two or three.

1. 1Open Excel on its own. If it does not launch from the Start menu, the problem is entirely Office's and QuickBooks is a bystander.
2. 2Check you have desktop Excel rather than the browser version: open it and look for a title bar and a File menu rather than a browser tab.
3. 3Update QuickBooks Desktop, then restart it fully. A supported pairing can still fail on an old build.
4. 4Run an Office repair from Windows' installed-apps settings. This is the single most commonly reported fix.
5. 5Confirm Excel is the default application for spreadsheet files.
6. 6Only then consider the 32-bit reinstall, which is disruptive and worth trying last despite being the answer surprisingly often.

Throughout this, exporting to CSV is usually still available even when the Excel option is not, and a CSV opens in Excel perfectly well. If you need the numbers today rather than the integration, that is the way round the problem rather than through it.

Online: the export goes to your browser

QuickBooks Online has no way to open Excel for you. It builds a file and hands it to the browser, so everything that can go wrong is a browser behaviour rather than an accounting one.

• A pop-up blocker caught it. Exports are frequently triggered in a way blockers treat as a pop-up. Allowing pop-ups for the QuickBooks domain is the usual fix.
• It downloaded silently. Check your downloads folder and your browser's download list before assuming nothing happened.
• An extension interfered. Ad and privacy blockers are the usual suspects; an incognito window with extensions off is a fast test.
• The session expired mid-report. A very large report that takes a while can outlive the session that requested it.

The incognito test is worth doing early, because it distinguishes an account or report problem from a browser one in about thirty seconds and needs nothing installed.

The file that opens as a wall of tags

This is the case that is not an export failure. If somebody sent you a .qbo file, or you downloaded one from your bank, and Excel either refuses it or fills a column with angle brackets, the file is doing exactly what it should. It is simply not a spreadsheet.

A .qbo is a bank statement in Intuit's Web Connect format: markup written for software to read, not a table. There is nothing to repair and no setting that will make Excel understand it. See what a QBO file is for what is actually inside one.

The confusion is entirely down to the name. QuickBooks Online is abbreviated QBO and so is the file format, and they are unrelated: one is an accounting product, the other is a statement your bank produced. Someone with a .qbo file searching for why their QBO export will not open in Excel is asking a question about two different things at once.

Why Excel complains about a file it just opened

A separate and harmless one. Exports from accounting software often produce a file named .xls whose contents are not really the old Excel binary format, and Excel notices. The warning says the format does not match the extension and asks whether you trust the source.

Opening it anyway is normal and the data will be correct. If the warning is a nuisance, opening the file and saving it as a proper .xlsx makes it go away permanently, and is worth doing before you build anything on top of the sheet.

When to stop troubleshooting

There is a point where the export is no longer the goal. If you needed the figures in a spreadsheet by this afternoon, and CSV export works, the Excel integration is a convenience you can fix another day.

The same applies in the other direction. If what you were trying to do was get transactions into accounting software rather than out of it, the export route was never the right one: bringing bank transactions into QuickBooks covers that properly, and a broken export button has no bearing on it.

And if the bank feed that would have avoided all of this has stopped updating, that is its own problem with its own causes: what to do when a bank feed stops working is the one to read instead.

Frequently asked questions

Why is Export to Excel greyed out but Export to CSV is not? Because the two do different things. A CSV is written by QuickBooks on its own, and needs nothing installed. An Excel export hands the data to Excel itself, so QuickBooks checks for a supported local copy first and disables the option when it cannot find one.

Does this mean my company file is damaged? Almost never. A greyed-out Excel option is a statement about what QuickBooks can see on your computer, not about your data. If reports open and print normally, the file is fine and the problem sits between QuickBooks and Office.

I use QuickBooks Online and nothing happens when I export. Check the browser first: look in your downloads folder and download history, allow pop-ups for the QuickBooks domain, and try again in an incognito window with extensions disabled. QuickBooks Online cannot open Excel for you: it produces a file and hands it to the browser, so that is where it goes missing.

Is a .qbo file the same as QuickBooks Online? No, and this is the most common confusion behind this question. QuickBooks Online is the accounting product. A .qbo file is a bank statement in Web Connect format, produced by your bank. They share an abbreviation and nothing else: see what a QBO file is.

Can I open a .qbo file in Excel directly? Not usefully. It is a markup document rather than a table, so Excel either refuses it or imports the tags as text alongside the figures you wanted. Converting it into a real workbook first is the way round that, and takes a few seconds.

Will reinstalling QuickBooks fix a greyed-out Excel option? Usually not, because QuickBooks is rarely the component at fault. Repairing Microsoft Office is the more targeted step and the one most often reported as the fix, since it re-registers the pieces QuickBooks looks for when it checks whether Excel is present.