How to use the CSV MIME-type

Question

In a web application I am working on  the user can click on a link to a CSV file   There is no header set for the mime-type  so the browser just renders it as text   I would like for this file to be sent as a  csv file  so the user can directly open it with calc  excel  gnumeric  etc     header  Content-Type  text csv    echo  cell 1  cell 2     This code works as expected on my computer  Isn t that how it always is   but does not work on another computer   My browser is a nightly build of FF 3 0 1  on linux    The browsers it did not work in were IE 7 and FF 3 0  on windows   Are there any quirks I am unaware of

User · Accepted Answer

You could try to force the browser to open a "Save As..." dialog by doing something like:

header('Content-type: text/csv');
header('Content-disposition: attachment;filename=MyVerySpecial.csv');
echo "cell 1, cell 2";

Which should work across most major browsers.

User · Answer

You are not specifying a language or framework  but the following header is used for file downloads    Content-Disposition  attachment  filename abc csv

User · Answer

This code can be used to export any file  including csv     application octet-stream tells the browser not to try to interpret the file header  Content-type  application octet-stream    header  Content-Length      filesize  data    header  Content-Disposition  attachment  filename  export csv

User · Answer

With Internet Explorer you often have to specify the Pragma  public header as well for the download to function properly    header  Pragma  public      Just my 2 cents

User · Answer

With Internet Explorer you often have to specify the Pragma  public header as well for the download to function properly    header  Pragma  public      Just my 2 cents

User · Answer

You are not specifying a language or framework  but the following header is used for file downloads    Content-Disposition  attachment  filename abc csv

User · Answer

You are not specifying a language or framework  but the following header is used for file downloads    Content-Disposition  attachment  filename abc csv

User · Answer

You are not specifying a language or framework  but the following header is used for file downloads    Content-Disposition  attachment  filename abc csv

User · Answer

This code can be used to export any file  including csv     application octet-stream tells the browser not to try to interpret the file header  Content-type  application octet-stream    header  Content-Length      filesize  data    header  Content-Disposition  attachment  filename  export csv

[php] How to use the CSV MIME-type?

Examples related to php

Examples related to csv

Examples related to http-headers

Examples related to mime