QuickBooks Data Export to Excel: Steps and Options

How-to basics · Updated November 21, 2026

To export QuickBooks data to Excel, open the report or list you need and choose its Excel export option; in QuickBooks Online, you can also use Settings > Export data for a broader download of reports and lists. QuickBooks Desktop has a separate report workflow: open the report, then choose Reports > Excel > Create New Worksheet. The best route depends on whether you need one report, a set of company data, or a reusable spreadsheet.

What a QuickBooks export contains

An export copies selected QuickBooks information into a file Excel can open, usually an Excel workbook or a spreadsheet-friendly format such as CSV. It is a snapshot of the data at the time of export, not a live connection between the accounting file and Excel. If transactions change later in QuickBooks, the exported workbook does not update automatically; export it again when you need current figures.

The information available depends on the export method and the report or list. A profit and loss report, for example, presents summarized income and expenses for a chosen period. A transaction detail report shows individual entries, while a customer list contains contact or account information rather than a complete history of customer activity. Choose the source that matches the question you want the spreadsheet to answer.

  • Reports are useful for balances, totals, and transaction details arranged according to QuickBooks accounting rules.
  • Lists are useful for working with records such as customers, vendors, products, and services.
  • CSV files contain rows and columns of text-like data and may need formatting in Excel. They generally do not preserve workbook features such as multiple sheets or formulas.

Export a report from QuickBooks Online

For a single report in QuickBooks Online, open the report, set its period and other filters, and then use the export control near the top of the report. Depending on the current interface and report, this may appear as an Export icon or an Export option; choose the Excel destination when it is offered. QuickBooks downloads a file that you can open or save and then work with in Excel.

  1. Go to Reports and open the report you need, such as Profit and Loss, Balance Sheet, or Transaction Detail by Account.
  2. Set the reporting period, accounting method, columns, and available filters. Review the displayed report before exporting.
  3. Choose the report’s export control and select the Excel option. If Excel is not offered for that particular view, check whether another available export format will meet your needs.
  4. Open the downloaded file in Excel and save a working copy as an Excel workbook if you plan to add formulas, formatting, or additional sheets.

Doing the date and filter work before exporting is important. For example, if you need expenses for one department, export a report filtered to that department rather than exporting a company-wide total and trying to infer the department breakdown later. Report names and controls can differ by subscription, permissions, and interface updates, so a particular report may not offer every option.

Export more than one report or list in QuickBooks Online

When you need a broader set of company information, QuickBooks Online provides an Export data area. In the standard interface, open Settings (the gear icon) and choose Export data. The page provides report and list export choices; select the relevant tab, set any available date range or other options, and follow the on-screen instructions to export. The exact choices and file contents can vary with the QuickBooks version and user access.

This broader tool is different from exporting one open report. It can save time when preparing a spreadsheet-based review of multiple reports or lists, but it does not mean that every detail in the company file will be reproduced in one Excel sheet. Check the downloaded files and confirm that the particular records and date range you need are present. If the export option is missing, ask a company administrator to review your permissions or check the product’s current help guidance.

For a one-off analysis, exporting an individual report is often easier because you can choose the report’s filters and inspect its totals first. For a recurring handoff or a wider review, the bulk export can be more convenient, but it may create several files that you will need to organize in Excel.

Export a report from QuickBooks Desktop

In QuickBooks Desktop for Windows, open the report and use Reports > Excel > Create New Worksheet. In the Excel export window, choose whether to create a new worksheet or use an existing workbook if that option is available, then follow the prompts. QuickBooks may open Excel with the exported report, or create a file you can open afterward, depending on your software setup.

Before exporting, set the report dates and customize its columns or filters in QuickBooks. The resulting worksheet reflects the report as displayed; it is not a live link that recalculates from the company file. For lists, use the relevant list or center and look for its Excel or export command. Desktop editions and list types do not all use identical controls, so consult the on-screen options rather than assuming the report command applies to every list.

QuickBooks Desktop for Mac has a different interface and may not have the same Windows ribbon or menu sequence. Follow the export options shown in the Mac edition rather than using Windows instructions verbatim. In either edition, check that Excel is installed and available to QuickBooks if the export workflow is designed to open Excel directly.

Choose the right export method

