Power Query is an amazing data tool for Excel! It is built by Microsoft to help you import, transform, and automate your data processes. Checkout my overview of Power Query to learn more about it.
Here is a quick list of compatible versions:
- “Free” add-in for Excel 2010 and 2013 for Windows.
- Built-in feature for Excel 2016 for Windows (Office 365 Subscription). Click here to learn where to find it.
- Power Query is not yet available for the Mac versions of Excel.
This page will help you determine if you have the right version of Excel, and provide installation instructions.
Video Guide to Installing Power Query
What Version Do I Need?
The download page for Power Query lists which version of Excel are compatible with Power Query.
The following Office versions for Windows are supported:
- Microsoft Office 2016 – All Versions
- Microsoft Office 2013 – All Versions
- Microsoft Office 2010 Professional Plus with Software Assurance
Both 32-bit and 64-bit are supported. Power Query is not compatible with any Mac versions of Excel yet.
Unfortunately, if you don't have these versions you will need to upgrade to use Power Query. To me, Power Query is worth the upgrade to Office 365 alone, and there are a lot of other cool new features too.
How Do I Check My Version of Excel?
Excel 2010
Here's how to determine your version and 32 or 64 bit in Excel 2010:
- Click the File button.
- Click the Help option on the left side menu.
- The Excel version will be listed under the Product Activated section.
- The bit version (32-bit or 64-bit) will be listed under the About Microsoft Excel section.
If your Excel looks like the screenshot above, then you are in luck! 🙂 Again, you will need the Professional Plus version of Excel 2010.
Excel 2013
Here's how to determine your version and 32 or 64 bit in Excel 2013:
- Click the File button.
- Click the Account option on the left side menu.
- The Excel version will be listed under the Subscription Product section.
- Click the About Excel button. The bit version (32-bit or 64-bit) will be listed in the first row of the pop-up window.
How to Install Power Query
Excel 2016
Power Query is included with Excel 2016 (Office 365). It has been renamed and is now on the Data tab of the Ribbon in the Get & Transform section.
This means there is nothing to install. If you are using Excel 2016, go to the Data tab on the ribbon and press the New Query button to create a query and open the Power Query editor.
Power Query is available with all levels of Office 365 subscriptions. Here is an article that explains the features available for each subscription level.
It's important to note that there are some differences in Power Query for different builds of Excel 2016.
If you are on the MSI (Windows Installer) version then you will not get frequent updates to Power Query. Your ribbon might look different from mine, and you won't have all the latest features.
If you are on an Office 365 subscription then you have the Click-to-run version and you should get all the latest updates. Here is an article on how to determine which version of 2016 your are on.
If you are on the ProPlus version of Office 365 then you might be on the Deferred Channel. The name of the Deferred Channel has been changed to Semi-Annual Channel as of September 2017. This means you get updates every six months instead of every month.
Here is an article about the different channels for Office 365 ProPlus.
Here is an article on how to switch channels.
All the versions and channels make this very confusing, to say the least. Hopefully this guide helps you figure out how to get Power Query for Excel 2016.
Checkout my article on an Overview of Power Query to learn more about this awesome tool!
Excel 2010 & 2013
For Excel 2010 and 2013 you will need to download the Power Query add-in and install it.
The installation steps are about the same in Excel 2010 and 2013.
- Close (exit) Excel completely.
- Click the following link to go to the download page.
http://www.microsoft.com/en-us/download/details.aspx?id=39379
- Click the Download button.
- Click the checkbox for the bit version you are using. Most likely you will be using 32-bit.
- Click Next
- The add-in installation file will download. Click the file to run the installation.
- The Setup Wizard window will open. Follow the steps to install Power Query.
- Once the installation is complete, open Excel. You should now see the Power Query tab in the Ribbon.
My Power Query Tab Disappeared
If your Power Query tab ever goes missing, you can usually re-enable the add-in by going to the COM Add-ins menu.
There are a few ways to get to the COM Add-ins menu.
- File menu.
- Click Options on left side menu.
- Click Add-ins on left side menu.
- Select COM Add-ins from the Manage drop-down.
- Click the Go… button
- That will open the COM Add-ins Window. If the Power Query check box is not selected, just select it to reload the add-in.
There is also a button on the Developer tab that will take you directly to this window.
Getting Started with Power Query
Power Query is my favorite tool for working with data in Excel. If you are not familiar with what Power Query can do, checkout my article on an Overview of Power Query to learn more.
Please leave a comment below with any questions.
Thanks
Hi, I am getting the same error. I have 32bit version office 2010 and I am installing 32bit version Power Query. Please help me in installing power query to excel. Thanks
This is an excellent, clear resource for introducing people to Power Query. Thanks!
Thank you Olly! 🙂
I have 2016 Excel and still don’t have it. (I’ve checked Data tab, I have FileMaker, From HTML, From text, New Database Query but none ” From Web”) I am on a mac, however.
“From Other Sources” >> “From Web”?
Thanks Jon!
One stop shop for PowerQuery installations. I just installed Office 365 and I could not locate the PowerQuery ribbon.
Thanks for easing my panic.
Best regards,
Vince
Hi Vince
I have Office 365 and could not locate Power Query ribbon. can you help
I have Excel 2011. Can I use the same procedure to install Power Query?
Thank you for your time,
Angelica
Hi Jon,
I have Microsoft Office 2010 Professional Plus 32 bit but when I have followed the instructions it is stating that I need to install Microsoft SP 2010. Any idea why this is occurring?
Thanks
I am on 2016 Pro with all updates current, however, there is no Power Query tab, neither is available on COM addins. There is Inquire add on, which I enabled, bot this is not Power Query …
this was a huge help! Thank you very very much
Another very strong and powerful post I’ve read some of your previous posts and finally decided to drop a comment on this one. I signed up for your newsletter, so keep up the informative posts!
Office 365 Support
my problem is example A2 has a name, A2:A15 are blank B2:B15 has data attributed to A2, how do I get the name in A2 to fill in to A15? Will power query do this?
I have Microsoft Home & Student 2010 – Excel Version 14.0.7208.5000 (32 bit) .. So I guess I am out of luck to obtain Power Query.
Power Query is returning the dreaded “The server committed a protocol violation. Section=ResponseHeader Detail=CR must be followed by LF”
I am using Office 365 Excel 2016.
How do I fix this specifically for Excel – I’m not using Viusal Studio or IIS.
When I Google the error message, I only see fixes for IIS or VS.
Note: The same query works fine on Excel 2013 on Windows 7. I am connecting to an Ancestry.com search results page…
The video I watched was super clear. Thanks
My issue..
I have Microsoft Office 2010 Professional Plus 32 bit but when I have followed the instructions it is stating that I need to install Microsoft Excel 2010 SP1.
Please help.
Thanks
You will need to install SP1 pack in order to install PQ…
I am having MS Office 2010 Professional Plus but still not installing
Installed Excel Power Query on Excel 2013 packaged in Office 2013 standard. After installation the Add-in appears in the COM Add-ins menu but when the check box is checked and OK is clicked the ADD-in does not load. Any help is appreciated, questions answered ASAP.
Hello
How are you?
I am an Iranian lecturer in Excel.
Happy to contact you.
I wanted to know about power pivot, power query and power view.
You did not find a comprehensive reference in Iran.
Thanks so much
When i tried to install it, show a message that need internet explorer 9 RTM and closse the install program.
I have Windows 7 and office 2013 and internet explorer 8. I dont use it.
How i can install power query?
Thank you for the clear instructions for Power Query, I appreciate the help.
Can you share the instruction is are for Microsoft office 365 please
Good Day
I installed Microsoft office 365 version 2016, and now my microsoft query is not working anymore like it was working on previous versions. I was using it to connect to external customer database to get their data , so not I cant do my report anymore. How can fix this problem? I did check on add-ins and there is now power query there, I tried to installed it and I am getting an error message saying power query is installed already.
Please help
How can i resolve Microsoft Outlook 2010 Error “this item can not send” please guide me
I’ve just install power query on excell 2013, thank’s for your help
What’s up, I desire to subscribe for this website
to take newest updates, so where can i do it plese help.
Hi there,I’m trying to install PowerQuery_2.36.4434.1001 (32-bit) [en-us].msi, but I’m getting an error message stating that power query requires MS Excel SP1 or MS Excel 2013. I already have MS Excel installed so I don’t know what to do.
System information:
WINDOWS 8 ENTERPRISE 64BIT
MS OFFICE PRO PLUS 2010 32BIT
Please help!
CAN I INSTALL IN MY SYSTEM.
EXCEL 97-2003 WORK BOOK.
PLEASE HELP ME
You cannot, you need office 365 or office 2016
so there’s no power query for mac?! that sucks!
you mean the fact that a Microsoft product doesnt have all the features on rival product? perhaps mac sucks? how many mac programs work on Windows, huh?
thanks a lot for this useful article. But I am really disappointed that I can’t use the power query tool for Mac. It is a really useful material for the survey analysis.
When i tried to install it, show a message that need internet explorer 9 RTM and closse the install program.
I have Windows 7 and office 2016 and internet explorer 8. I dont use it.
How i can install power query?
Even after adding through file power query is not visible in ribbon please help
Which version of excel are you using
Our company is a heavy Excel 2010 VBA user. The current IT director is against addins because they sometimes don’t play nicely with VBA. Have you heard of any problems caused by Power Query interfering with VBA, macros, etc.?
I would be willing to turn off the add-in when I don’t need it.
I want know what will be the benefits using Power in excel.
i get this error when trying to install Query…
There is no application set to open the document “PowerQuery_2.62.5222.761 (32-bit) [en-us].msi”.
Hello, I have Microsoft Excel for Mac Version 16.35 (20030802). However i’m troubleshooting to find Power query in my excel ribbon neither I can find Get & Transform. Is there any solution to fix this problem ?
Hi Anju,
Unfortunately, Power Query is not fully available for the Mac version of Excel. All you can do right now is refresh queries from the Data tab on the ribbon.
Here is a page that explains more about Power Query for Mac and how Microsoft is rolling it out.
https://techcommunity.microsoft.com/t5/excel-blog/get-amp-transform-power-query-in-excel-for-mac-phase-1/ba-p/876840
I hope that helps. Thanks again and have a nice day!
I’m having trouble viewing Power Query. I have Windows 8.1 64-bit, MS Office 365 (Excel 2016). Power Query does not show on the upper ribbon. I’ve gone through the Com Add-in and Power Query doesn’t show I assume because it’s automatically part of Excel 2016. Any help would be greatly appreciated.
Your other YouTube videos are excellent and very useful.
With Excel open, hover your mouse over the ribbon area, select ‘Customize the Ribbon’. In the dialog box, on the right hand side, select ‘Main Tabs’ from the Customize Ribbon drop down. Below that you should see a selection of tick boxes, make sure the Power Pivot box is ticked and you should be good to go.
I m getting this error while using get data activity in Powerquery
Feedback Type:
Frown (Error)
Error Message:
Cannot create process.
Stack Trace:
Microsoft.Mashup.Evaluator.Interface.ErrorException: Cannot create process. —> System.InvalidOperationException: Cannot create process. —> System.InvalidOperationException: Cannot create process. —> System.ComponentModel.Win32Exception: The system cannot find the file specified
— End of inner exception stack trace —
at Microsoft.Mashup.Evaluator.ContainerProcess.c__DisplayClass8_0.b__0()
at Microsoft.Mashup.Evaluator.ContainerProcess.WithClientPipesAttachedEvent(String hostToContainerPipeName, Func`1 func)
at Microsoft.Mashup.Evaluator.ContainerProcess.CreateProcess()
at Microsoft.Mashup.Evaluator.ProcessContainerFactory.Container.CreateProcess(String exePath, String logFolderPath, String arguments)
at Microsoft.Mashup.Evaluator.ProcessContainerFactory.Container..ctor(String exePath, String exitMutexName, Int32 containerID, ContainerJob job, String logFolderPath)
at Microsoft.Mashup.Evaluator.ProcessContainerFactory.CreateProcessContainer()
at Microsoft.Mashup.Evaluator.WorkingSetProcessContainerFactory.CreateProcessContainer()
at Microsoft.Mashup.Evaluator.ContainerPoolContainerFactory.CreatePooledContainer(TimeSpan ttlAdjustment)
at Microsoft.Mashup.Evaluator.ContainerPoolContainerFactory.CreateContainer()
at Microsoft.Mashup.Evaluator.RemoteEvaluationContainerFactory.CreateContainer()
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.CreateContainer()
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)
— End of inner exception stack trace —
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation`1.TryCompleteWithException(Exception exception)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)
at Microsoft.Mashup.Evaluator.EvaluatorThreadPool.EvaluatorThread(Object state)
at Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass9_0.b__0(Object o)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart(Object obj)
— End of inner exception stack trace —
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)
Stack Trace Message:
Cannot create process.
Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)
at Microsoft.Mashup.Client.UI.Windows.UIHost.RaiseErrorDialog(IWindowHandle activeWindow, FeedbackPackageInfo feedbackPackageInfo, Exception e, LocalizedString dialogTitle, LocalizedString dialogMessage, Boolean useGDICapture)
at Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.c__DisplayClass14_0.b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Delegate.DynamicInvokeImpl(Object[] args)
at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ThreadContext.LocalModalMessageLoop(Form form)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.n__0(IWindowHandle owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.Mashup.Client.Excel.QueriesEditorWindow.ShowModal(IUIHost uiHost, FormulaHistoryManager formulaHistoryManager, ApplicationTracingHost applicationTracingHost, ExcelServices excelServices, ConnectionManager connectionManager, DialogManager dialogManager, FillManager fillManager, PackageManager packageManager, IFileDialogManager fileDialogManager, IExceptionHandler exceptionHandler, ITelemetryService telemetryService, IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries)
at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries, IUndoScope undoScope)
at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.c__DisplayClass13_1.b__1(IUndoScope undoScope)
at Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.Microsoft.Mashup.Client.Excel.Shim.IDeferredStorageInvoker.InvokeDeferredStorageAction(IWorkbook workbook, Action action)
at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.InvokeCoauthAction(IWorkbook workbook, UndoableActionType actionType, Action action)
at Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.InvokeUndoableAction(IWorkbook workbook, UndoableActionType actionType, Action`1 action)
at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.NotifyGetDataPresence(IWorkbook workbook, Action action)
at Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries)
at Microsoft.Mashup.Client.Excel.DialogManager.AddExcelTable(IWindowHandle ownerWindow, IWorkbook workbook, String tableName, String newQueryName)
at Microsoft.Mashup.Client.Excel.DialogManager.AddExcelTable(IWindowContext windowContext, IWorkbook workbook)
at Microsoft.Mashup.Client.Excel.Shim.NativeWorkbookStorageServices.Microsoft.Mashup.Client.Excel.Shim.IDeferredStorageInvoker.InvokeDeferredStorageAction(IWorkbook workbook, Action action)
at Microsoft.Mashup.Client.Excel.Shim.NativeCoAuthServices.InvokeCoauthAction(IWorkbook workbook, UndoableActionType actionType, Action action)
at Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.InvokeUndoableAction(IWorkbook workbook, UndoableActionType actionType, Action`1 action)
at Microsoft.Mashup.Client.Excel.Shim.IWindowContextExtensions.TryInvokeOnParentWorkbook(IWindowContext windowContext, Action`1 action)
at Microsoft.Mashup.Client.Excel.NativeRibbonHandler.c__DisplayClass6_0.b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.Mashup.Client.Excel.Native.NativeExcelCallbackInvoker.InvokeAndReturnHResult(Action action)
Supports Premium Content:
True
Formulas:
section Section1;
shared Table1 = let
Source = Excel.CurrentWorkbook(){[Name=”Table1″]}[Content]
in
Source;
[…] In Excel 2016 PowerQuery is already included as a standard part of Excel and can be found under Data Tab => Get&Transform Data group. If you are using Excel 2010/2013, you can download it as a free Add-in. Just follow this short tutorial. […]
Hi Jon
I have Power Query installed. however, i am not able to convert my formatted table to PQ. no matter how i click FROM TABLE. Is there anything i need to do to enable PQ to function again? hope you can help. thanks Mei
when I install power query, it says “your excel needs Microsoft Excel 2010 SP 1.
What should I do?
Thanks!
hey team ,
karan here, i am facing problem to install the PQ and error is install Microsoft Excel 2010 sp1 or 2013 & currently i am Excel 2010.. tell now
thanks, this is a game changer!
Hi,
I have been using power query in excel 2013 since a while but problem with it is, its disappears once i miss to use it for a week.
Have done the practice as mentioned to retain power query but no use. Any better suggestions please
Is power query for excel available for Macbook?
Hi Guys
I have Office 2013 and installed power query but it shows in inactive add ins can anyone help plz?
Hi,
I am using Excel 2016. The “View” tab in Power Query Editor only shows Monospaced and Show Whitespace. It ‘s missing: Column Quality, Column Distribution, and Column Profile. How can I add/ enable these missing functions?
very nice bro !!! in my excel it was not showing and now activating COM Add-ins everything ok.
How can i run Power query on Excel Mac? I also dont see the button n my data tab for “get the external data”?
Split Column by Delimiter this option not show in my excel 2016.
Please suggest
Tengo Excel 2019 en mi notebook con windows 11 ,no he visto la opcion para descargar Power Query