What MIME type should I use for CSV

Question

I ve seen application csv used and also text csv  Is there a difference   Does it matter which as long as the request matches something that s available   Are they interchangeable

User · Answer

You should use  text csv  according to RFC 4180

User · Answer

My users are allowed to upload CSV files and text csv and application csv did not appear by now  These are the ones identified through finfo     text plain text x-csv   And these are the ones transmitted through the browser   text plain application vnd ms-excel text x-csv   The following types did not appear  but could   application csv application x-csv text csv text comma-separated-values text x-comma-separated-values text tab-separated-values

User · Answer

For anyone struggling with Google API mimeType for   csv files  I have found the list of MIME types for google api docs files  look at snipped result   x000D   x000D   lt table border  1  gt  lt thead gt  lt tr gt  lt th gt Google Doc Format lt  th gt  lt th gt Conversion Format lt  th gt  lt th gt Corresponding MIME type lt  th gt  lt  tr gt  lt  thead gt  lt tbody gt  lt tr gt  lt td gt Documents lt  td gt  lt td gt HTML lt  td gt  lt td gt text html lt  td gt  lt  tr gt  lt tr gt  lt  tr gt  lt tr gt  lt td gt  lt  td gt  lt td gt HTML  zipped  lt  td gt  lt td gt application zip lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt  td gt  lt td gt Plain text lt  td gt  lt td gt text plain lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt  td gt  lt td gt Rich text lt  td gt  lt td gt application rtf lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt  td gt  lt td gt Open Office doc lt  td gt  lt td gt application vnd oasis opendocument text lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt  td gt  lt td gt PDF lt  td gt  lt td gt application pdf lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt  td gt  lt td gt MS Word document lt  td gt  lt td gt application vnd openxmlformats-officedocument wordprocessingml document lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt  td gt  lt td gt EPUB lt  td gt  lt td gt application epub zip lt  td gt  lt  tr gt  lt tr gt  lt td gt Spreadsheets lt  td gt  lt td gt MS Excel lt  td gt  lt td gt application vnd openxmlformats-officedocument spreadsheetml sheet lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt  td gt  lt td gt Open Office sheet lt  td gt  lt td gt application x-vnd oasis opendocument spreadsheet lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt  td gt  lt td gt PDF lt  td gt  lt td gt application pdf lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt  td gt  lt td gt CSV  first sheet only  lt  td gt  lt td gt text csv lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt  td gt  lt td gt TSV  first sheet only  lt  td gt  lt td gt text tab-separated-values lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt  td gt  lt td gt HTML  zipped  lt  td gt  lt td gt application zip lt  td gt  lt  tr gt  lt tr gt  lt  tr gt  lt tr gt  lt td gt Drawings lt  td gt  lt td gt JPEG lt  td gt  lt td gt image jpeg lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt  td gt  lt td gt PNG lt  td gt  lt td gt image png lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt  td gt  lt td gt SVG lt  td gt  lt td gt image svg xml lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt  td gt  lt td gt PDF lt  td gt  lt td gt application pdf lt  td gt  lt  tr gt  lt tr gt  lt td gt Presentations lt  td gt  lt td gt MS PowerPoint lt  td gt  lt td gt application vnd openxmlformats-officedocument presentationml presentation lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt  td gt  lt td gt Open Office presentation lt  td gt  lt td gt application vnd oasis opendocument presentation lt  td gt  lt  tr gt  lt tr gt  lt  tr gt  lt tr gt  lt td gt  lt  td gt  lt td gt PDF lt  td gt  lt td gt application pdf lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt  td gt  lt td gt Plain text lt  td gt  lt td gt text plain lt  td gt  lt  tr gt  lt tr gt  lt td gt Apps Scripts lt  td gt  lt td gt JSON lt  td gt  lt td gt application vnd google-apps script json lt  td gt  lt  tr gt  lt  tbody gt  lt  table gt  x000D   x000D   x000D    Source here  https   developers google com drive v3 web manage-downloads downloading google documents the table under   Google Doc formats and supported export MIME types map to each other as follows   There is also another list    x000D   x000D   lt table border  1  gt  lt thead gt  lt tr gt  lt th gt MIME Type lt  th gt  lt th gt Description lt  th gt  lt  tr gt  lt  thead gt  lt tbody gt  lt tr gt  lt td gt  lt code gt  lt span gt application vnd  lt wbr gt google-apps  lt wbr gt audio lt  span gt  lt  code gt  lt  td gt  lt td gt  lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt code gt  lt span gt application vnd  lt wbr gt google-apps  lt wbr gt document lt  span gt  lt  code gt  lt  td gt  lt td gt Google Docs lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt code gt  lt span gt application vnd  lt wbr gt google-apps  lt wbr gt drawing lt  span gt  lt  code gt  lt  td gt  lt td gt Google Drawing lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt code gt  lt span gt application vnd  lt wbr gt google-apps  lt wbr gt file lt  span gt  lt  code gt  lt  td gt  lt td gt Google Drive file lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt code gt  lt span gt application vnd  lt wbr gt google-apps  lt wbr gt folder lt  span gt  lt  code gt  lt  td gt  lt td gt Google Drive folder lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt code gt  lt span gt application vnd  lt wbr gt google-apps  lt wbr gt form lt  span gt  lt  code gt  lt  td gt  lt td gt Google Forms lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt code gt  lt span gt application vnd  lt wbr gt google-apps  lt wbr gt fusiontable lt  span gt  lt  code gt  lt  td gt  lt td gt Google Fusion Tables lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt code gt  lt span gt application vnd  lt wbr gt google-apps  lt wbr gt map lt  span gt  lt  code gt  lt  td gt  lt td gt Google My Maps lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt code gt  lt span gt application vnd  lt wbr gt google-apps  lt wbr gt photo lt  span gt  lt  code gt  lt  td gt  lt td gt  lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt code gt  lt span gt application vnd  lt wbr gt google-apps  lt wbr gt presentation lt  span gt  lt  code gt  lt  td gt  lt td gt Google Slides lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt code gt  lt span gt application vnd  lt wbr gt google-apps  lt wbr gt script lt  span gt  lt  code gt  lt  td gt  lt td gt Google Apps Scripts lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt code gt  lt span gt application vnd  lt wbr gt google-apps  lt wbr gt site lt  span gt  lt  code gt  lt  td gt  lt td gt Google Sites lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt code gt  lt span gt application vnd  lt wbr gt google-apps  lt wbr gt spreadsheet lt  span gt  lt  code gt  lt  td gt  lt td gt Google Sheets lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt code gt  lt span gt application vnd  lt wbr gt google-apps  lt wbr gt unknown lt  span gt  lt  code gt  lt  td gt  lt td gt  lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt code gt  lt span gt application vnd  lt wbr gt google-apps  lt wbr gt video lt  span gt  lt  code gt  lt  td gt  lt td gt  lt  td gt  lt  tr gt  lt tr gt  lt td gt  lt code gt  lt span gt application vnd  lt wbr gt google-apps  lt wbr gt drive-sdk lt  span gt  lt  code gt  lt  td gt  lt td gt 3rd party shortcut lt  td gt  lt  tr gt  lt  tbody gt  lt  table gt  x000D   x000D   x000D    Source here  https   developers google com drive v3 web mime-types  But the first one was more helpful for my use case     Happy coding

