HTML Input="file" Accept Attribute File Type (CSV)?

Question

I have a file upload object on my page: with the following excel files on my desktop:> 1. file1.xlsx > 2. file1.xls> 3. file.csv I want the file upload to ***ONLY*** show `.xlsx`, `.xls`, & `.csv` files. Using the `accept` attribute, I found these content-types took care of `.xlsx` & `.xls` extensions... > `accept`= application/vnd.openxmlformats-officedocument.spreadsheetml.sheet (.XLSX)> `accept`= application/vnd.ms-excel (.XLS)However, I cannot find the correct content-type for an Excel CSV file! Any suggestions? EXAMPLE:

Answer 1

You don't need the content-type, you can use either the content-type or the extension (like `.xls`). That said, you generally should offer both when you can, because sometimes a given file is missing one piece of information or the other.

If you want to include the content-type of Excel CSV, it's `text/plain`. This will allow a lot of non-CSV files, however, since it's the content type of all plain-text files.

Therefore either of these would make sense:

Without the content type

<input type="file" accept=".xlsx,.xls,.csv,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/vnd.ms-excel">

Or

With the content-type

<input type="file" accept=".xlsx,.xls,.csv,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/vnd.ms-excel,text/plain">