Hi there, I have a question, hope someone can help. I have excel documents uploaded to sharepoint that contain pricing information. Each document has a "Total Cost" column. Is there a way to get the column to appear under a Sharepoint column called "Total Cost"? So when I enter the document library, each excel file will have this column beside the name of the file. It would save me going into the file just to get the cost. Does this make sense?If you need any further information, please let me know. Thanks in advance for any responses. Jack.

Hello, I think you have to write some code . Get the file name from the file.DisplayName and read the Total cell in spreadsheet to display the value. Pradeep

you can import your excel columns using this http://spreadsheet2splist.codeplex.com/ otherwise you need to make a custom handler for your excel file to read your content into your SP list hope this helps

Thanks for the responmse guys. I will give the spreadsheetsplit a go and see how I get on. Doe sit need to be installed on the server where sharepoint is hosted?