Every way to get QuickBooks data into Excel, including the Spreadsheet Sync feature locked to the priciest plan and the report headers that break pivot tables.
There are three ways to get QuickBooks data into Excel: the built-in Export to Excel button on every report, the Spreadsheet Sync add-in that Intuit reserves for its most expensive plans, and connector add-ins that refresh on a schedule. The export button is fine for a one-off. The pain starts when the same report has to land in the same workbook every week, formatted the same way, without anyone doing the clicking. Here is every method, with the limits Intuit's own docs skip.
Method 1: The built-in export (QuickBooks Online, any plan)
For a single report: open Reports, run the report you want, set the date range and columns, then click the Export icon and choose Export to Excel. QuickBooks downloads an .xlsx with the report formatting baked in.
For lists and bulk data: click the Gear icon, then Export Data. Pick the reports and lists (customers, vendors, chart of accounts) and QuickBooks bundles them into one download.
The catch: every export is a frozen snapshot. The headers arrive as merged cells with the company name and date range stacked above the data, subtotal rows sit inside the data range, and both break pivot tables and VLOOKUPs until you clean them up. Do that cleanup weekly and it stops being a small task.
Method 2: QuickBooks Desktop's Report Center
Desktop is more spreadsheet-friendly than Online. Open Reports, then Report Center, run the report, click the Excel dropdown and choose Create New Worksheet or, the underrated option, Update Existing Worksheet, which pushes fresh numbers into a workbook you already formatted. List windows (Items, Chart of Accounts) have their own Excel dropdown at the bottom of the page.
The catch: Windows only, and the update option needs the workbook to have been created by a QuickBooks export in the first place. If your firm is migrating to QuickBooks Online, note that update-in-place does not exist there.
Method 3: Spreadsheet Sync (the official add-in, with a plan gate)
Intuit's own Excel add-in pulls reports and lists into Excel and can push edited data back into QuickBooks. It is genuinely useful, and that is why it is gated: Spreadsheet Sync is included only with QuickBooks Online Advanced and Accountant. On Simple Start, Essentials, or Plus the menu item simply is not there.
To use it on Advanced: Reports, then Spreadsheet Sync, sign in inside the Excel add-in pane, pick a report, and select Run report in Excel. Refresh is manual, from inside the add-in.
The catch: upgrading from Plus to Advanced roughly triples the subscription price just to get the add-in. If reporting in Excel is the only reason to upgrade, a connector is far cheaper. We wrote the same analysis for Sheets users in QuickBooks Not on Advanced?, and the plan math is identical for Excel.
Method 4: Brooked for Excel (scheduled, any plan)
Brooked for Excel is an add-in that connects QuickBooks Online on any plan, pulls the report or raw data you choose into the worksheet, and keeps it current. It runs inside Excel's ribbon, works in desktop, Mac, and Excel on the web (where ODBC-based methods cannot), and includes an AI analyst you can ask questions like "which customers are 60+ days overdue" in plain English.
Honest framing: Excel support is in beta. Manual imports and the AI analyst work today; scheduled refresh is rolling out through the beta. The Google Sheets version of the same connector is fully live, so the QuickBooks plumbing itself is mature.
Setting up the QuickBooks connection
Open Brooked in the Excel ribbon, choose QuickBooks as the source, and sign in with Intuit OAuth. Pick the report or entity (invoices, P&L, customers, AR aging), choose the date range, and import into the active worksheet. No tokens to paste and no CSV in between.
Brooked AI, QuickBooksMethod comparison
| Method | Cost | Works on | Refresh | Best for |
|---|---|---|---|---|
| Export to Excel button | Free, any plan | Any Excel | Manual re-export | A one-off report snapshot |
| Desktop Report Center export | QuickBooks Desktop | Windows Excel | Update Existing Worksheet | Desktop firms with report workbooks |
| Spreadsheet Sync | QBO Advanced / Accountant only | Windows & Mac desktop Excel | Manual refresh in add-in | Teams already paying for Advanced |
| Brooked for Excel | Free during beta | Desktop, Mac & web Excel | Scheduled (rolling out in beta) | Live reports on any QBO plan |
What finance teams build with this
- Monthly close packet: P&L, balance sheet, and cash flow refreshed into one workbook
- AR aging in the columnar 30-60-90 format QuickBooks cannot produce natively
- Multi-company consolidation: several QBO files landing in one workbook, one tab each
- Budget vs actuals: live actuals next to the budget model already in Excel
- Commission calculations from invoice data, without re-exporting every cycle
Troubleshooting common issues
Related Articles
- How to Connect Airtable to Excel
- How to Connect QuickBooks to Google Sheets
- QuickBooks Not on Advanced? Here's How to Get Your Data into Google Sheets Anyway
Frequently asked questions
Can QuickBooks be converted to Excel?
Any report or list can be exported. In QuickBooks Online open the report and use the Export icon, then Export to Excel. For lists like customers or the chart of accounts, use the Gear icon, then Export Data. There is no way to convert a whole company file into a single workbook in one click; you export report by report, which is why teams that need many reports automate it.
Why does QuickBooks not let me export to Excel?
The usual causes: the report is still loading when you click Export, the browser is blocking the download popup, or in Desktop the Excel option is greyed out because QuickBooks cannot find a supported Excel install. In QBO, try a different browser or an incognito window first. In Desktop, update QuickBooks and confirm Excel is installed as a desktop app, not just Microsoft 365 on the web.
Does QuickBooks have an official Excel add-in?
Yes, Spreadsheet Sync, but it is only included with QuickBooks Online Advanced and Accountant. On Simple Start, Essentials, or Plus the feature does not appear. That plan gate is the main reason third-party connectors exist for QuickBooks reporting in Excel.
Can I refresh QuickBooks data in Excel automatically?
Not with the built-in exports; each one is a frozen snapshot. Spreadsheet Sync refreshes when you click refresh inside the add-in. For hands-off scheduled refresh, you need a connector add-in. Brooked pulls QuickBooks reports into Excel on a schedule, so the workbook is current when you open it.
How do I export all my transactions from QuickBooks to Excel?
Run the Transaction Detail by Date report (or Transaction List by Date), set the date range and columns, then export it. That report is the closest thing QBO has to a raw transaction dump. Large ranges can time out in the browser, so split by quarter if the export hangs.
Do exports work the same in QuickBooks Desktop and Online?
No. Desktop exports from the Report Center with Excel dropdown options including Update Existing Worksheet, which can push new numbers into a workbook you already formatted. Online exports a fresh file every time and has no update-in-place option. If you moved from Desktop to Online, that missing update option is what changed your workflow.
Get live QuickBooks data in Excel, on any plan.
Brooked for Excel is in beta and free to try. Using Google Sheets instead? Read the Sheets version of this guide.
See Brooked for Excel →
