File Conversion & Import/Export

The easiest way to open an XML file is to right-click it, choose Open with, and pick a web browser such as Chrome or Edge. The browser shows the file as a readable tree. To edit it, use Notepad or another text editor. To work with the data as a table, open it in Excel….

To open an XML file in Excel, go to File > Open, choose the XML file, and pick “As an XML table”. Excel turns the file into a table you can sort and filter. If the XML is nested or you want a table that refreshes, use Data > Get Data > From File >…