QuickBooks Time and Microsoft Excel Integration

How to connect QuickBooks Time database with Microsoft Excel



You will need the latest MySQL Connector/NET and MySQL Connector/ODBC drivers in order to connect your QuickBooks Time data to Microsoft Excel. The links can be found below. Download the driver based on whether your system is a 32-bit or 64-bit system.


Connection Instructions

  1. Open ODBC Data Sources (64-bit) by searching for it.



  2. Click on "Add" in the User DSN



  3. From the list, select MySQL ODBC 8.0 Unicode (your version could be different) and press Finish.



  4. You will then be prompted to enter your database information. You can get these details by navigating to My Integrations > QuickBooks Time PowerBI details > Connection Details.



    Data Source Name: Any name you like
    Description: Optional
    TCP/IP Server: Server name, Port: 3306
    User: Database username
    Password: Database password
    Database: Database name



  5. Press Ok when done with the above. This data source should now be populated in the User DSN tab. Close this window.



  6. Open Excel > Data > Get Data > From Other Sources > From Microsoft Query



  7. Select the data source you just created from the above steps and press ok.



  8. Select the tables and columns you need as per the normal procedure and load them into Excel.








  9. Once you follow the steps, your data will be available.



Support Questions

View Frequently Asked Questions

You can view our QuickBooks Time to PowerBI related FAQs from here.


View the Setup Document

You can view our QuickBooks Time to PowerBI Setup documentation from here.

Contact Us

We offer three support channels: 

Chat - Live Chat (24x5 support) from within your integration portal.  

Phone - #1 for Support
AUS: +61 2 9136 9448 
NZ: +64 9 303 2999 
UK: +44 203 670 1109
US: +1 720 500 9302


    • Related Articles

    • QuickBooks Time PowerBI Integration Overview

      Summary This guide will give a detailed overview of every section and tab that you can find in your QuickBooks Time to PowerBI integration. Details SyncEzy-Email This is the email you signed up with to access the integration portal on ...
    • Quickbooks Time to Power BI integration FAQs

      This document addresses the variety of questions we encounter while helping clients. If you have a question that’s not addressed her please write to us at support@syncezy.com About the QuickBooks Time to Power BI integration Please also visit our ...
    • QuickBooks Time Power BI setup documentation

      Recommended Drivers You will need the latest MySQL Connector/NET driver in order to connect your QuickBooks Time data to PowerBI. The links can be found below. Download the driver based on whether your system is a 32-bit or 64-bit system. MySQL ...
    • QuickBooks Time to OneDrive Integration Overview

      Summary This guide will give a detailed overview of every section and tab that you can find in your QuickBooks Time to OneDrive integration. Details SyncEzy-Email This is the email associated with your SyncEzy account. TSheet-Username This is the ...
    • QuickBooks Time to Google Drive Integration Overview

      Summary This guide will give a detailed overview of every section and tab that you can find in your QuickBooks Time to Google Drive integration. Details SyncEzy-Email This is the email associated with your SyncEzy account. TSheet-Username This is the ...