Eric's profileiTrain Eric Ku BlogPhotosBlogListsMore Tools Help

Blog


    25 July

    How to convert Excel Spreadsheet into a SharePoint List

    Converting the spreadsheet into a list

    Here are the steps we took to convert an Excel spreadsheet to a SharePoint list.

    1. Browse to the Create page in your site by click on the All Site Content on the quick launch. 
    2. Click the Import Spreadsheet link in the Custom Lists section. The New List page opens.
    3. Type the name for the list in the Name field, and then type a description for the list in the Description field.
    4. Click the Browse button. Locate the Excel spreadsheet that contains the data you want in your list, then click on the file name, and then click the Open button.
    5. Click the Import button on the New List page. The Import to SharePoint list dialog box opens.
    6. Click the Range of Cells option in the Range Type drop down list.


       
    7. Click the button on the Select Range drop down list. Your Excel spreadsheet opens with the Import to Windows SharePoint Services window.


       
    8. Click and drag to highlight the areas of your spreadsheet you want to be included in your list. Be sure to include the column headings; they will become the field names and column titles in the list.
    9. Click the button on the Import to Windows SharePoint Services window. The Import to Windows SharePoint Services list dialog box opens.
    10. Click the Import button.  Your list is created.

    Comments

    Please wait...
    Sorry, the comment you entered is too long. Please shorten it.
    You didn't enter anything. Please try again.
    Sorry, we can't add your comment right now. Please try again later.
    To add a comment, you need permission from your parent. Ask for permission
    Your parent has turned off comments.
    Sorry, we can't delete your comment right now. Please try again later.
    You've exceeded the maximum number of comments that can be left in one day. Please try again in 24 hours.
    Your account has had the ability to leave comments disabled because our systems indicate that you may be spamming other users. If you believe that your account has been disabled in error please contact Windows Live support.
    Complete the security check below to finish leaving your comment.
    The characters you type in the security check must match the characters in the picture or audio.
    Eric Eric has turned off comments on this page.

    Trackbacks

    The trackback URL for this entry is:
    http://kutech.spaces.live.com/blog/cns!D4F84EBE16081C74!211.trak
    Weblogs that reference this entry
    • None