What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/Export QuickBooks to Excel, One Report or All
QuickBooks + Excel

Export QuickBooks to Excel: One Report, a List, or the Whole File

Your accountant wants the P&L as a spreadsheet by Friday, or the bank wants a year of transactions. QuickBooks Online puts an Excel option on every report, has a bulk export for everything at once, and can email a saved report on a schedule. On Desktop, a grayed-out Excel option is nearly always about the Excel install, not your file.

Export one report

Newer report view: open the report from Reports, Standard reports, set the dates, then:

Export/Print Export to Excel

Classic report view: the same report shows an export icon at the top instead:

Export icon Export to Excel

Every report and list at once, as Excel files inside one .zip:

Settings ⚙ Export data

Which export matches what you were asked for

What you need Use this Watch for
One report for your accountant or lender Export to Excel from the report itself, after you've set the date range, filters and columns. The file is what's on screen. If the report's set to cash basis and your accountant works in accrual, the spreadsheet will be too.
Every transaction for a year: tax prep, an audit, leaving QuickBooks Settings ⚙, Export data. Pick a date range on the Reports tab and switch off anything you don't need. Date ranges come from a preset list. For an odd fiscal year, run Transaction Detail by Account with your own dates and export that instead.
Your customer, vendor or product list Export the matching list report. Products: Products & services, More, Run reports, then Export/Print. Customers: see exporting the customer list. The list screen shows a few columns. For emails, addresses or terms, customize the contact list report before you export.
Estimates or purchase orders Export from the sales or expense transactions list, filtered to that type. Export data leaves these out, because they don't post to any account.
The same report, to the same people, every month Save it as a custom report, turn on Set email schedule and tick Attach the report as an Excel file. Not on Simple Start. Each schedule sends one report in QuickBooks' own layout. Custom reports covers saving one.
An Excel workbook that refreshes from QuickBooks Spreadsheet Sync, Intuit's Excel add-in. Only on QuickBooks Online Advanced and for accountant users. On other plans, someone re-exports by hand.

When the Excel file won't come out right

Most of these are Desktop problems. QuickBooks Online builds the file on Intuit's side, so it doesn't care what's installed on your computer.

Export to Excel is grayed out in Desktop

How you'll know: The option shows on the report but won't click, or Desktop says it can't find Excel.

Fix: Desktop hands the report to the copy of Excel on that machine, so it needs a supported, activated version installed. Repair or reinstall Office, restart the computer, then open QuickBooks again.

A big report crawls or freezes on the way out

How you'll know: A multi-year transaction report sits at the progress bar for minutes.

Fix: Cut the date range and export it a quarter at a time. In Desktop, choosing a .csv file instead of a new worksheet is usually much quicker.

You only get a CSV

How you'll know: The download ends in .csv and opens without any formatting.

Fix: Open it in Excel and use Save As to save a copy as an .xlsx workbook. The data's identical; only the file type changes.

Excel treats the amounts as text

How you'll know: SUM returns zero, or numbers sit on the left with a small green triangle.

Fix: Select the column and use Excel's Text to Columns with the default settings, or multiply by 1. Then the formulas work.

The investor pack that used to eat Monday morning

A business with outside investors who expected a profit and loss and an AR aging report every Monday, in Excel, in the finance lead's format.

Before

Someone logged into QuickBooks first thing Monday, exported both reports, and pasted them into the workbook the finance lead had designed.

Then they emailed it to the distribution list. Roughly forty minutes, and it had to be done before anything else.

QuickBooks could email one report on a schedule, but not both reports merged into that workbook.

After

n-frames built a scheduled job that pulls both reports from QuickBooks every Monday morning and drops the figures into the same template.

The finished workbook goes to the same people. Nobody logs in to make it happen.

If a number looks wrong, it gets questioned after it lands, not held up while someone builds the file.

Questions people ask

Why is Export to Excel grayed out in QuickBooks?

In QuickBooks Desktop it almost always means Desktop can't find a licensed, supported copy of Excel on that computer. Repairing or reinstalling Office fixes most cases. QuickBooks Online doesn't have this problem, because its export doesn't use the Excel on your machine at all.

Why is exporting to Excel from QuickBooks so slow?

Size, mostly. A report covering years of transactions takes a while, and Desktop is slower because it builds the workbook through Excel on your own machine. Narrow the dates or filters, or export to .csv, and it speeds up.

Can QuickBooks only export to CSV, not Excel?

Some screens and older versions only offer CSV. Open the file in Excel and save it as .xlsx. You lose nothing except the original formatting, which a CSV never had.

Can I export all my QuickBooks data at once instead of one report at a time?

In QuickBooks Online, yes: Settings ⚙, then Export data gives you one .zip with a separate Excel file per report and list. Estimates, purchase orders, attachments and customer statements are exported separately, from their own screens.

How do I export a QuickBooks Desktop report to Excel?

Open the report and use the Excel button along the top. Create New Worksheet makes a fresh file; Update Existing Worksheet refreshes one you exported before, keeping your formatting where it can.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.