Forum Discussion
Excel 365 for Mac - is Power Query available?
Good morning,
I need to merge spreadsheets that contain a unique identifier column. Each spreadsheet contains student names and student ID, but each spreadsheet contains results from different tests, I would like to combine them using the unique identifier column so that I can see all of each student's test scores in one spreadsheet.
I tried to download Power Query, however it doesn't seem to open on a Mac. Any suggestions? Is there a Power Query for Mac? I am running macOS 10.14.6.
LouiseMc1952 PQ is in its infant stage in Excel for the Mac. You can refresh certain existing queries that where made on Excel for Windows. Nowadays, you can also import data from another workbook and from TXT/CSV files, but you can not write new or edit existing queries. So, I would say no! PQ isn't really available on the Mac. You'd need to set-up a virtual machine on your Mac with W10 and Excel.
5 Replies
LouiseMc1952 PQ is in its infant stage in Excel for the Mac. You can refresh certain existing queries that where made on Excel for Windows. Nowadays, you can also import data from another workbook and from TXT/CSV files, but you can not write new or edit existing queries. So, I would say no! PQ isn't really available on the Mac. You'd need to set-up a virtual machine on your Mac with W10 and Excel.
- Thank you for your fast reply. I appreciate it. I was having difficulty finding a direct answer.
