BatchTest XML results won't load in Excel

When I open (some) BatchTest Results.xml files in Excel they either won't open or are formatted wrong -- they look diagonal on the screen.

This happens when you have an illegal Target (e.g. email address or domain) in your source file. For example:

<CheckTLS test="BatchTestreceiver" version="V03.14.12">
  <Results format="xml-matrix">
    <Result>
      <eMailAddress>checktls.com</eMailAddress>
      <ConfidenceFactor>100</ConfidenceFactor>
    </Result>
    <Result>
      <eMailAddress>refusetls.checktls.com</eMailAddress>
      <ConfidenceFactor>0</ConfidenceFactor>
    </Result>
    <Result>
      <eMailAddress>bad@target@checktls.com</eMailAddress>
      <Error>bad email target</Error>
    </Result>
  </Results>
</CheckTLS>

To fix this you can:

• remove all bad targets from your source file
• use a text editor to remove all <Result> nodes that contain <Error> nodes from Results.xml
• load the result in some other XML viewing program besides Excel