title: Excel to XML Namespace Prefix Customization
body: <p>I am using Excel 2013 to convert data from a spreadsheet into XML format by using an XML map.  The conversion works well, but Excel defaults all XML namespace prefixes in the output file to "ns1", as shown in the code below.</p>
  
  <p><strong>XML to Excel Conversion</strong></p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8" standalone="yes"?&gt;
      &lt;ns1:CarrierInterface xmlns:ns1="http:/exampleurl.com/"&gt;
      &lt;ns1:Sender&gt;sender&lt;/ns1:Sender&gt;
      &lt;ns1:Receiver&gt;receiver&lt;/ns1:Receiver&gt;
      &lt;ns1:RecordCount&gt;1&lt;/ns1:RecordCount&gt;
      &lt;ns1:SequenceID&gt;143&lt;/ns1:SequenceID&gt;
      &lt;ns1:Device&gt;
          &lt;ns1:ID&gt;123456789&lt;/ns1:ID&gt;
          &lt;ns1:Make&gt;make&lt;/ns1:Make&gt;
          &lt;ns1:Model&gt;model&lt;/ns1:Model&gt;
          &lt;ns1:ModelYear&gt;2017&lt;/ns1:ModelYear&gt;
          &lt;ns1:DeviceWiFiType&gt;True&lt;/ns1:DeviceWiFiType&gt;
          &lt;ns1:PairingState&gt;Initial&lt;/ns1:PairingState&gt;
      &lt;/ns1:Device&gt;
  &lt;/ns1:CarrierInterface&gt;
  </code></pre>
  
  <p><strong>Desired Output</strong></p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt; 
      &lt;carrierInterface:CarrierInterface     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:carrierInterface="http:/exampleurl.com/" xsi:schemaLocation="http:/exampleurl.com/"&gt; 
      &lt;carrierInterface:Sender&gt;sender&lt;/carrierInterface:Sender&gt; 
      &lt;carrierInterface:Receiver&gt;receiver&lt;/carrierInterface:Receiver&gt; 
      &lt;carrierInterface:RecordCount&gt;1&lt;/carrierInterface:RecordCount&gt; 
      &lt;carrierInterface:SequenceID&gt;143&lt;/carrierInterface:SequenceID&gt; 
      &lt;carrierInterface:Device&gt; 
         &lt;carrierInterface:ID&gt;123456789&lt;/carrierInterface:ICCID&gt; 
         &lt;carrierInterface:Make&gt;make&lt;/carrierInterface:Make&gt;  
         &lt;carrierInterface:Model&gt;model&lt;/carrierInterface:Model&gt; 
         &lt;carrierInterface:ModelYear&gt;2017&lt;/carrierInterface:ModelYear&gt; 
         &lt;carrierInterface:DeviceWiFiType&gt;True&lt;/carrierInterface:DeviceWiFiType&gt; 
         &lt;carrierInterface:PairingState&gt;Initial&lt;/carrierInterface:PairingState&gt; 
      &lt;/carrierInterface:Device&gt; 
  &lt;/carrierInterface:CarrierInterface&gt; 
  </code></pre>
  
  <p>Is anyone aware of an easy way to customize these namespace prefixes without having to write a macro?  Also, does anyone know why Excel drops the URLs given for CarrierInterface's namespace definition shown in the following lines?</p>
  
  <p><strong>Desired Output</strong></p>
  
  <pre><code>&lt;carrierInterface:CarrierInterface     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:carrierInterface="http:/exampleurl.com/" xsi:schemaLocation="http:/exampleurl.com/"&gt;
  </code></pre>
  
  <p><strong>Actual Output</strong></p>
  
  <pre><code>&lt;ns1:CarrierInterface xmlns:ns1="http:/exampleurl.com/"&gt;
  </code></pre>