Excel for Decision Making
May 8, 2014
Hi I am looking for tips for importing xml files.
I have stepped through the process using import from xml, but i Have more than one table in the structure and I seem to drop some of the data.
I have opened the file directly in Excel and this gives me the best version of the data so far, but the structure is still not clean as far as I tell.
I have also opened the file in Xml notepad so I can get a view of the structure.
I am aiming to import a number of files from a folder as my end goal. I am happy to convert to xlsx first if I can get a good conversion, or directly from xml.
Any help appreciated.
July 16, 2010
When you import the file you should get a dialog that allows you to choose the tables in the XML file. Do you see more than one table? If not, you can import the file twice and get the two (or more) sets of data one at a time.
It's a bit difficult to give you specific tips without seeing the file and knowing what you want to extract from it. If you can share the file we're happy to take a look.
Most Users Ever Online: 57
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas