After you have installed and configured SharePoint and start adding documents you may notice that not all files are handled the same. Office documents (*.doc, *.docx, *.xls, *.xlsx) open in Word and Excel fine. But then you try to open a CSV file and you are prompted to download it instead of opening in Excel.
Well there is a fairly simple fix for that. We just need to make 2 small changes.
These steps relate to SharePoint Foundation. If you are using WSS3.0 replace 14 with 12 in the file paths.
1. Select an appropriate CSV file icon
The icons needs to be save here:
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\IMAGES
2. Modify DOCICON.XML
You will have to open your text editor as administrator to be able to save this file. It can be found here:
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML
Add the following line in the ByExtension section
< ByExtension > ... < Mapping Key="csv" Value="iccsv.png" EditText="Microsoft Excel" OpenControl="SharePoint.OpenDocuments"/> ... < /ByExtension >
3. Restart IIS
Open a command window as an Administrator and run iisreset
Here are a few examples.This same process can be used for other files types as well.
<Mapping Key="zip" Value="iczip.gif" EditText="WinZip" OpenControl="SharePoint.OpenDocuments"></mapping> <Mapping Key="pdf" Value="icpdf.gif"></mapping>