Home > Excel, Lists, Sharepoint2010 > Import Excel sheet as SharePoint List

Import Excel sheet as SharePoint List

Today I stumbled upon new feature of SharePoint 2010, Uploading excel spread sheet as SharePoint list.

I found it quite interesting and useful.

Here is how its done.

We will create a excel sheet having two columns[coutryname and countrycode] and  upload it in SharePoint as SharePoint list , along with data.

Open excel[i,m using office 2010]

Click on Insert Tab

Click on very first cell of excel and then click on table , a popup  window[create table] will come up, tick the checkbox next to my table has headers.

Below screen will come up

Rename column1 to countryname add one more column , name it as countrycode

And enter some dummy data.

Save your excel sheet .Name it as country.

Now click on site actions tab, then click on more options.

A popup window for create will come up select on import spreadsheet then click on create.

Below screen will come up, click on browse to select saved excel sheet.

 

 

Enter the name of list[this name will appear as list name in sharepoint]

When you click on import. below screen will come up,

Keep the range Type as Table Range and Click on select range and select Sheet1!Table1 from drop down list.

Click on import , a window asking your credentials will pop up, provide user name and password

Data gets imported and you can see SharePoint list created in your site.

We are done..so simple ..yet so gr8

Advertisements
Categories: Excel, Lists, Sharepoint2010 Tags:
  1. Kevin Singley
    March 10, 2011 at 7:24 pm

    Great article! Is it possible to update an existing list with an import? It seems that whenever you import, you have to specify a new list name. I want to create a list from a spreadsheet, but then also add to it again from new spreadsheets.

  2. Daniel
    August 3, 2011 at 7:33 pm

    Fantastic post, very helpful thanks! Every other site required using complex code, lol!

  3. August 18, 2011 at 4:02 pm

    Thanks, this is interesting.

  4. Caleb Hess
    November 30, 2011 at 2:19 pm

    For some reason I am not able to use Table Range. The dropdown list is empty and I cannot type in the Select Range box. I had to use Range of Cells instead.

  5. sharepoint fundi
    April 20, 2012 at 11:41 pm

    This feature has been around since Sharepoint 2003 so is not new to 2010.

  6. November 9, 2012 at 12:31 pm

    That is really fascinating, You are an overly professional blogger. I have joined your feed and stay up for searching for extra of your magnificent post. Also, I’ve shared your web site in my social networks

    • December 26, 2012 at 9:06 am

      thanks.i will make sure to keep up the quality

  7. February 1, 2013 at 12:23 am

    Once you’ve imported a spreadsheet from Excel, how do you then find it on your sharepoint site? I don’t remember the path, and don’t see it under community content.

  8. June 21, 2013 at 3:21 pm

    Spectacular web site. Many handy information and facts listed here. I’m just delivering them to a couple good friends ans in addition revealing around delectable. And definitely, appreciate your effort!

  9. Roopa
    July 17, 2013 at 6:20 am

    i have 300items in that only 10-20 items are importing???

  10. John
    August 22, 2013 at 3:49 pm

    Why does SharePoint change the name by putting a number 1 after it is imported?

  11. ziadb86
    August 23, 2013 at 11:53 am

    Excellent article.. very helpful…

  12. Rob
    September 13, 2013 at 9:53 am

    Thanks very much for this, it’s the best and only article i’ve found to explain the process that allows headers to be imported as well.

  1. March 18, 2013 at 12:20 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: