Edit CSV files present in document library using Microsoft Excel

Hi all

I have a document library with CSV files uploaded. I have used the below mapping in DOCICON.xml present in \14\TEMPLATE\XML folder.

<Mapping Key="csv" Value="csv16.gif" EditText="Microsoft Excel" OpenControl="SharePoint.OpenDocuments"/>

And I modified mime type with "application/vnd.ms-excel" for csv in IIS7. Now, when i click on the file  popup is getting displayed with 2 Radio Buttons.

1) Read Only

2)Edit

When i select "Read Only", the file is opening in Microsoft Excel in readonly mode But when i select "Edit", the file is opening in Note pad and its editable.

Now, My requirement is to edit the csv file in Microsoft Excel not in NotPad.

Can Any one help me to acheive this!! Thanks in advance.

June 5th, 2014 5:35am

Try below:

http://nickgrattan.wordpress.com/2011/01/05/sharepoint-opening-csv-files-with-microsoft-excel/

  1. Run the Internet Information Services (IIS) Manager application from the Start/Administrative tools menu.
  2. Select the server in the left-hand pane.
  3. Select MIME Types in the list of options in the middle pane.
  4. Then locate the .CSV entry (it should already exist) and change the MIME type to: application/vnd.ms-excel, and click OK.

Free Windows Admin Tool Kit Click here and download it now
June 5th, 2014 7:17am

Thanks for the reply.. I have modified in IIS7 but there is no change :(

June 5th, 2014 8:37am

Did you perform IISreset on all servers

Try IE inprivate mode as well

Free Windows Admin Tool Kit Click here and download it now
June 6th, 2014 12:35am

I have tried but of no change..

June 6th, 2014 3:37am

Please send a fiddler trace of the event
Free Windows Admin Tool Kit Click here and download it now
June 6th, 2014 5:08am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics