Recommended Free Tools
The correct export path depends on your QuickBooks edition and the kind of information you need. In QuickBooks Online, open a report and choose Export/Print → Export to Excel. In QuickBooks Desktop for Windows, use Reports → Reports Center → Excel → Create New Worksheet; on Desktop for Mac, open the report and select Export. First decide whether you need a report, list, transaction detail, or a recurring spreadsheet connection.
Choose the right QuickBooks export
| What you need | Best starting point |
|---|---|
| Profit and loss, balance sheet, or trial balance | Open the financial report and export it |
| Sales by customer, product, or service | Open the relevant sales report, customize columns and filters, then export |
| Customer or vendor contacts | Export the list or customize a contact-list report |
| Chart of accounts | Export the Account List report |
| Products and services | Export from Products & Services or its related report |
| Individual transactions | Use a transaction-detail report; Desktop also has transaction export tools |
| Payroll information | Use the appropriate payroll report; availability varies by Desktop edition and payroll setup |
| Repeated reporting | Use saved report customizations, Desktop report updates, Spreadsheet Sync, or a vetted integration |
| Full accounting archive or migration | Preserve QuickBooks company data and required reports separately; one workbook is not a complete backup |
QuickBooks distinguishes reports, lists, and other company data rather than treating “data” as one universal export. See Intuit’s overview of these options at its QuickBooks Online export guidance.
Prepare the data before clicking Export
- Set the report period. Confirm the start and end dates, and whether the report is for a month, quarter, year, or all dates.
- Choose the accounting basis. Where the report allows it, select cash or accrual and record that choice.
- Apply filters. Check customer, vendor, account, class, location, product, transaction type, and status filters.
- Customize rows and columns. Select the fields needed for analysis and choose summary or transaction detail.
- Check grouping and inclusions. Review subtotals, negative-number display, inactive accounts, voided transactions, and other included records.
- Run or refresh the report. Compare the visible totals with your expected figures before downloading.
For recurring work, save the customization after confirming the layout. A focused report usually requires less cleanup than exporting a broad dataset and deleting irrelevant columns in Excel.
Export a QuickBooks Online report to Excel
- Sign in to QuickBooks Online and open Reports.
- Search for the report by name or browse the report list, then open it.
- Set the date range, accounting method, filters, and columns.
- Select Export/Print.
- Select Export to Excel.
- Save the downloaded workbook in a known accounting folder.
- Open it in Excel and compare its totals and date range with the report shown in QuickBooks.
Intuit documents this workflow at Export reports to Excel in QuickBooks Online. If Excel opens the file in Protected View and appears to show missing information, select Enable Editing and inspect the workbook again.
#1 Best Overall
Export QuickBooks Online lists and customer data
Direct customer export
- Open All apps.
- Choose Customer Hub → Customers & leads.
- Select the Export icon, then Export to Excel.
Customize a customer contact list
- Go to Reports → Standard reports.
- Open Customer Contact List.
- Open the three-dot menu and choose Customize.
- Under Rows/Columns, select Change columns and add or remove fields.
- Select Run report, then use the export icon and choose Export to Excel.
This lets you choose fields such as contact details instead of accepting a fixed list layout. The customer-specific instructions are in Intuit’s customer-export guide. Similar list and product/service options are described in Intuit’s list and balance-transfer guidance.
Export QuickBooks Desktop reports
Desktop for Windows
- Open the company file.
- Go to Reports → Reports Center and open the report.
- Select the Excel dropdown.
- Choose Create New Worksheet for a new workbook or Update Existing Worksheet for an existing one.
- Select Advanced if you need formatting changes. If the report has too many columns, clear Space between columns.
- Select OK or Export, then open the workbook.
Desktop can also export reports as Excel workbooks, CSV, or PDF. The Windows and Mac workflow is documented in Intuit’s Desktop export article.
When you choose Update Existing Worksheet, protect the original first: Intuit warns that updating can overwrite the existing workbook. Use a dated output filename and keep your template separate.
Refresh a Desktop report from Excel
An exported Desktop report can be updated from Excel’s QuickBooks tab by selecting Update Report. The first update may require the company file to be open so QuickBooks can establish permissions and preferences; later behavior depends on the setup.
Desktop for Mac
- Open the report.
- Select Export.
- Open the resulting workbook in Microsoft Excel or Apple Numbers.
- Use Save As to choose the desired format and location.
Intuit’s current guidance names Microsoft Excel 2016 or later, including Mac Office 365, and Apple Numbers v3.5 as compatible applications. If the wrong application opens, use the file’s Get Info → Open With setting to change the association.
Export Desktop lists, items, transactions, and payroll
For master data, use the relevant center or list rather than a financial statement. In a Customer, Vendor, or Payroll Center, use the Excel dropdown to export lists or transactions. For items, choose Lists → Item List, open the Excel dropdown, and select Export all Items; then choose a new worksheet or an existing one. See Intuit’s Desktop list and Excel instructions.
Rank #3
Use a transaction-detail report when you need dates, amounts, accounts, and document-level activity. A customer or item list is master data, not transaction history, and does not preserve every QuickBooks relationship or accounting rule.
Desktop for Windows includes Excel-oriented payroll reports such as Summarize Payroll Data in Excel, Certified Payroll Report, Payroll Summary by Tax Tracking Type, Employee Time & Costs, Employee Sick & Vacation History, Direct Deposit Listing, Tax Form Worksheets, Payroll Liability Accruals & Payments, and Payroll by Department/Class. Availability depends on edition and payroll setup. Treat these files as highly sensitive because they may contain wages, tax details, hours, names, or banking-related information.
Excel or CSV?
| Choose Excel when | Choose CSV when |
|---|---|
| You need formulas, tables, charts, pivot tables, or a presentation-ready workbook | You are loading a large flat dataset into another system |
| People will review and manipulate the report manually | Excel-specific export is failing or the file is too wide |
| Multiple worksheets or report layout are useful | You want a simpler, less formatted file |
CSV generally drops formulas, formatting, multiple-sheet structure, and presentation details. Excel preserves more layout but can require cleanup before automated processing. QuickBooks Online also exposes CSV in applicable report-running workflows; Desktop documentation identifies CSV as an export format.
Clean and verify the workbook
- Confirm the report name, period, accounting basis, and filters.
- Reconcile key totals to the report still visible in QuickBooks.
- Check that dates are recognized as dates and amounts as numbers, not text.
- Inspect negative amounts, credits, hidden rows, filters, subtotals, and blank lines.
- Confirm that all expected worksheets and columns are present.
- Convert a flat range to an Excel Table when sorting, filtering, or formulas will be repeated.
- Keep the untouched export and perform analysis on a copy.
- Add a control sheet recording report name, date range, basis, filters, export date, and filename.
Troubleshoot common export problems
“The Excel file is missing data”
In QuickBooks Online, check for Protected View and select Enable Editing. Then check hidden rows, filters, and worksheet tabs.
Desktop freezes or crashes
Save a copy of the company file and workbook. Try a simpler report or CSV, confirm QuickBooks and Office are updated and compatible, and repair or reinstall software only after preserving the data. Intuit notes that Microsoft applications are not supported directly by Intuit; persistent Office problems may require IT or Microsoft support. Its troubleshooting guidance is at QuickBooks Desktop crashes when exporting to Excel.
“Too many columns”
In Desktop’s Advanced export options, clear Space between columns. If the warning remains, reduce columns or use CSV. Intuit’s older documentation also mentions fewer than 256 columns and 65,536 detail lines; these are legacy or version-dependent QuickBooks export warnings, not universal limits of modern .xlsx files.
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Figures do not match
Recheck dates, cash versus accrual, class and location filters, inactive accounts, voided transactions, summary versus detail, and whether the report was refreshed before export. Also check whether Excel formulas or filters changed what is visible.
You expected a complete backup
An Excel workbook is a snapshot, not a replacement for the company file, audit history, attachments, payroll records, or accounting relationships. For migration or cancellation, preserve the required QuickBooks data and reports using dedicated migration guidance.
One-time export versus a refreshable connection
A normal download is static. Use it for a period-end snapshot, an ad hoc analysis, or a one-off budget. For recurring dashboards or monthly reporting, consider:
- Desktop report updates: refresh an exported report through Excel’s QuickBooks tab.
- QuickBooks Online Advanced Spreadsheet Sync: a plan-dependent feature for pulling current QuickBooks data into formatted spreadsheets. Intuit describes templates for profit and loss, balance sheet, trial balance, cash flow, aging, inventory, vendor, customer, and sales reporting in its Advanced reporting-tools guide.
- Third-party connectors: evaluate supported edition, read-only versus write-back behavior, security, API limits, refresh frequency, historical coverage, deleted-record handling, pricing, and cancellation terms before connecting one.
Spreadsheet Sync is associated with QuickBooks Online Advanced; it is not a feature of every QuickBooks Online plan.
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Fix the driver behind crashes, sound loss and screen glitches3Repair Windows errors before they cause bigger problemsProtect exported financial data
- Store workbooks in access-controlled, encrypted storage.
- Use secure portals instead of ordinary email attachments when sharing payroll or banking data.
- Apply a dated naming convention and keep the original export separate from edited analysis.
- Delete temporary downloads and apply a retention period appropriate to tax, payroll, and business records.
- Restrict payroll files to people who need them.
The Bottom Line
For most one-time needs, customize the correct QuickBooks report, export it to Excel, and reconcile the workbook to QuickBooks. Use a list export for master records, CSV for flat or import-oriented data, and Desktop report updates or QuickBooks Online Advanced Spreadsheet Sync when the spreadsheet must be refreshed repeatedly.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
