Create a list based on a spreadsheet (2024)

Table of Contents
Create a list based on a spreadsheet Create a list based on a spreadsheet in SharePoint 2016 and 2013 Create a list based on a spreadsheet in SharePoint2010 Leave us a comment

When creating a Microsoft list, you can save timeby importing an existing Excel spreadsheet. This method converts the table headings to columns in the list, and the rest of the data is imported as list items.Importing a spreadsheet is also a way to create a list without the default Title column.

Important:Creating a list from an Excel spreadsheet is not available in the GCC High and DoD environments.

Another method of moving data into SharePoint is to export a table directly from Excel. For more info, see Export an Excel table to SharePoint. For more info on SharePoint supported browsers, see Plan browser support in SharePoint Server.

ModernClassicOffice 2010

Create a list based on a spreadsheet

  1. From the Lists app in Microsoft 365, select+New listor from your site's home page, select+New>List.

    • InMicrosoft Teams, from theFilestab at the top of your channel, selectMore>Open in SharePoint,and then selectNew>List.

    Create a list based on a spreadsheet (1)

  2. On the Create a list page, select From Excel.

    Create a list based on a spreadsheet (2)

  3. Choose Upload file to select a file on your device, or Choose a file already on this site.

    Create a list based on a spreadsheet (3)

    If you upload from your device, the Excel file will be added to the Site Assets library of your site, which meansother people will have access to the original Excel data.

    Note:If the Upload file button is greyed out, you don't have permission to create a list from a spreadsheet. For more information, see your organization's site admin.

  4. Enter the name for your list.

    Create a list based on a spreadsheet (4)

  5. (Optional) Check Show in site navigation to display the list on your site's Contents page.

  6. Click Create.

    Notes:

    • If the spreadsheet file you're importing doesn't have a table in it, follow the on-screen instructions to create a table in Excel, and then import the table to your list. If you get stuck creating a table, search for "Format as Table" at the top of your file in Excel.

    • You can use tables with up to 20,000 rows to create a list.

Create a list based on a spreadsheet in SharePoint 2016 and 2013

Note:When you're using asite template, it is no longer possible within SharePoint to create a list from an Excel workbook. However, you can still achieve the same thing by exporting data to SharePoint from Excel, as described in Export an Excel table to SharePoint.

  1. On the site where you want to add a spreadsheet based list, selectSettings Create a list based on a spreadsheet (5), and then selectAdd an app.

  2. In the Find an app field, enterspreadsheet, and then selectthe search icon Create a list based on a spreadsheet (6).

    Create a list based on a spreadsheet (7)

  3. In the search results page, selectImport Spreadsheet.

    Create a list based on a spreadsheet (8)

  4. In the New app page, entera Name for the list.

    The name appears at the top of the list in most views, becomes part of the web address for the list page, and appears in site navigation to help users find the list. You can change the name of a list, but the web address will remain the same.

    Create a list based on a spreadsheet (9)

  5. Enter an optional Description.

    The description appears underneath the name in most views. You can change the description for a list at any time using list settings.

  6. Browse to or enterthe File location of the spreadsheet. When done, selectImport.

    The spreadsheet opens in Excel, and the Import to Windows SharePoint Services List window appears.

  7. In the Import to Windows SharePoint Services List window, selectTable Range, Range of Cells, or Named Range. If you want to select a range manually, selectRange of Cells, and then selectSelect Range. In the spreadsheet, selectthe upper left cell, hold down the Shift key, and select the lower right cell of the range you want.

    Create a list based on a spreadsheet (10)

    The range appears in the Select Range field. SelectImport.

    Create a list based on a spreadsheet (11)

    After you import a spreadsheet, check the columns of the list to make sure that the data was imported as you expected. For example, you may want to specify that a column contains currency instead of a number. To view or change list settings, open the list, selectthe List tab or selectSettings Create a list based on a spreadsheet (12), and then selectList Settings.

  8. The spreadsheet data appears in a list in SharePoint.

    Create a list based on a spreadsheet (13)

