Response Content type as CSV

Question

I need to send a CSV file in HTTP response. How can I set the output response as CSV format?

This is not working:

Response.ContentType = "application/CSV"; 

Answer 1

Using text/csv is the most appropriate type.

You should also consider adding a Content-Disposition header to the response. Often a text/csv will be loaded by a Internet Explorer directly into a hosted instance of Excel. This may or may not be a desirable result.

Response.AddHeader("Content-Disposition", "attachment;filename=myfilename.csv"); 

The above will cause a file "Save as" dialog to appear which may be what you intend.

Answer 2

MIME type of the CSV is text/csv according to RFC 4180.