Data Analysis in Excel 7 - Quickly Import XML Files and Data into Excel

Excel Forum: www.teachexcel...
Excel Tutorials: www.teachexcel...
This Excel Video Tutorial shows you how to import XML files and data into Excel. You will learn how to import XML data formatted in the new Excel 2007 Table format as well as just formatted as plain text. This is a quick tutorial showing you how to import XML files into Excel but later tutorials will show you more tricks and tips for importing XML file data into Excel.
For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.
Have a great day!

[@sathyanarayanansatagopan9069]

Sir. Superb! Can you please make a video, by changing some data in the excel spreadsheet and then convert it into xml?

[@sharieindraswari5064]

many thanks, really help my work :*

[@zaidabdoelrahman]

Good how to video. When opening a XML file in Excel 2007, some rows have the "#####"" tags. What is the problem?

[@adityashirvalkar736]

Thanks a lot your video was really helpful! :)

[@theintelligentlight]

How do you import multiple XML files

[@popoften]

Using a text editor, check for garbage (non-xml) data at the end of your file. If found, delete it the garbage data, save file, and re-import.

[@ji98il]

Hi,
Thank You very much. However, I've another question. Is there anyway to extract keywords from the contend that I've pulled out from the xml file. E.g. the content of news is "Apple on Monday unveiled its hotly anticipated iTunes Radio " Can I extract the word iTunes to put under the category 'Technology' in an excel file

[@sir.636]

Data does not import properly into schema form. Is there a solution to this?

[@Id0N0tH4te]

I have a table with a ton of information. I have a working table, that can be refreshed (XML source). But if I want to get a diffrent XML with the exact same name/lay-out I can not get it working. Any idea?

[@ji98il]

Hi, I would like to ask a question. Why does it says "Invalid file reference. The path to the file is invalid, or one or more of the referenced schemas could not be found." for some xml files that I've tried to import. While some xml files do work perfectly.

[@ji98il]

Hi,
I got it.Thank you so much. However, after I've the contend that I want, do you have any idea on how I can futher classify my content into category by identifying keywords. E.g. I've pulled out my contend from Yahoo news rss feed, from there I'll have my content as "General Elections..." how can I identify 'Elections' as a keyword to put it under Politics as the category

[@1302de]

in which file extension you save it?
i need an odx converter in txt. Odx is XML based

[@TeachExcel]

@D3XthaTriF3ctA The problem is that a lot has changed since Excel 2000 and I don't currently have access to that Excel version. I would recommend upgrading to at least Excel 2007 - then you can check out all of my new tutorials at teachmsoffice. com

[@D3XthaTriF3ctA]

What if i have an excel template and I need to get the XML data DIRECTLY from the weblink? I can bring the info from the weblink onto the template, but it doesn't conform to the template, meaning the correct categories do not fill up correctly, it stays in HTML format. Anyway you could give me some advice? Plus im doing it on Excel 2000. Help is appreciated, thanks

[@Oliver_1800]

I have a question, its something like this:
Create a connection in cell A1 of the new worksheet to the e09c1flights.xml file.
Does this connection mean I have to simply import the xml file to excel ??

[@mustafaayubi8448]

Is it possible to imort files from Excel to firebirdDB ? thx

[@juanblonval]

Is it possible to import a XML file to Excel mac ?

[@173roberto]

How can you open many XML files into one single sheet?

[@fordfiveohh]

What if you have like... 200 thousand cells? How do you stream the data in with a vba macro or otherwise?

[@hp8449]

Hi, Can you please let me know if i can covert the same data to XML again? I tried doing that using Excel 2003 Add-ins but it does not seem to work. Please let me know if there is any way!!
Thanks

[@midsummer4864]

Thanks

[@DaeViZ0n3]

Throws an error on importing :/
invalid reference the path to the file is invalid or one or more of the referenced schemas could not be found
Pls help :(

[@anitaahirwar3093]

How can you import XML file having hierarchical data into Excel sheet?

[@kegs666]

Mine just crashes :(

[@fordfiveohh]

Should say 200 thousand records...