If you want to get multiple tables from the same data source, check the Enable selection of multiple tables option. In Excel 20, go to Power Query > Get External Data, and select your data source.Įxcel prompts you to select a table. In Excel 2016, and Excel for Microsoft 365, use Data > Get & Transform Data > Get Data to import data from any number of external data sources, such as a text file, Excel workbook, website, Microsoft Access, SQL Server, or another relational database that contains multiple related tables. Once activated, a Power Query tab will be added to the ribbon. A Power Query tab will be added to the ribbon.Įxcel 2010 - Download and install the Power Query add-in. Check Microsoft Power Query for Excel, then OK to activate it.
Go to File > Options > Add-Ins, then in the Manage drop-down at the bottom of the pane, select COM Add-Ins > Go. Learn more about starting the Power Pivot add-in for Excel 2013.Įxcel 2010 - Download the Power Pivot add-in, then install the Power Pivot add-in,Įxcel 2016 & Excel for Microsoft 365 - Get & Transform (Power Query) has been integrated with Excel on the Data tab.Įxcel 2013 - Power Query is an add-in that's included with Excel, but needs to be activated. Excel 2016 & Excel for Microsoft 365 - Power Pivot is included in the Ribbon.Įxcel 2013 - Power Pivot is part of the Office Professional Plus edition of Excel 2013, but is not enabled by default.
