title: Extract certain data from multiple XML files into excel
body: <p>I have over a 1000 XML files, all with different data, but the same tags</p>
  
  <pre><code>&lt;Title&gt;
      &lt;LocalTitle&gt;12 Years a Slave&lt;/LocalTitle&gt;
      &lt;OriginalTitle&gt;12 Years a Slave&lt;/OriginalTitle&gt;
      &lt;ProductionYear&gt;2013&lt;/ProductionYear&gt;
      &lt;Added&gt;23/05/2015 15:42:03&lt;/Added&gt;
      &lt;IMDBrating&gt;8,1&lt;/IMDBrating&gt;
      &lt;ContentRating&gt;R&lt;/ContentRating&gt;
      &lt;MPAARating&gt;R&lt;/MPAARating&gt;
      &lt;IMDB&gt;tt2024544&lt;/IMDB&gt;
      &lt;IMDbId&gt;tt2024544&lt;/IMDbId&gt;
      &lt;TMDbId&gt;76203&lt;/TMDbId&gt;
      &lt;Budget&gt;20000000&lt;/Budget&gt;
      &lt;Revenue&gt;187&lt;/Revenue&gt;
      &lt;Language&gt;English&lt;/Language&gt;
      &lt;LanguageCode&gt;en&lt;/LanguageCode&gt;
      &lt;Country&gt;GB&lt;/Country&gt;
      &lt;RunningTime&gt;134&lt;/RunningTime&gt;
      &lt;Overview&gt;In the antebellum United States,&lt;/Overview&gt;
      &lt;Genres&gt;
          &lt;Genre&gt;Biography&lt;/Genre&gt;
          &lt;Genre&gt;Drama&lt;/Genre&gt;
          &lt;Genre&gt;History&lt;/Genre&gt;
      &lt;/Genres&gt;
  &lt;/Title&gt;
  </code></pre>
  
  <p>I only need to extract certain tags from all my XML files into an excel file (like only the <code>LocalTitle</code>, <code>ProductionYear</code>, <code>IMDBRating</code> and <code>IMDBId</code>) How can I do this without spending hours copy-ing and pasting?</p>