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 t...

excel

Formulas and Functions

Riny_van_Eekelen
Oct 26, 2021
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.

Riny_van_Eekelen

Platinum Contributor

Oct 26, 2021

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.

LouiseMc1952

Copper Contributor

Oct 26, 2021

Thank you for your fast reply. I appreciate it. I was having difficulty finding a direct answer.

Forum Discussion

Excel 365 for Mac - is Power Query available?

Resources