convert xml to csv
I'm getting xml back with CSV data but when it loads into excel it fails and returns an empty worksheet. How do i fix this? This is the XML i am receiving.How do i set it up so that it loads directly into excel.
<Response><ResponseWrapper><CSV>CustomerPartyID,La st/Business Name,First Name,Middle Name,Birth Date,ABN,Product Code,Product Name,Contract Number,Employer Number,Employer Name,Relationship to Contract,Contract Status,Address Line 1,Address Line 2,Address Line 3,Address Line 4,PostCode,Suburb,State,Personal Email Address,Business Email Address,Home Phone Number,Business Phone Number,Mobile Phone Number,
1,Block,T,M,01/08/199,,P,Guaranteed ,N33Z,,Ann,Active,49 WAV ,HORSH NSW,,,0900,HORSH,NSW,,,,,,