Excel
Getting your data into Excel is nice and easy with SyncHub. Follow the steps below or view our [step-by-step tutorial here](https://blog.synchub.io/articles/how-to-query-your-xero-data-from-microsoft-excel).
First, you'll need to get your [database credentials](/kb/startreporting?api=) from SyncHub. Now, go ahead and enter them into Excel (examples given in Excel 2019):
1. Launch Excel and select the **Data** ribbon
2. Select **Get Data**, then **From Database**, then **From SQL Server Database** (**note:** if you are using an older version of Excel, you may only have a _From Server_ option, not _From Database_. In this case, you will likely get a firewall exception when trying to connect. We recommend routing through an [ODBC connection](/kb/odbc?api=) instead)
3. Copy and paste the relevant credentials into the Server and Database fields, then click **OK**
4. Select **Database** from the left hand panel and enter the username and password from your credentials, then click **Save**
5. Select the tables you would like to access, then hit **Load**
All done! Now you can build custom reports and dashboards using data from across all your connections – without the need for manual importing.