title: Google Sheets "Imported Xml content can not be parsed" when importing data via Skyscanner
body: <p>I've been struggling with importing XML into Google Sheets where in most instances this is working fine. I've tried externally validating the XML and also trying to isolate the problem before coming up with two potential issues:</p>
  
  <ol>
  <li><p>Google Sheets cannot support the length of the XML</p></li>
  <li><p>Google Sheets finds an issue with the header of the XML</p></li>
  </ol>
  
  <p>Any support would be very much appreciated. Spent hours on this when I'm sure the solution is incredibly simple. Many thanks.</p>
  
  <p>XML used is here: <a href="https://pastebin.com/dRsTVzEg" rel="nofollow noreferrer">https://pastebin.com/dRsTVzEg</a></p>
  
  <p>API call used is: <a href="http://partners.api.skyscanner.net/apiservices/browseroutes/v1.0/NZ/NZD/en-GB/NZ/AU/2017-11/2017-12?apiKey=" rel="nofollow noreferrer">http://partners.api.skyscanner.net/apiservices/browseroutes/v1.0/NZ/NZD/en-GB/NZ/AU/2017-11/2017-12?apiKey=</a>{KEY}</p>