Quote:
Originally Posted by SilentFox
I'm unsure if this is how its supposed to look in the template, but this is what I have 
Even pasting the results of Cell J the way the tutorial states in a blank spreadsheet just to see what it does, it ends up giving me a #REF error. Doesn't matter what column, its just giving me that. Either one of these parameters are wrong or something else is.
However, to answer your question, at first I put it just right under the very last name in what I could assume was the first names place, I just opened the names XML and tried to paste the output under the last entry
 |
This looks a lot to me like Excel (or Sheets if you're using Sheets) is taking in your XML and trying to parse it as a .csv, or else parsing the XML very, very badly. Those angle brackets denote individual records or properties and shouldn't be displayed like that.
Have you tried dropping that data into an XML editor, for instance this one that's available online?
https://jsonformatter.org/xml-editor