Important:Be sure to use a 32-bit web browser, such as Microsoft Edge, to import a spreadsheet, as importing a spreadsheet relies on ActiveX filtering. Once you import the spreadsheet, then you can work with the list in any SharePoint-supported browser.

Create a list based on a spreadsheet in SharePoint2010

  1. SelectSite Actions Create a list based on a spreadsheet (14), selectView All Site Content, and then selectCreate Create a list based on a spreadsheet (15).

    Note:A SharePoint site can be significantly modified. If you cannot locate an option, such as a command, button, or link, contact your administrator.

  2. In SharePoint 2010, under All Categories, selectBlanks & Custom, selectImport Spreadsheet, and then selectCreate.

    In SharePoint 2007, under Custom Lists, selectImport Spreadsheet, and then selectCreate.

    Create a list based on a spreadsheet (16)

  3. Enter the Name for the list. Name is required.

    The name appears at the top of the list in most views, becomes part of the web address for the list page and appears in site navigation to help users find the list. You can change the name of a list at any time, but the web address will remain the same.

  4. Enter the Description for the list. Description is optional.

    The description appears underneath the name in most views. You can change the description for a list.

    Create a list based on a spreadsheet (17)

  5. Browse or enterthe File Location of the spreadsheet that you want to import, and then selectImport.

  6. In the Import to Windows SharePoint Services list dialog, select the Range Type, and in Select Range, specify the range in the spreadsheet that you want to use to create your list.

    Create a list based on a spreadsheet (18)

    Note:Depending on your spreadsheet program, you may be able to select the range of cells that you want directly in the spreadsheet. A table range and a named range must already be defined in the spreadsheet for you to select it in the Import to Windows SharePoint Services list dialog.

  7. SelectImport.

Create a list based on a spreadsheet (19)

After you import a spreadsheet, check the columns of the list to make sure that the data was imported as you expected. For example, you may want to specify that a column contains currency instead of a number. To view or change list settings, open the list, selectthe List tab, or selectSettings, and then selectList Settings.

Important:Be sure to use a 32-bit web browser, such as Microsoft Edge, to import a spreadsheet, as importing a spreadsheet relies on ActiveX filtering. Once you import the spreadsheet, then you can work with the list in any SharePoint-supported browser.

The types of columns that are created for a list are based on the kinds of data that are in the columns of the spreadsheet. For example, a column in the spreadsheet that contains dates will typically be a date column in the SharePoint list.

All versions of SharePoint let you import a spreadsheet of data, though how you do it varies slightly between the versions. Examples here use Excel, but another compatible spreadsheet would work. If your spreadsheet program's native file format isn't supported, export your data to a comma delimited format (.CSV) and import using that file.

For more info about how to customize and add your imported list to a page or site, seeIntroduction to lists.

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 on the Settings menu, selectList Settings.

Top of Page

Leave us a comment

Was this article helpful? If so, please let us know at the bottom of this page. If it wasn't helpful, let us know what was confusing or missing. Please include your version of SharePoint, OS, and browser. We'll use your feedback to double-check the facts, add info, and update this article.

Create a list based on a spreadsheet (2024)
Top Articles
RECIPE: Mint Juleps by the Batch
15 Easy & Delicious Boneless Chicken Breast Recipes - Porculine
Prudent Mutual Fund Login
Columbus College of Art & Design Reviews
Latest Posts
Campfire Recipe: Cheesy Ham and Pineapple Sandwich
18 Easy Crock-Pot Recipes (10 Minutes or Less in Prep Time)
Article information

Author: Rubie Ullrich

Last Updated:

Views: 5937

Rating: 4.1 / 5 (52 voted)

Reviews: 83% of readers found this page helpful

Author information

Name: Rubie Ullrich

Birthday: 1998-02-02

Address: 743 Stoltenberg Center, Genovevaville, NJ 59925-3119

Phone: +2202978377583

Job: Administration Engineer

Hobby: Surfing, Sailing, Listening to music, Web surfing, Kitesurfing, Geocaching, Backpacking

Introduction: My name is Rubie Ullrich, I am a enthusiastic, perfect, tender, vivacious, talented, famous, delightful person who loves writing and wants to share my knowledge and understanding with you.