How to Export and Open QuickBooks Data in Excel

Last reviewed 2026-07-17

When you need to analyze your financial data, build custom reports, or share information with an accountant, moving that data into a spreadsheet is often the best approach. However, a QuickBooks Desktop company file (.QBW) is a proprietary database, not a standard document. You cannot simply drag and drop a .QBW file into Microsoft Excel and expect it to open.

To open your QuickBooks data in Excel, you have to export it properly. Here is how to do it safely without risking damage to your company file.

Exporting Built-in Reports

The easiest and safest way to get your data into a spreadsheet is by exporting an existing QuickBooks report. This method preserves your file's integrity while giving you fully formatted data.

1. Open your company file in QuickBooks Desktop.
2. Go to the Reports menu and select the report you want to analyze (for example, Profit and Loss, or Balance Sheet).
3. At the top of the report window, click the Excel drop-down arrow.
4. Select Create New Worksheet (or Update Existing Worksheet if you already have a spreadsheet set up).
5. Click Export. Excel will open automatically with your data formatted and ready for review.

Exporting Your Lists

If you need raw data rather than a formatted financial summary—such as a list of your customers, vendors, or inventory items—you can export these lists directly.

1. Go to the Lists menu and open the list you need (e.g., Customer Center or Item List).
2. Click the Excel drop-down arrow at the top of the list window.
3. Choose Export All Contacts or Create New Worksheet.
4. Review the export options and click Export to generate the spreadsheet.

Using the Intuit Export Utility (IIF)

For bulk exports of transactions and lists, QuickBooks uses a format called Intuit Interchange Format (.IIF). You can access this by going to File > Utilities > Export > Lists to IIF Files.

Keep in mind that while IIF files are powerful, they can be difficult to map correctly in Excel without prior experience. For routine data analysis, sticking to the standard report and list exports is highly recommended.

A Note on Direct File Conversion

Exporting data directly from QuickBooks is standard practice. However, if your company file is damaged, locked, or completely inaccessible, the built-in export tools will fail. In these situations, you need a direct database extraction. If you are trying to salvage records from an unreadable file, our team offers professional QuickBooks data recovery services that can extract your lists and transactions directly from the database and convert them into a usable Excel format.

Avoiding Data Corruption

Never attempt to open your .QBW file directly in Excel by changing the file extension. Forcing a proprietary database into a program it wasn't built for will scramble the data and can permanently corrupt your company file. Always use the export tools inside QuickBooks, or rely on a dedicated extraction tool if the file is damaged.