SharePoint lists III: Create a list based on a spreadsheet

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

How do you take a spreadsheet and make it into a SharePoint list? You import it. Take this short course to learn how.


After completing this course you will be able to:

  • Prepare your spreadsheet before importing.

  • Create the list by importing the spreadsheet.

  • Clean up the list so that it’s easy to use.

  • Create useful views of the new list.

Before you begin

This course requires experience working with SharePoint lists, or you can take Lists I: An introduction and Lists II: Create and work with different lists.

Quick reference card

See the quick reference card for a brief, printable reminder of the key points in this course.

See more courses at the Office Training Center.

Applies To: SharePoint Foundation 2010, SharePoint Server 2010

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language