How to Convert From QuickBooks
QuickBooks is popular accounting software that is used in many businesses to keep track of client payment information, employee payroll information, and sales information such as inventory. While QuickBooks files are similar to other spreadsheet programs, they are not compatible with most of those programs and, therefore, cannot be opened and read by other programs. If you want to convert data from QuickBooks into another data file format, such as Excel, you must first export the QuickBooks data and then save it in another program.
Other People Are Reading
Instructions
-
-
1
Navigate to the QuickBooks "File" menu and choose "Open." Browse the computer's hard drive for the QuickBooks data file that you want to convert, and click the "Open" button to open the file.
-
2
Return to the "File" menu and click "Switch to Single-user Mode." If this option is unavailable on the File menu, you are already in single-user mode and ready to export from the QuickBooks file.
-
-
3
Open the "File" menu again and choose the "Export" button. Choose "Send the report to a new Excel spreadsheet" in the list of options that comes up to send the data to Excel, and click "OK." Excel will launch automatically, and the data will appear in the Excel spreadsheet.
-
4
Go to the "File" menu in Excel and select the "Save As" option. Select a folder where you would like the file to save, and enter a name for the converted file. Click the "Save" button to save the file as an Excel file.
-
1
Tips & Warnings
QuickBooks provides additional plug-ins that allow users to export QuickBooks data as IIF, or Intuit Interchange Format, which can then be uploaded into other accounting programs, such as Microsoft Accounting. Other accounting applications, such as Peachtree, provide their own conversion utilities to convert data from QuickBooks to their software.
