Pinterest Pixel

Importing Excel Workbooks in Power Pivot

Bryan
 .
Importing Excel Workbooks in Power Pivot | MyExcelOnline Importing Excel Workbooks in Power Pivot | MyExcelOnline

Power PivotĀ is a very powerful analytical tool which allows you to import data from various external sources!

This opens up many possibilities and gives you the power to do further data analysis and getĀ insightful business metrics.

You can import data from the following sources:

FROM DATABASE:

  • SQL Server
  • Access
  • Analysis Services

 

FROM DATA SERVICE:

  • Windows Azure Marketplace
  • OData Data Feed
  • Suggested Related Data

 

FROM OTHER SOURCES:

  • Oracle
  • IBM DB2
  • Microsoft Analysis Services
  • Excel Files
  • Text Files
  • Plus many more places…

 

In our example below, we are going to import data from an Excel File called Separate Excel Workbook.xlsx which is saved in our desktop.

You can view below the data that is in this Excel File:

Importing Excel Workbooks in Power Pivot

Importing Excel Workbooks in Power Pivot | MyExcelOnline
Please download thisĀ workbook to follow the tutorial below:

download: practice excel workbook Importing-Excel-Workbooks.xlsx

 

You also need to download the following workbook and save it in your computer’s desktop. Ā You will need this file path for Step 4:

download: separate-excel-workbook.xlsx Separate-Excel-Workbook.xlsx

 

STEP 1:Ā Open the Power Pivot Window. Ā Go to Power Pivot > Manage.

(ForĀ Excel 2010, go to PowerPivot > PowerPivot Window)

Importing Excel Workbooks in Power Pivot

 

STEP 2:Ā This will open theĀ Power Pivot Window. Ā Go toĀ Home > Get External Data > From Other Sources.

Importing Excel Workbooks in Power Pivot

 

STEP 3:Ā In the Table Import Wizard,Ā  pickĀ Excel File and click Next.

Importing Excel Workbooks in Power Pivot

 

STEP 4:Ā Browse for the Excel workbook that has your data.

Make sure check theĀ Use first row as column headersĀ checkbox i.e. Since our data has column headers.

Importing Excel Workbooks in Power Pivot

 

STEP 5: Select your file and clickĀ Open.

Importing Excel Workbooks in Power Pivot

 

STEP 6: ClickĀ Next.

Importing Excel Workbooks in Power Pivot

 

STEP 7:Ā Make sure the Source Table from the imported Workbook is selected.

Importing Excel Workbooks in Power Pivot

 

You can also click on the Preview & FilterĀ button (bottom right hand corner) Ā to choose or filter specific columns & data that you want to import:

Importing Excel Workbooks in Power Pivot

When you have made your selection, click OK and then selectĀ Finish in the next screen.

 

STEP 8:Ā You will get the following Importing Success dialogue box which shows the number of rows that have been imported. Ā ClickĀ Close.

Importing Excel Workbooks in Power Pivot

 

STEP 9: Your data is now ready for analysis usingĀ Power Pivot.

Importing Excel Workbooks in Power Pivot

 

 

PIVOT BANNER

If you like this Excel tip, please share it
Importing Excel Workbooks in Power Pivot | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Duplicate Columns Using Power Query or Get & Transform

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...