![\"\"](\"https:\/\/beyond-shenzhen.cn\/wp-content\/uploads\/2025\/10\/xml-excel-conversion_img1.webp\")
<\/p>\nWhen exporting data from a system, some systems may allow downloads in the “XML file” format.(Examples: Databases of core systems, article data from WordPress, etc.)<\/p>\n
However, if the XML file contains a large amount of data, it can be difficult to understand the content clearly just by viewing the file directly.<\/p>\n
Therefore, this time we will introduce “two methods” \u2014 with simple operations, you can convert XML data into an Excel spreadsheet, making it easier to check and browse the data.<\/p>\n
* During actual operation, the interface may vary depending on your PC environment or software version. Please be aware of this in advance.<\/p>\n
This is an easy way to import an XML file into Excel.<\/p>\n
Simply drag and drop the XML file into a blank Excel sheet, then select “Open as XML Table” in the pop-up dialog box. The XML data will be automatically imported into Excel.<\/p>\n
This method is ideal for scenarios where you want to quickly view and verify XML data in Excel.<\/p>\n
<\/p>\n
As an example, we\u2019ll select and import the XML file < beyond-test-wordpress-article.xml >, which stores article data from WordPress.<\/p>\n
Use your mouse to drag and drop the XML file directly into the pre-prepared blank Excel sheet.<\/p>\n A pop-up with options will then appear; select “Open as XML Table”.<\/p>\n If a pop-up appears with the message: “The specified XML source does not reference a schema. A schema will be created based on the XML source data”, click “OK”.<\/p>\n After that, Excel will automatically start importing the data.<\/p>\n * If the XML file contains a large amount of data, the import process may take some time to complete.<\/p>\n This completes the data import. The imported data will also have the AutoFilter function applied automatically.<\/p>\n When importing data from XML to Excel using this “Method A”, if the XML file is large (e.g., over several dozen MB), the processing may slow down due to PC performance or graphics card limitations.<\/p>\n As a result, Excel may take longer to load the XML table, or some data may fail to import or be missing.<\/p>\n If you encounter issues with data import, “Method B” (covered later) is recommended, though it requires a few extra steps.<\/p>\n This method imports data from an XML file by using the “Power Query” feature built into Excel.<\/p>\n Power Query is a data processing tool included in Microsoft software such as Excel and Power BI. It mainly enables efficient data import, shaping, transformation, and preprocessing.<\/p>\n With this tool, even large XML files can be successfully imported into Excel.<\/p>\n From the ribbon menu at the top of Excel, open the “Data” tab, then click in the order of “Get Data > From File > From XML”.<\/p>\n As an example, select and import the XML file < beyond-test-wordpress-article.xml >, which stores article data from WordPress.<\/p>\n After importing the target XML file, a pop-up will appear; click “Transform Data”.<\/p>\n The “Power Query Editor” interface will open automatically.<\/p>\n Click the icon that looks like “left-right arrows” displayed on the interface.<\/p>\n Next, click in the order of “Expand > OK”.<\/p>\n After that, the XML data records will expand as shown below.<\/p>\n <\/p>\n Move the “slider” at the bottom of the interface left or right to display other columns that need to be expanded.<\/p>\n Subsequently, follow the same steps: “Click the left-right arrows > Expand > OK” to expand data in any column.<\/p>\n As you proceed with the operation, various data will gradually appear on the Power Query interface.<\/p>\n![\"\"](\"https:\/\/beyond-shenzhen.cn\/wp-content\/uploads\/2025\/10\/xml-excel-conversion_img2.webp\")
<\/a><\/p>\n\u2462 Drag and Drop the XML File Into the Blank Excel File<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\n\u2463 Data in the XML File Will Be Automatically Reflected in Excel<\/h3>\n
<\/a><\/p>\nSupplementary Notes<\/h3>\n
\u25c6 Method B: Using Excel’s Power Query<\/h2>\n
\u2460 Prepare a Blank Excel File<\/h3>\n
<\/a><\/p>\n\u2461 Operate Excel’s Ribbon Menu<\/h3>\n
<\/a><\/p>\n\u2462 Select the XML File for Data Conversion<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\n\u2463 Operate in the Power Query Interface<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n
| Web Application Development<\/span><\/td>\n | https:\/\/beyond-shenzhen.cn\/en\/service\/development<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n <\/p>\n |