Microsoft Excel 2010: Import and Export XML

Excel 2010 tutorial on how to import an XML or Extensible Markup Language file into your Excel worksheet, and using Schemas as a set of rules that tells what kind of data, or fields can be used in the XML file; or in other words, the structure for the importing data.
All 154 of my Excel 2010 training videos contain everything you need to help pass both the Microsoft Office Excel 2010 Core (77-882), and Expert (77-888) exams and become certified!
ONLINE TRAINING: HD Videos - Ad free, Quizzes, Exercises, Instructor’s Notes & Certificate of Completion!
www.DreamForce.us
SUBSCRIBE to learn more Microsoft Office tips, tricks and shortcuts!
kzbin.info_c...
LET'S CONNECT!
-- / kirt-kershaw-33874410

[@joeuser9050]

This is by far the best XML tutorial that I have found. Easy to understand. Short and to the point. Clear instructions that I could easily adapt to my situtation. I have long been frustrated with trying to import XML data from my GPS/HRM watch. It does not come with a schema (xsd file). And I would suggest that Kirt adapt his presentation for that very common(?) situation. Using his instructions, first I use Excel to build the schema from the imported XML file. Then I build separate tables for the lap and (enclosed) trackpoint data. And magically, Excel imports the XML data into the separate tables. The result is much more usable than what I get if I import the XML directly into Excel. His instructions are a lot easier than writing my own VBA code to parse the XML file myself, as I had been doing. Once again, the best XML tutorial by far. Great job, Kirt!

[@colesteven7630]

This was exactly what I needed.

[@IPASAustralia]

A really good video at a good pace. You also have a very good voice for narration, too! Thanks for posting.

[@KirtKershaw]

Welcome 😊

[@hassanaadi5984]

thank you , very help helpful. how to do this if i have data with date format?? thank you

[@TheSneezingSniffler]

This is what i was looking for. I was importing an xml file direct into excel via open or from text to csv or from web, and i was losing all html codes and uni 8 codes. However, i still had to search somewhere else on "How to create a xsd file and how to get into developer mode in excel. I am typing this at 5 mins into the video so i am watching further .. i think maybe a tip "make it simple and quick" i am a new business owner" and still learning but i aint got the time to keep watching long complicated videos haha

[@mutindafestus5619]

How do you create a schema file????

[@mirrrvelll5164]

Splendid video! Can you just tell do Schema needs to have that kind of structure - I mean with all these "xsd, strings/int" and so on elements? That is for defining the format and structure? Is this official way of writing and preparing schemas? I am really new to it (to xml), and I found it actually that you can write schema on another way (I would say easier without all these definitions that you included). Thank you

[@linds8877]

This is great information, thank you. I am looking for a tutorial similar to the one above but for transforming a complete excel file (2000+ records) into XML. Do you have a video for this?

[@KirtKershaw]

Welcome :) VBA code might be the best way to go on this, but unfortunately at this time I haven't any extensive VBA videos that would help.

[@linds8877]

@@KirtKershaw no problem, thanks for the tip!

[@mauriciomunilla2769]

Very helpful. Thanks

[@KirtKershaw]

Welcome 😊

[@mohammedal-mudhafar4602]

Thanks a lot!

[@KirtKershaw]

Welcome 😊

[@frityz]

Notepad++ is very sueful to view XML files.

[@TheScytheMoron]

This videos is from 2018 and ... it has vista ... jeeez