title: Import CSV data from web service into Excel
body: <p>I have written a simple web service that returns large volumes of csv data.  I will to import this into Excel in a tabular format using Excel's "Data From Web" function.</p>
  
  <p>Is there a way to get Excel to automatically parse the csv fields returned into individual columns as part of the import operation?</p>
  
  <p>At present the only means I have for doing this is to first import the data into a single column and then write VBA code to select the data and split it using <code>TextToColumns</code>.  This feels messy / error-prone.</p>
  
  <p>The other alternative I have is to modify the web server to serve back the data as HTML.  However, I'm reluctant to do this as adding  tags around each csv field will greatly impact the volume of data returned.</p>