How To Convert Xml Data Files To Excel 2 Easy Methods

If you’re using Windows, you can import an XML file from the web instead. Instead of choosing From File, select From Other Sources > From Web, enter the direct URL to the XML file, and then click OK. Then, skip to Step 7. If you’re using a Mac, make sure the XML file you want to convert is already saved to your computer. Unlike in Windows, you won’t be able to open XML files from the web in Excel.

Windows: If you want to modify anything about the data first, such as column headers, you can click Transform Data instead. Then, make your changes in the Power Query window and click Close & Load at the top-left corner to add the data to a new worksheet. Mac: If you want to modify anything about the XML data, click Load first, then launch Power Query by clicking the down-arrow next to the “Get Data” icon in the toolbar and selecting Launch Power Query Editor…. Make changes to your data, then click Close & Load on the Home tab.

Windows: If you want to modify anything about the data first, such as column headers, you can click Transform Data instead. Then, make your changes in the Power Query window and click Close & Load at the top-left corner to add the data to a new worksheet. Mac: If you want to modify anything about the XML data, click Load first, then launch Power Query by clicking the down-arrow next to the “Get Data” icon in the toolbar and selecting Launch Power Query Editor…. Make changes to your data, then click Close & Load on the Home tab.

Click the File menu and choose Save As. Click Browse (Windows) or On My Mac (Mac), then choose a folder. [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source Type a name for your workbook. If you want to save the file as an Excel XLSX file, choose Excel Workbook from the “Save as type” or “File Format” menu. You can choose any of the formats in the list, including CSV (Comma Delimited). Click Save to save the file.

Depending on your settings, you might have to select a save location and click Save or OK to start the download.