Is XML in Power Query is broken on macOS

Worth mentioning it's fixed  now with latest update. However, it proves unreliable for me. I'll me exploring options presented at alternative to the system in place now. Thanks

Regarding the issue where Power Query gets stuck on an endless loading screen when importing XML files on your Mac: this is a known bug in the current Mac version of Excel’s XML parser.

While Microsoft works on a fix, the most reliable workaround is to convert the XML file to a CSV or JSON file first, and then import that converted file into Power Query.

Here is how to do this using a free online converter:

Step 1: Convert the XML file (Note: Only use this method if the XML file does not contain sensitive or confidential company data.)

1. Go to a free conversion site like ConvertCSV (convertcsv.com/xml-to-csv.htm) or CodeBeautify (codebeautify.org/xml-to-json).
2. Upload your XML file.
3. If your data is relatively flat (simple lists/tables), convert it to CSV. If your data is highly nested or complex, convert it to JSON.
4. Download the newly created CSV or JSON file to your Mac.

Step 2: Import the converted file into Excel

1. Open a blank Excel workbook.
2. Go to the Data tab on the ribbon.
3. Click Get Data (or From Text/CSV / From JSON directly).
4. Select your newly converted file.
5. The Power Query Editor should now open normally without freezing. You can transform your data and click Load to bring it into your spreadsheet.

My answers are voluntary and without guarantee!

Hope this will help you.

Hi, since you can reproduce this on several Macs after the July 2 update, I would treat it as a likely Excel for Mac regression rather than a bad XML file. A good test would be to try another update channel or roll back one affected Mac if your org allows it. In the meantime, using Excel for Windows, Power Query Online, or another XML import path may be the most practical workaround until Microsoft confirms the bug.