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?
 
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
 
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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.