How to Convert Qbw to Xls

By Matthew Burley

Quickbooks is an application for managing financial and accounting information for small businesses. All of the data for Quickbooks company files are stored in files of the type .qbw. Unfortunately, this file format is only compatible with the Quickbooks application. Microsoft Excel is a spreadsheet application that can also be used to store data. Structurally, both applications utilize similar formats. For this reason, it is possible to convert Quickbooks .qbw company files to Excel files of the type .xls.

Step 1

Click the "Start" button in the lower left corner of the screen, then click the "All Programs" option.

Step 2

Scroll to the "Intuit" folder and click it, then select the "Quickbooks" program.

Step 3

Select the Quickbooks company file containing the data you wish to export, then click the "Open" button. Type a password if your company file requires it.

Step 4

Click the "Customers", "Vendors" or "Employees" link at the top of the screen, then select the "Customer Center" option.

Step 5

Select the "Excel" option at the top of the screen, then choose the "Export to Excel" option.

Step 6

Select a location for the exported file, then type a name for it into the "File Name" field and click the "Export" button.

Tips & Warnings

  • To convert a Quickbooks report to Excel, click the "Reports" tab at the top of the screen, then select your desired report. Wait for the report to populate, then click the "Export" button. Type a name for your report, choose a location for the output file, then click the "Export" button.