Importing a spreadsheet into a collaboration list in SharePoint (Team Collaboration)

If your data is already in a spreadsheet format, you can create a List Type based on a spreadsheet. 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 which you can sort and filter.

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 which you can sort and filter.

 

Create a new list

  • Click the Actions Items pull down menu and select More Options.
  • Under Custom Lists, click Import Spreadsheet.
  • In the Name Box, type a name, then give it a description to help users know the purpose of the list.
  • In the Import From Spreadsheet section, click in the File Location field and select Browse.
  • Find the spreadsheet you want to import and click Open.
  • In the Spreadsheet window, you will need to select the Range of Cells, then Click Import.
  • Once, the data appears in the new list, inspect the columns and data to make sure everything was imported.

 

To View or Change List Settings

  • Select the list.
  • In the Ribbon, click the List TAB.
  • In the Settings Group, click List Settings.
  • On the List Settings page, in the Column section, click the name of the column that you want to change.
     

NOTE: some columns you will not be able to change the settings.

Print Article