How to Convert Quickbooks to Excel

Written by katrina matterhorn
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Convert Quickbooks to Excel
Save financial information in Excel from QuickBooks. (holding laptop image by Adam Borkowski from

QuickBooks is a financial and accounting software application developed by Intuit. QuickBooks may be used for entering sales receipts, tracking expenses, preparing reports, inventory management and sales tax tracking. The latest versions of QuickBooks offer features such as remote access capabilities, improved e-mail functionality with Microsoft Outlook and mapping integration through Google maps. Although QuickBooks is a popular application, many spreadsheet programs can't open it. Excel can. If you wish to convert QuickBooks to Excel, it will take a few steps to set up.

Skill level:

Other People Are Reading


  1. 1

    Locate and open the QuickBooks file you wish to convert to Excel. Go to the QuickBooks file menu and click "File," then click "Open."

  2. 2

    Click "Switch to Single-User Mode" in the QuickBooks file menu.

  3. 3

    Open the file menu and click "Export." Select "Send the report to a new Excel spreadsheet" then click "OK." Your QuickBooks data will appear as an Excel spreadsheet.

  4. 4

    Click "File" in the Excel spreadsheet, then click "Save As." Enter a name for the document. Your QuickBooks document is now converted to Excel.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.