Translating QuickBooks Source Data to Custom Formatted Reports in Excel . Good, strategically useful financial reports include more information than QuickBooks (QB) can put in one report. Translating data from QB reports into comprehensive, customized Excel reports, while preserving data integrity, can be accomplished by memorizing a report in ... Setup QODBC to use with MS Excel. Note: QODBC allows you to quickly merge live QuickBooks data into the cells of your Microsoft Excel worksheets for quick calculations and graphs. The data will retain a live link to QuickBooks, and one click will update the data in the worksheet to the most current data in the linked QuickBooks table. Consider the Advanced Excel Options in QuickBooks. In this article I’ll show you how to save time from tedious and repetitive tasks with just a few simple clicks. (These instructions are for QuickBooks Desktop versions—Enterprise, Premier, and Pro.) Start by running a report in QuickBooks that you want to export to Excel.