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

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.

Have a great day!

[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

[sir.]

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

[DXthaTriFctA]

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

[jiil]

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.

[Oliver_]

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 ??

[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.

[jiil]

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

[jiil]

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

[fordfiveohh]

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

[IdNtHte]

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?

[sathyanarayanansatagopan]

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

[zaidabdoelrahman]

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

[hp]

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

[DaeViZn]

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 :(

[de]

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

[mustafaayubi]

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

[adityashirvalkar]

Thanks a lot your video was really helpful! :)

[juanblonval]

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

[roberto]

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

[anitaahirwar]

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