Related Articles
- 1 Subtotal by Payee on Quicken Reports
- 2 Create a Daily Report of Invoices in QuickBooks
- 3 Create Trend Statements in QuickBooks
- 4 Export Email Addresses From QuickBooks
QuickBooks from Intuit is business accounting software that gives you the ability to create and view complex reports. If you want to further edit the reports or simply centralize them in a large workbook, you must extract the data from QuickBooks and import it into Excel. You can easily accomplish this using the native Export feature in QuickBooks.
Excel export doesnt work on PC either Re: Cannot export to Excel anymore with Quickbooks 2016 for MAC Export to Excel doesn't work on my Win 10/Office 365 Excel either. This is a recent decrement in feature because it worked in February of 2018 when I first built the spreadsheet model that I. I just went into the QB Preferences in QB for Mac 2016 and switched the Reporting /Export Report As preferences away from 'SYLK for Microsoft Excel 2004' to.
2.
Click 'Reports' at the top of the QuickBooks window and select 'Report Center' from the resulting menu. The Report Center window opens.
3.
Select the report containing the data you want to export to Excel and click 'Display Report' to view it.
4.
Click the 'Excel' drop-down arrow at the top of the report. The Export Report window opens.
5.
Click the radio button by 'A new Excel workbook' if you want to create a new Excel workbook, or click the radio button by 'An existing Excel workbook' if you want to update an existing workbook. If you choose the former, click 'Browse' and select the workbook.
6.
Click 'Export' to extract your data from QuickBooks to Excel. If you elected to create a new Excel file, Excel will open automatically but the file will not be saved until you press 'Ctrl-S,' type a name and choose a location.
References (1)
About the Author
Kirk Bennet started writing for websites and online publications in 2005. He covers topics in nutrition, health, gardening, home improvement and information technology.
Photo Credits
- Rebecca Van Ommen/Lifesize/Getty Images
Choose Citation Style
Bennet, Kirk. 'How to Extract Data From Quickbooks to Excel.' Small Business - Chron.com, http://smallbusiness.chron.com/extract-data-quickbooks-excel-40670.html. Accessed 05 June 2019.
Bennet, Kirk. (n.d.). How to Extract Data From Quickbooks to Excel. Small Business - Chron.com. Retrieved from http://smallbusiness.chron.com/extract-data-quickbooks-excel-40670.html
Bennet, Kirk. 'How to Extract Data From Quickbooks to Excel' accessed June 05, 2019. http://smallbusiness.chron.com/extract-data-quickbooks-excel-40670.html
Note: Depending on which text editor you're pasting into, you might have to add the italics to the site name.