---
title: "Is it possible to make Pivot table using multiple sources of data in excel?"  
description: "Is it possible to make Pivot table using multiple sources of data in excel?"  
author: "Steilla Mitchel"  
published: 2022-03-25  
canonical: https://answers.mindstick.com/qa/96531/is-it-possible-to-make-pivot-table-using-multiple-sources-of-data-in-excel  
category: "troubleshooting"  
tags: ["troubleshooting", "excel"]  
reading_time: 2 minutes  

---

# Is it possible to make Pivot table using multiple sources of data in excel?

Is it possible to make [Pivot table](https://www.mindstick.com/forum/1565/pivot-table-in-sql-server-2008) using [multiple](https://www.mindstick.com/blog/12797/iowa-is-expected-to-see-heavy-growth-in-multiple-sectors) [sources](https://www.mindstick.com/articles/44491/how-to-evaluate-credibility-of-internet-sources) of [data](https://www.mindstick.com/articles/23186/how-becoming-a-data-analyst-can-be-a-lucrative-career) in [excel](https://www.mindstick.com/articles/12937/how-to-import-excel-data-in-sql-server-2014)?

## Answers

### Answer by Hitesh Vohra

- Use a relational database such as Microsoft SQL Server, Oracle, or [**Microsoft**](https://answers.mindstick.com/qa/94460/why-is-microsoft-word-not-responding) Access to import data. Multiple tables can be imported at the same time.
- **Import multiple tables** from a variety of other data sources, such as text files, data streams, and Excel worksheet data. You can add these tables to Excel's Data Model, define relationships between them, and then create your PivotTable using the Data Model.
- When connecting to SQL Server, make sure you know the server name, database name, and credentials to use. The information you require can be obtained from your database administrator.
- **Select Data > Get External Data > From Other Sources > SQL Server** from the drop-down menu.
- Enter the network computer name of the SQL Server-running computer in the Server Name box.
- If you're connected as yourself, choose Use Windows Authentication in the Log on credentials box. In every other case, use the database administrator's login and password.
- Select the database you want in the Select Database and [Table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) box, then click Enable selection of multiple tables.
- Manually choose the tables you wish to deal with if you know exactly which ones you want. Otherwise, select one or two tables, then click Select Linked Tables to have tables related to the ones you selected auto-selected.
- Keep the Import associations between chosen tables box checked to have Excel recreate identical table relationships in the workbook.
- Finish by clicking the **Finish button.**
- Select PivotTable Report from the Import Data dialogue box.
- To begin the import and populate the Field List, click OK.

\

\

**Read More: [What do I do if Pinterest suspended my account?](https://answers.mindstick.com/qa/96469/what-do-i-do-if-pinterest-suspended-my-account)**


---

Original Source: https://answers.mindstick.com/qa/96531/is-it-possible-to-make-pivot-table-using-multiple-sources-of-data-in-excel

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.