Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Convert XML to Excel? – 2 Easy Methods 

How to Convert XML to Excel? – 2 Easy Methods 

If you regularly deal with databases in your day-to-day work, you may have already come across the XML file format. It is a widely used popular database format on the internet. 

However, it cannot be directly accessed or used by humans like other formats such as PDFs, Excel sheets, and Word Docs, since it is mainly stored in a machine-readable format. 

XML stands for “extensible markup language”, which is similar to HTML. But unlike HTML, it makes use of custom tags to store any information in a structured database. This gives it the powerful ability to easily store, search and retrieve data at the hit of a button. 

But don’t worry. In this guide, we will see how to convert XML to Excel spreadsheets, the easy way. 

You’ll learn:

  • Method 1 – How to Convert XML to Excel?
  • Method 2 – How to Import an XML File From the Internet into Excel?

Related:

The 7 Golden Rules of Excel Spreadsheet Design

How to Fix the #Div/0 Error in Excel? 2 Easy Methods

How to Fix the Excel Spill Error? — 5 Easy Fixes

Method 1 – How to Convert XML to Excel?

If you already have an XML file saved locally on your computer, you can follow these steps:

  1. Open any blank Excel sheet where you want to import the XML 
  2. Go to the DATA tab and select the ‘Get Data’ button in the Get & Transform group.  
Click on the Get Data button in the Data tab
Click on the Get Data button in the Data tab
  1. From the drop-down list click on From File > From XML. 
Click on From File > From XML
Click on From File > From XML
  1. Now, locate the XML file locally saved on your computer and click on the Import button. 
Locate and Import the relevant XML file
Locate and Import the relevant XML file
  1. Doing this will open the Navigator dialog box. Here once again click on the XML file you want to import and click on the Load button. Alternatively, you can click on the Transform button if you want to modify any columns in the XML file. This is completely optional. 
Select the XML file and click on Upload
Select the XML file and click on Upload


That’s all folks. Excel will immediately import all the data from the XML file into a new sheet in the currently open workbook. 

Imported XML Data
Imported XML Data


Please note that this import is dynamic in nature. That is, any changes made in the original XML file will reflect in the copied Excel file. All you need to do is, just right-click on any cell and click on the Refresh button from the right-click menu. 

Right-click and Refresh to update any changes
Right-click and Refresh to update any changes

Also Read:

How to Apply the Accounting Number Format in Excel? (3 Best methods)

How to Autofit Excel Cells? 3 Best Methods

The FORMULATEXT Excel Function – 2 Best Examples


Method 2 – How to Import an XML File From the Internet into Excel?

In case you don’t have an XML file stored on your computer, but instead, have its URL from the internet, you can easily import it into Excel by following these steps: 

  1. Open any blank Excel workbook and click on the Get Data button in the Get & Transform group of the Data tab. (Basically, repeat the steps 1 & 2 from the previous method)
  2. Under the Drop-down menu, click on From Other Sources > From Web 
Click on From Other Sources > From Web
Click on From Other Sources > From Web
  1. Now, paste the URL of the XML file in the From Web dialog box and click OK. 
Enter the XML URL and Click OK
Enter the XML URL and Click OK
  1. If prompted, press Connect. Doing so will take you to the Navigator window. Now, select the XML file and click Load to insert the XML file into the workbook. 

Here also, any changes in the source XML file will reflect in the Excel file. 

Please note that all imported data will be stored in the Table format. 

Suggested Reads:

How to Group Worksheets in Excel? (In 3 Simple Steps)

How to Shade Every Other Row in Excel? (5 Best Methods)

How to Use the Excel Fill Handle Easily? (Top 3 Uses with Examples)

Closing Thoughts

In this guide, we saw how to convert XML to Excel using two easy methods. Many people are simply ignorant of these methods and end up using spammy online XML to Excel converters. 

Just follow this guide, and enjoy a hassle-free XML to Excel conversion. Please do let us know if you have any questions as we are always happy to help. 

Please visit our free resources center for more high-quality guides on Excel and other Microsoft Suite applications.

Ready to dive deep into Excel? Click here for advanced Excel courses with in-depth training modules.

Simon Sez IT has been teaching Excel and other business software for over ten years. For a low, monthly fee you can get access to 100+ IT training courses. 

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

How to Set Up Customers and Jobs in QuickBooks 2019

How to Setup Calendar Options in Outlook 2013

How to Recover a Word Document ? 4 Proven Ways

How to Insert a Placeholder in Word? 2 Different Types

How To Create A Kanban Board In Excel?

Compare Two Lists Using VLOOKUP

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)