Knowledge base

Excel

Getting your data into Excel is nice and easy with SyncHub. 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** 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.