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


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>

You may also like

SharePoint backup script using PowerShell

Keep Reading

Remote Desktop Connection Manager

Anyone who works in a development environment will eventually have to manage more than 1 server. It may be many internal web or database servers for development, staging and production environments or just the occasional client server for deployment. Either way keeping track of all these connections can be come difficult.

Keep Reading

Newsletter sign up

Every couple of months we send out an update on what's been happening around our office and the web. Sign up and see what you think. And of course, we never spam.