Forum Discussion
Is XML in Power Query is broken on macOS
Hello, XML from Power Query seems to have broken after update (July 2nd 2026). I tried this on several Macs To recreate just create a new file. Power Query -> XML -> Choose any xml file For ...
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.)
- Go to a free conversion site like ConvertCSV (convertcsv.com/xml-to-csv.htm) or CodeBeautify (codebeautify.org/xml-to-json).
- Upload your XML file.
- 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.
- Download the newly created CSV or JSON file to your Mac.
Step 2: Import the converted file into Excel
- Open a blank Excel workbook.
- Go to the Data tab on the ribbon.
- Click Get Data (or From Text/CSV / From JSON directly).
- Select your newly converted file.
- 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.