title: Google Sheets - Importxml - csv file parsing
body: <p>Google Sheets importxml() says it can import csv files, but I can't find any examples on how to parse them (just examples on traditional xml files).</p>
  
  <p>Here's my csv target file, and my foolish attempts at an xpath statement.</p>
  
  <pre><code>=IMPORTXML("http://data.gov.au/dataset/b1bc6077-dadd-4f61-9f8c-002ab2cdff10/resource/13ca6df3-f6c9-42a1-bb20-6e2c12fe9d94/download/australianpublicholidays.csv","//a/@href")
  </code></pre>
  
  <p>I'm a total noob at xpath, so any benevolence appreciated...</p>
  
  <p>Oh and extra points if you can hint out how to transform the 'Date' column in this dataset into a date type column in the Google Sheets in the same xpath query.</p>