Microsoft Power Query is an add-in to the Excel program that is designed to perform ETL functions.i.e. extracting, transforming and loading data, which Allow users to use any type of data. This tool is useful for organizing and presenting data in a very simple way that you can use on your computer with the Microsoft Excel program.
What operating systems are supported by Power Query in Excel?
If you want to install the Power Query tool in Excel, you should know that not all systems This tool supports the operating system. Therefore, you must check whether your computer’s operating system is suitable to be able to use Power Query in Excel. The operating systems supported by Power Query in Excel are as follows.
- windows 10
- Windows Server 2008 R2.
- Windows Server 2012.
- Windows 7
- windows 8
- Windows 8.1.
It is important to note that Microsoft Power Query for Excel requires Internet Explorer 9 or later to be installed on your computer.Additionally, the Microsoft Power Query Tool for Excel only Available for 32-bit and 64-bit platformsbut it depends on the version of Office you have installed on your computer.
How do I get Power Query from Microsoft Excel on my computer?
You can get the Power Query add-in on your computer, whether you have it or not Windows or Mac operating system. The procedure for obtaining this add-in depends on the version of Microsoft Excel on your computer. Therefore, it is important to know the version of Microsoft Office installed on your device.
for my windows pc
Not required if your Microsoft Excel program is version 2016 or later Install the power query tool in Microsoft Excel. As in these versions, the tool is included by default.
it can Access this tool from all versions of Excel 2016 or laterStandalone and Microsoft 365 subscription plans. If you want to use this tool from a subscription, you need to access the Data tab of the Get and Transform group.
Instead, if you have the 2010 or 2013 version of the Microsoft Excel program. You should be aware that for this release, the tool is an add-on that is no longer officially supported.so you have to Download and install the Power Query plugin in your Microsoft Excel program.
if i use mac
If you have a Mac device, you should know this plugin Power Query does not work with 2016 or 2019 versions Microsoft Excel. Conversely, if you’re a Microsoft 365 subscriber, you can use the Power Query add-in in Excel for Mac. Via the Get Data command on the Data tab.
Where can I find Power Query in the Excel program?
position Power Query tool in the Excel programl. A series of steps must be performed. It is important that you first verify that the version of Excel on your computer is integrated by default, otherwise you must install it first.
- Open the Microsoft Excel program on your computer.
- Select the file in which you want to use the Power Query tool.
- Go to the top of the document where the toolbar is located.
- Click the Data tab.
- In the Sort and Transform group, click the New Query icon.
- A drop-down menu will then appear where you must select the «From other sources» option.
- Then, you have to choose the option that works best for you. Depending on where you want to extract the information needed to convert to Power Query.
- If the information you want to extract comes from the Internet, You must select «From website». will then automatically open a dialog where you must enter the URL of the web page from which you want to extract information.
What are the steps to get free Power Query in Excel?
To get Power Query in Excel for free, you need to have the 2020 or 2013 version of Microsoft Excel.then you need Visit the Microsoft Office website and download the Power Query plugin. To download this plugin, you must perform the following steps.
- Visit the Microsoft website.
- Sign in to your Microsoft account.
- Go to «Microsoft Download Center».
- Click the «Office» icon.
- after Select the Microsoft Power Query for Excel option.
- If you can’t find this option at a glance, you can go to the top of the Microsoft page. Next to the shopping cart is the search engine, which you should use to search for «Microsoft Power Query for Excel». Select the «Download Microsoft Power Query for Excel» option.
- then you must Select the language of the installation package and click the «Download» button.
- Choose an installation package based on the type of Office you have installed. That’s 64-bit or 32-bit.
How do I activate Power Query in the Excel 365 program?
- Download the Power Query plugin on your computer. After downloading the installation package, Double click the Power Query iconthen you just follow the instructions.
- Open the Excel file on which you want to use Power Query.
- Click on the tab called Power Query.
- To enable the plugin right after installation, you need to click on the «File» tab.
- Click Options, then Select the «Add-ons» option.
- Then click on «COM Add-ins», then click on «Go…» and tick the appropriate checkbox.
- Finally, click the «OK» button.