Sharepoint 2010 create list from excel file

Browse to or enter the File location of the spreadsheet. When done, select Import. If you want to select a range manually, select Range of Cells , and then select Select Range. In the spreadsheet, select the upper left cell, hold down the Shift key, and select the lower right cell of the range you want. The range appears in the Select Range field. Select Import. 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, select the List tab or select Settings , and then select List Settings. Important: Be sure to use a 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. Note: A SharePoint site can be significantly modified.

If you cannot locate an option, such as a command, button, or link, contact your administrator. 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.

Enter the Description for the list. Description is optional. You can change the description for a list. Browse or enter the File Location of the spreadsheet that you want to import, and then select Import.

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. 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. To view or change list settings, open the list, select the List tab, or select Settings , and then select List Settings. 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 the list from Excel announcement above, we want to emphasize that you will be able to create a list from Microsoft Excel today and in the future when Microsoft Lists begins to roll out and broaden the lists story. Learn more about how to create a list from Microsoft Excel and see it in action, via demo video:. You must be a registered user to add a comment.

If you've already registered, sign in. Otherwise, register and sign in. Products 72 Special Topics 41 Video Hub Most Active Hubs Microsoft Teams. Security, Compliance and Identity. Microsoft Edge Insider. Azure Databases. Autonomous Systems. Education Sector.

Microsoft Localization. Microsoft PnP. Healthcare and Life Sciences. Internet of Things IoT. Enabling Remote Work. Small and Medium Business. Humans of IT. Green Tech. Where is the excel spreadsheet? Uploaded into a document library? Where is this code running? From VS on the server directly?

This code is running from Visual Studio on the server directly. The spreadsheet is on the hard drive but could easily be uploaded to a document library. This is not part of a workflow — Meyer Denney. Add a comment. Active Oldest Votes. Improve this answer. Community Bot 1.

Update ;. Zork Zork 1, 2 2 gold badges 14 14 silver badges 23 23 bronze badges. Kit Menke Kit Menke 4, 6 6 gold badges 29 29 silver badges 40 40 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.