User · Answer

Strange behavior with MS Excel  If i export to  text based  comma-separated format  csv   this is the mime-type I get after uploading on my webserver    name    gt  data csv  type    gt  application vnd ms-excel   So Microsoft seems to be doing own things again  regardless of existing standards  https   en wikipedia org wiki Comma-separated values

User · Answer

RFC 7111  There is an RFC which covers it and says to use text csv   This RFC updates RFC 4180     Excel  Recently I discovered an explicit mimetype for Excel application vnd ms-excel  It was registered with IANA in  96  Note the concerns raised about being at the mercy of the sender and having your machine violated       Media Type  application vnd ms-excel      Name             Microsoft Excel  tm       Required parameters       None      Optional parameters       name      Encoding considerations   base64 preferred      Security considerations   As with most application types this data is   intended for interpretation by a program that understands the data on   the recipient s system  Recipients need to understand that they are at   the  mercy  of the sender  when receiving this type of data  since   data will be executed on their system  and the security of their   machines can be violated        OID                org-id ms-files 4  ms-excel  3         Object type      spreadsheet      Comments         This Media Type OID is used to identify Microsoft   Excel generically  i e   independent of version  subtype  or platform format     I wasn t aware that vendor extensions were allowed  Check out this answer to find out more - thanks starbeamrainbowlabs for the reference

[csv] What MIME type should I use for CSV?

Examples related to csv

Examples related to http-headers

Examples related to mime-types

Examples related to content-type