title: Options for formatting xml or CSV for reporting in text or Word format
body: <p>We subscribe to a database that lets us export our data in csv, Excel or XML format. We have some reports that would be far better going down a page, rather than across, and I'm trying to work out the simplest way for our non technical users to be print a usable report for meetings. I suspect I may be missing something obvious!</p>
  
  <p>e.g. the csv the user exports would have these headings:</p>
  
  <pre><code>title, subtitle, about the project, launch date, key factors to consider, key market
  </code></pre>
  
  <p>When formatted across an Excel page, the longer text becomes unreadable and doesn't print well. We would ideally want: </p>
  
  <pre><code>title
  [title here]
  
  subtitle
  [subtitle here]
  
  about the project
  [paragraph of text here]
  
  launch date
  [date here]
  
  key factors to consider
  [paragraph or two here]
  
  etc.
  </code></pre>
  
  <p>Our users are all on Windows and are not technical. I am aiming for a one or two step process to transform the files once they've been exported. It is likely we'd be dealing with a range of 1 to 100 rows of data to transform, and about 15 fields. </p>
  
  <p>Ideally, users would be able to change the fields exported from the database and still transform them to the tidy report format. </p>
  
  <p>I have considered (i.e. read about and briefly tried) the following options, and would appreciate guidance on anything I've missed, or which approach seems best for me to explore further. In all these cases they have seemed too complex to extend to users and just overly complicated for something that appears like it should be so simple. </p>
  
  <ul>
  <li><p>XML transformation in Word (but it appears the coding of XSLT has an incredibly steep learning curve)</p></li>
  <li><p>Mail Merge in Word from csv - providing users with a Word Template</p></li>
  <li><p>Macros in Excel to move the fields (not sure this would work for multiple records and be easy to print?)</p></li>
  <li><p>Build a tool on our intranet to ingest file and provide printable page(s). PHP or JavaScript?</p></li>
  </ul>
  
  <p>I have searched for solutions for XML transformation, XML to Word, Excel to Word, Excel to template, CSV to template and similar. </p>
  
  <p>I am hoping I am missing something obvious here and have just failed to think of the right search terms / simple solution. If so, I would really appreciate being shown the right direction. Thanks! </p>