Register
Log In
Unanswered
Home
Excel for Decision Making
Power BI
May 8, 2014
Offline
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.
Thanks
Peter
July 16, 2010
Offline
Hi Peter,
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.
Mynda
Most Users Ever Online: 57
Currently Online:
16 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
sugi gunawan
janja mesec
John DiMartino
lizette acosta
eric johnson
Kim Bond
Nichelle Stevens
Manuel Rodriguez
peter wang
Amit Kanekar
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