The most useful choice is usually determined by the shape of the data you need, not simply by the number of rows. A financial statement gives clear account totals, while a transaction-level report is better for tracing how a total was formed. Exporting a list is appropriate when you need the underlying records, but it is not a substitute for a reconciled accounting report.

  • Use a standard report when you need a familiar accounting view, such as income and expenses by month.
  • Use a customized detail report when you need to inspect individual transactions or filter by account, customer, class, or another available field.
  • Use a list export when the task concerns records such as vendor names or product details, rather than posted financial activity.
  • Use the broader Online export when you need several available reports or lists for a wider review and are prepared to manage multiple downloaded files.

For example, a manager asking why travel spending rose may need a transaction detail report filtered to travel accounts and the relevant months. A staff member updating vendor contact details needs a vendor list instead. Exporting the wrong source can produce a spreadsheet that looks complete but cannot answer the actual question.

Work with the exported file in Excel

First preserve the downloaded file and make a separate working copy before rearranging or deleting rows. Check the sheet name, reporting dates, column headings, and total against the QuickBooks report. If a report has multiple sections or columns, confirm that Excel has retained the structure you expect. Do not assume that a number formatted as currency in QuickBooks will have exactly the same display format in every export.

Excel may interpret dates, account numbers, or long identifiers differently from QuickBooks. CSV files are especially worth checking: opening a CSV directly can cause Excel to infer data types, and saving it may change the file format. If a column must remain text, import the file through Excel’s data import tools and set that column’s type deliberately. For a normal Excel workbook, use Save As and choose an Excel workbook format such as .xlsx; retain the original export if you may need to compare it later.

When combining exports, make sure the columns represent the same things and cover compatible periods. Two reports with a column both labeled “Amount” might use different accounting bases, filters, or levels of detail. Keep a note of the QuickBooks report name, date range, and filters in the workbook so another reader can understand what the numbers mean.

Common export problems and fixes

If no Excel option appears, confirm that you have opened a report or list that supports that export, and look for an export menu or icon rather than a button labeled “Excel.” Some interfaces offer different formats for different report types. Also check that your account has the necessary permissions and that your browser allows the downloaded file to be saved.

  • The downloaded report is incomplete: Recheck the date range, filters, accounting method, and hidden or collapsed report sections before exporting again.
  • Excel will not open the file: Confirm the downloaded file extension and try opening Excel first, then use its Open command to select the file. Do not rename a file extension as a substitute for converting its format.
  • Columns look wrong: For CSV, import the data and set appropriate column types; for an Excel workbook, inspect column widths, number formats, and any report layout options.
  • Totals differ from another spreadsheet: Compare the report period, cash or accrual basis, filters, and whether both files include the same transaction types.
  • The bulk export is unavailable: Check permissions, product edition, and the current QuickBooks help information; available tools can vary.

A common misconception is that exporting to Excel changes the accounting records in QuickBooks. A standard export downloads a copy; editing that copy does not ordinarily post those edits back into the books. Treat the spreadsheet as an analysis or reporting file, not as a synchronized replacement for QuickBooks.

Security and good recordkeeping

QuickBooks exports can contain sensitive financial, customer, or employee information. Save them only to approved locations, limit access to people who need the data, and follow your organization’s retention and sharing rules. Avoid sending an unprotected file through an unsuitable channel, especially if it includes personal or banking details. Deleting a local copy may not remove copies saved in email, cloud storage, or backups.

Keep the original export unchanged when it is being used as a source for analysis or review. Record who created it, when it was downloaded, and which report settings were used. If you are preparing financial statements or figures for an external party, reconcile the spreadsheet with QuickBooks and follow the organization’s review process; a spreadsheet’s appearance alone does not establish that its data is complete or correct.

Frequently Asked Questions

Can I export all QuickBooks data to one Excel file?

Not necessarily. QuickBooks Online’s Export data area can provide multiple reports and lists, but the result may be several files, and available content varies. A single report export contains only that report’s data, not the entire company file.

Does a QuickBooks Excel export update automatically?

No. A downloaded export is generally a snapshot, not a live connection. If transactions change in QuickBooks, export the report or data again to get an updated copy.

Can I export QuickBooks transactions to Excel?

Yes, where a suitable transaction report is available. Open a transaction detail report, choose the needed period and filters, and use its Excel export option. The exact report name and available fields depend on the QuickBooks edition and setup.

Why did Excel change dates or account numbers in my export?

Excel can infer data types when opening spreadsheet files, particularly CSV files. Import the data with the relevant columns set to text or the intended date format, and check identifiers and dates before relying on the worksheet.

Can I edit the exported spreadsheet and put the changes back into QuickBooks?

Editing an exported report does not normally update QuickBooks. If you need to change accounting records, make the change through an appropriate QuickBooks workflow or supported import process, and verify the result in the company file.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.