Create a list based on a spreadsheet

You can save time when you create a list by importing a spreadsheet file, if your data is already in a spreadsheet format. When you create a list from a spreadsheet, its headings become columns in the list, and the rest of the data is imported as list items.

After you import data into a list, you can customize its settings and continue to add data to it, as you would any list on a Microsoft Windows SharePoint Services site.

To create a list based on a spreadsheet, you must be using a spreadsheet program that is compatible with Microsoft Windows SharePoint Services, Microsoft Internet Explorer, and Microsoft Windows. For example, you can import a list from Microsoft Office Excel 2007 that you created to store and manage contracts with vendors.

  1. Click View All Site Content, and then click Create on the All Site Content page.

    Tip: In most cases, you can use the Site Actions menu Button image instead to complete this step.

  1. Under Custom Lists, click Import Spreadsheet.

    1. In the Name box, type a name for the list. The list name is required.

      The name appears at the top of the list page, becomes part of the Web address for the list page, and appears in navigational elements that help users to find and open the list.

  2. In the Description box, type a description of the purpose of the list. The description is optional.

  3. In the Import from Spreadsheet section, click in the File location box. Click Browse to find the spreadsheet file that contains the list that you want to import, and then click Open.

  4. Click Import.

  5. In the Import to Windows SharePoint Services list dialog box, enter the range of cells that you want to use for your list. Depending on your spreadsheet program, you may be able to select the range of cells that you want directly in the spreadsheet.

  6. In the Import to Windows SharePoint Services list dialog box, click Import.

Note: Typically, the columns are set up on the SharePoint site based on the type of data that they contain. After you import a list, however, you should inspect the columns and data to make sure that everything was imported as you expected. For example, you may want to specify that a column contains currency rather than just a number. To view or change the list settings, open the list, and then click List Settings on the Settings menu.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!