Excel 2013 - importing an XML file

I'm trying to import the the attached XML file into Excel 2013. It's a MusicXML exported by a notation software called Notion.
When I try importing via Data > From Other Sources > From XML Data Import I get the attached error.

The attached XSD file was obtained from here http://www.musicxml.com/for-developers/ (do I need this XSD file? Or any other?)

How can I successfully import the XML file into Excel?
Thanks
XML-import-error.JPG
Yes-it-is---20150315.xml
musicxml.xsd
hindersalivaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Michael FowlerSolutions ConsultantCommented:
The problem is with the Doctype declaration. Quickest solution is to delete this from the xml. Then when you load it just ok the message and it will load correctly
0
hindersalivaAuthor Commented:
Hi Michael, is it just this that I need to remove?
<!DOCTYPE score-partwise PUBLIC
    "-//Recordare//DTD MusicXML 1.1 Partwise//EN"
    "http://www.musicxml.org/dtds/partwise.dtd">

Removing just that gave the same error.
Is there a closing tag to remove also?

Thanks
0
Michael FowlerSolutions ConsultantCommented:
Yes I just removed those lines and then when I loaded the XML Excel gave a message that the XML does not refer to a schema and will create a schema based on the data. Once I selected OK to this message the data loaded fine.

I have attached the XML and excel sheet I used
Yes-it-is---20150315.xml
Book1.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
OWASP: Threats Fundamentals

Learn the top ten threats that are present in modern web-application development and how to protect your business from them.

hindersalivaAuthor Commented:
Perfect!
Thank you Michael74.

I got one more related question ... would I use the XSD file to specify a schema? and if so how would I tell Excel to use it?
0
Michael FowlerSolutions ConsultantCommented:
You can reference a local xsd with something like

<score-partwise version='1.1' xmlns="http://www.w3schools.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.w3schools.com file:///C://Users//USERNAME//Desktop//musicxml.xsd">
  <work>

Open in new window


problem is I could not get the XSD to work
0
hindersalivaAuthor Commented:
Thanks Michael!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.