asked on

How to import spreadsheat into sharepoint list with default spreadsheet view

I'm new to sharepoint. I imported a list from an excel spreadsheet. The imported list will always default to the standard view, but I would like to open the list in spreadsheet view as the standard. When I create a list in Sharepoint I have the option to choose standard or datasheet. I don't see this option when I import the excel spreadsheet. I also don't see an option to change the list afterwards. How can I accomplish to have the list in datasheet view in the quick launch?

Marcus

jessc7

You just need to create a new DataSheet View, and assign it as the default view.

Here is a short video I made after having imported a list from a simple Excel spreadsheet:

http://screencast.com/t/h1pxuIfCe

jessc7

I just noticed another post by you, where it looks like you are using WSS 3.0. My example was Foundation 2010.

The same concept applies, but the steps will be different. Create a new DataSheet View, and assign it as the default view.

MarcusKoch

ASKER

Thanks for the feedback. I know that I can create a second view and then set this as the default, but when I import a spreadsheet I always need to create a second view and teh view menu will display two views to choose from. Since I can still change the view between spreadsheet and standard via the action menu I would like to get rid of the standard view in the view menu.

When I create a new view inside WSS 3 I can have the default be spreadsheet view without having any other view in the view menu.

Marcus

ASKER CERTIFIED SOLUTION

jessc7

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

MarcusKoch

ASKER

Thanks for that tip. I wasn't aware that I can delete the 1st view. So by design it seems not to be possible to import directly in spreadsheet view. You need to create a second view, set it as a standard and then delete teh old view. Pff, a lot of work for a basic feature.

jessc7

In SharPoint 2010 you can enable inline editing on the Standard view instead:

http://www.youtube.com/watch?v=HHb9dF9mo-g

MarcusKoch

ASKER

Thanks for the tip. Unfortunately our provider won't update WSS3 to Sharepoint Foundation before Feb 2012. But since it is free for us I will stick with WSS3 until then.