Knowledge base

Excel

Getting your data into Excel is nice and easy with SyncHub. First, you'll need to get your database credentials from SyncHub: 1. Log in to SyncHub and head to the **Connections** page 2. Click the **Dashboard** for any of your connections (it doesn’t matter which one) 3. Click **Start Reporting** 4. Click **View Credentials** 5. Enter your password Those are your database credentials. Now, go ahead and enter them into Excel (note these instructions are based on Excel 2019 – the steps may be slightly different depending on the version you are using): 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.