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
MarcusKochAsked:
Who is Participating?
 
jessc7Connect With a Mentor Commented:
Can't you just delete the standard view?
0
 
jessc7Commented:
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
0
 
jessc7Commented:
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.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
MarcusKochAuthor Commented:
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
0
 
MarcusKochAuthor Commented:
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.
0
 
jessc7Commented:
In SharPoint 2010 you can enable inline editing on the Standard view instead:

http://www.youtube.com/watch?v=HHb9dF9mo-g
0
 
MarcusKochAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.