{"id":29038,"date":"2023-05-19T21:49:40","date_gmt":"2023-05-19T19:49:40","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=29038"},"modified":"2024-02-06T18:28:30","modified_gmt":"2024-02-06T17:28:30","slug":"convert-xml-to-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-xml-to-excel\/","title":{"rendered":"2 Easy Hacks to Convert XML to Excel"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/9FD5E6A0-86B5-4E41-9C60-2B944CDA4D8B.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"2 Easy Hacks to Convert XML to Excel\" class=\"aligncenter wp-image-29341 size-large\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/9FD5E6A0-86B5-4E41-9C60-2B944CDA4D8B-1024x576.png\" alt=\"2 Easy Hacks to Convert XML to Excel\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/9FD5E6A0-86B5-4E41-9C60-2B944CDA4D8B-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/9FD5E6A0-86B5-4E41-9C60-2B944CDA4D8B-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/9FD5E6A0-86B5-4E41-9C60-2B944CDA4D8B-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/9FD5E6A0-86B5-4E41-9C60-2B944CDA4D8B.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>If you want to transfer large datasets from one system to another, it is essential to know how to convert XML to Excel in detail.<\/p>\n<p><strong>XML (or Extensible Markup Language)<\/strong> is a <strong>text-based formatting language that is just like HTML<\/strong>. It is used to store and transport data in a structured format. It is a<strong> great tool to transfer data<\/strong> without the loss of data integrity. It has <strong>custom tags<\/strong> that define different data elements. Whereas, <strong>Excel<\/strong> is a powerful <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\" title=\"spreadsheet\" data-wpil-keyword-link=\"linked\">spreadsheet<\/a> program that is widely used for da<strong>ta organization, analysis, and visualization<\/strong>. It is a user-friendly program that provides various tools for handling data efficiently and generating meaningful insights.<\/p>\n<p>XML is a language that is easily understood by machines and if you need to<strong> make any changes in the data it can be a bit challenging<\/strong>. So, it is crucial to convert XML to Excel in order to easily work with the data.<\/p>\n<p>You can import data from an XML file saved in your system or from the web in Excel. This can be done using an <strong>extremely versatile tool called the <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/50-things-you-can-do-with-excel-power-query\/\" target=\"_blank\" rel=\"noopener\" title=\"Power Query\" data-wpil-keyword-link=\"linked\">Power Query<\/a><\/strong>. It accesses, cleans, and transforms all messy data and displays it in a way that Excel loves and can work with.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/power-bi\/power-query\/\" target=\"_blank\"><strong>Click here<\/strong><\/a> to be blown away by the data transformation potential of Power Query in Excel!<\/p>\n<h4>In this article, we will be covering 2 easy and quick hacks to convert XML to Excel &#8211;<\/h4>\n<ul>\n<li><a href=\"#1\"><strong>XML file saved on our system<\/strong><\/a><\/li>\n<li><a href=\"#2\"><strong>Using Web URL<\/strong><\/a><\/li>\n<\/ul>\n<p>Let&#8217;s dive in!<\/p>\n<p>First, you need to have <a class=\"wpil_keyword_link\" href=\"https:\/\/www.office.com\/\" target=\"_blank\" rel=\"noopener nofollow\" title=\"Microsoft Office\" data-wpil-keyword-link=\"linked\">Microsoft Office<\/a> 2010 or above. \u00a0If you do not have this then you will need to upgrade to Office 365 using this link: <strong><a href=\"https:\/\/products.office.com\/en-us\/home\" target=\"_blank\" rel=\"nofollow noopener\">https:\/\/products.office.com\/en-us\/home<\/a><\/strong><\/p>\n<div class=\"om-placeholder\">\n<h4><\/h4>\n<h4>Download the Excel Workbook below to follow along and understand how to XML to Excel &#8211;<\/h4>\n<\/div>\n<p><a class=\"IRPP_minimalist icon-download hiddenmode replaced-link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/XML-to-Excel.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">XML-to-Excel.xlsx<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span id=\"1\" style=\"color: #ff0000!important\">XML file saved on your system<\/span>\u00a0<\/strong><\/p>\n<p>If your XML file is saved on your system, you can easily <strong>import data from XML<\/strong> into\u00a0<strong>Power Query<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-249.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"2 Easy Hacks to Convert XML to Excel\" class=\"alignnone wp-image-29096 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-249-e1683895025658.png\" alt=\"2 Easy Hacks to Convert XML to Excel\" width=\"1920\" height=\"979\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-249-e1683895025658.png 1920w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-249-e1683895025658-300x153.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-249-e1683895025658-1024x522.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-249-e1683895025658-768x392.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-249-e1683895025658-1536x783.png 1536w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>Follow the steps below to convert XML to Excel \u2013<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span><\/strong> Open a <strong>Blank Excel Workbook<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-213.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"2 Easy Hacks to Convert XML to Excel\" class=\"alignnone size-full wp-image-29041\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-213.png\" alt=\"2 Easy Hacks to Convert XML to Excel\" width=\"1846\" height=\"594\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-213.png 1846w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-213-300x97.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-213-1024x329.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-213-768x247.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-213-1536x494.png 1536w\" sizes=\"(max-width: 1846px) 100vw, 1846px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span><\/strong> Go to the <strong>Data<\/strong> tab located at the top ribbon.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-214.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"2 Easy Hacks to Convert XML to Excel\" class=\"alignnone size-full wp-image-29042\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-214.png\" alt=\"2 Easy Hacks to Convert XML to Excel\" width=\"1543\" height=\"223\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-214.png 1543w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-214-300x43.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-214-1024x148.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-214-768x111.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-214-1536x222.png 1536w\" sizes=\"(max-width: 1543px) 100vw, 1543px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3:<\/span> <\/strong>Go to <strong>Get Data<\/strong> &gt; <strong>From File<\/strong> &gt; <strong>From XML<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-215.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"2 Easy Hacks to Convert XML to Excel\" class=\"alignnone wp-image-29043 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-215.png\" alt=\"2 Easy Hacks to Convert XML to Excel\" width=\"710\" height=\"674\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-215.png 710w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-215-300x285.png 300w\" sizes=\"(max-width: 710px) 100vw, 710px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4:<\/span> <\/strong>In the Import Data dialog box, browse and<strong> select the XML file<\/strong> and click <strong>Open<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-216.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"2 Easy Hacks to Convert XML to Excel\" class=\"alignnone size-full wp-image-29044\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-216.png\" alt=\"2 Easy Hacks to Convert XML to Excel\" width=\"931\" height=\"585\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-216.png 931w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-216-300x189.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-216-768x483.png 768w\" sizes=\"(max-width: 931px) 100vw, 931px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 5:<\/span> <\/strong>Select the\u00a0<strong class=\"ky ew\">XML Data Source<\/strong> in the left panel. Here, we will click on &#8220;row&#8221;.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-218.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"2 Easy Hacks to Convert XML to Excel\" class=\"alignnone size-full wp-image-29045\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-218.png\" alt=\"2 Easy Hacks to Convert XML to Excel\" width=\"1097\" height=\"873\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-218.png 1097w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-218-300x239.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-218-1024x815.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-218-768x611.png 768w\" sizes=\"(max-width: 1097px) 100vw, 1097px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 6:<\/span> <\/strong>A <strong>preview <\/strong>will be shown, if it looks good click<strong> Load<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-220.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"2 Easy Hacks to Convert XML to Excel\" class=\"alignnone size-full wp-image-29047\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-220.png\" alt=\"2 Easy Hacks to Convert XML to Excel\" width=\"1093\" height=\"869\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-220.png 1093w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-220-300x239.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-220-1024x814.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-220-768x611.png 768w\" sizes=\"(max-width: 1093px) 100vw, 1093px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 7:<\/span> <\/strong>A <b>new worksheet <\/b>will be added with the XML data in it.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-219.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"2 Easy Hacks to Convert XML to Excel\" class=\"alignnone size-full wp-image-29046\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-219.png\" alt=\"2 Easy Hacks to Convert XML to Excel\" width=\"1915\" height=\"765\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-219.png 1915w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-219-300x120.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-219-1024x409.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-219-768x307.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-219-1536x614.png 1536w\" sizes=\"(max-width: 1915px) 100vw, 1915px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 8:<\/span> Press Ctrl + S to save the file.<\/strong><\/p>\n<p>You have successfully converted <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/xlsx-to-csv\/\" target=\"_blank\" rel=\"noopener\">XML to Excel<\/a> from a file saved in your system.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span id=\"2\" style=\"color: #ff0000!important\">Using Web URL<\/span>\u00a0<\/strong><\/p>\n<p>What if we have XML data on a webpage and we want to import it into Excel? Power Query can do that as well. Follow the steps below to know how &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span><\/strong> Open a <strong>Blank Excel Workbook<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-213.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"2 Easy Hacks to Convert XML to Excel\" class=\"alignnone size-full wp-image-29041\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-213.png\" alt=\"2 Easy Hacks to Convert XML to Excel\" width=\"1846\" height=\"594\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-213.png 1846w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-213-300x97.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-213-1024x329.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-213-768x247.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-213-1536x494.png 1536w\" sizes=\"(max-width: 1846px) 100vw, 1846px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span><\/strong> Go to the <strong>Data<\/strong> tab located at the top ribbon.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-214.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"2 Easy Hacks to Convert XML to Excel\" class=\"alignnone size-full wp-image-29042\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-214.png\" alt=\"2 Easy Hacks to Convert XML to Excel\" width=\"1543\" height=\"223\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-214.png 1543w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-214-300x43.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-214-1024x148.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-214-768x111.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-214-1536x222.png 1536w\" sizes=\"(max-width: 1543px) 100vw, 1543px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3:<\/span> <\/strong>Select <strong>From Web<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-226.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"2 Easy Hacks to Convert XML to Excel\" class=\"alignnone size-full wp-image-29049\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-226.png\" alt=\"2 Easy Hacks to Convert XML to Excel\" width=\"1541\" height=\"225\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-226.png 1541w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-226-300x44.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-226-1024x150.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-226-768x112.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-226-1536x224.png 1536w\" sizes=\"(max-width: 1541px) 100vw, 1541px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4:<\/span> <\/strong>In the From Web dialog box, <strong>enter the URL,<\/strong> and click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-254.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"2 Easy Hacks to Convert XML to Excel\" class=\"alignnone size-full wp-image-29102\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-254.png\" alt=\"2 Easy Hacks to Convert XML to Excel\" width=\"873\" height=\"268\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-254.png 873w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-254-300x92.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-254-768x236.png 768w\" sizes=\"(max-width: 873px) 100vw, 873px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 5:<\/span> <\/strong>In the Access Web Content, Click on <strong>Connect<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-223.heic\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29152\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-223.heic\" alt=\"\" title=\"\"><\/a><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-223-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"2 Easy Hacks to Convert XML to Excel\" class=\"alignnone size-full wp-image-29154\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-223-1.png\" alt=\"2 Easy Hacks to Convert XML to Excel\" width=\"872\" height=\"344\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-223-1.png 872w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-223-1-300x118.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-223-1-768x303.png 768w\" sizes=\"(max-width: 872px) 100vw, 872px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 6:<\/span> <\/strong>Select the\u00a0<strong class=\"ky ew\">XML Data Source<\/strong> in the left panel. Here, we will click on &#8220;row&#8221;.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-253.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"2 Easy Hacks to Convert XML to Excel\" class=\"alignnone size-full wp-image-29101\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-253.png\" alt=\"2 Easy Hacks to Convert XML to Excel\" width=\"1095\" height=\"873\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-253.png 1095w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-253-300x239.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-253-1024x816.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-253-768x612.png 768w\" sizes=\"(max-width: 1095px) 100vw, 1095px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 7:<\/span> <\/strong>A <strong>preview <\/strong>will be shown, if it looks good click<strong> Load<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-255.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"2 Easy Hacks to Convert XML to Excel\" class=\"alignnone size-full wp-image-29103\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-255.png\" alt=\"2 Easy Hacks to Convert XML to Excel\" width=\"1095\" height=\"873\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-255.png 1095w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-255-300x239.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-255-1024x816.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-255-768x612.png 768w\" sizes=\"(max-width: 1095px) 100vw, 1095px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 8:<\/span> <\/strong>A <b>new worksheet <\/b>will be added with the XML data in it.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-256.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"2 Easy Hacks to Convert XML to Excel\" class=\"alignnone size-full wp-image-29104\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-256.png\" alt=\"2 Easy Hacks to Convert XML to Excel\" width=\"1906\" height=\"953\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-256.png 1906w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-256-300x150.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-256-1024x512.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-256-768x384.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-256-1536x768.png 1536w\" sizes=\"(max-width: 1906px) 100vw, 1906px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 9:<\/span> Press Ctrl + S to save the file.<\/strong><\/p>\n<p>This will successfully convert XML to Excel from a web URL.<\/p>\n<p>&nbsp;<\/p>\n<p><em><strong>Bonus tip<\/strong> &#8211; Whenever <strong>data is updated<\/strong> in the XML file, the same will be reflected in the Excel file. You just need to<strong> right-click<\/strong> on the Excel table and select <strong>Refresh<\/strong>.<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-221.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"2 Easy Hacks to Convert XML to Excel\" class=\"alignnone size-full wp-image-29059\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-221.png\" alt=\"2 Easy Hacks to Convert XML to Excel\" width=\"707\" height=\"897\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-221.png 707w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-221-236x300.png 236w\" sizes=\"(max-width: 707px) 100vw, 707px\" \/><\/a><\/p>\n<p>Power Query can easily extract data from XML files and convert them into Excel. The file can either be saved on your system or available on a webpage. In the first example, the data was downloaded into your system but in the second example, the data was extracted directly from the webpage.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you want to transfer large datasets from one system to another, it is essential to know how to convert XML to Excel in detail. XML (or Extensible Markup Language) is a text-based formatting language that is just like HTML. It is used to store and transport data in a structured format. It is a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":29341,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"2 Easy Hacks to Convert XML to Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[648],"tags":[1225,1223,1224],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/29038"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=29038"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/29038\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/29341"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=29038"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=29038"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=29038"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}