2

We are using SharePoint 2010. I have permission (full access) on my site. I have three uploaded files (one Word .doc, one Excel .xls, one CSV .csv).

I had no problems editing Word and Excel files. But I could not edit CSV file. Even "Edit Document" button on CSV file was disabled (greyed off). The file is a read-only file.

Could anyone help me on this issue? Why does CSV file have difference behavior from other file formats in SharePoint? I tried to search but could not find anything from the web.

Improve this question

1 Answer 1

Reset to default
3

Add the following to DOCICON.XML (default location is C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML) 

<Mapping Key="csv" Value="icxltx.png" OpenControl=""/>

Then in IIS Manager select the server and then select MIME Types, update the entry for csv to 'application/vnd.ms-excel'.

This will allow you to click the file name link and have the file open in Excel however the edit document button will still be disabled.

Source: http://nickgrattan.wordpress.com/2011/01/05/sharepoint-opening-csv-files-with-microsoft-excel/ (Nick Grattan’s SharePoint Blog)

Improve this answer
4
  • Thanks quila Sands! How can I make the Edit Document enabled for CSV file? Any suggestions? Thanks a lot. YK Commented Jul 17, 2012 at 18:22
  • 1
    @Yan. That will require some custom development to create an OpenDocuments control that knows how to handle a csv file. You could then specify this control in the OpenControl attribute of the Mapping XML element. This blog post has more info and a project that can provide a starting point. Commented Jul 18, 2012 at 9:50
  • 1
    Thank you very much Aquila Sands! After copy over xls's mapping then change xls to csv: <Mapping Key="csv" Value="icxltx.png" OpenControl="SharePoint.OpenDocuments"/>. CSV files now are editable from SharePoint. Issue resolved! Commented Jul 18, 2012 at 20:15
  • Please mark the answer appropriately so anyone could benefit from! Commented Jan 13, 2013 at 10:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.