How to Create an Inventory List in SharePoint 2010. One quick and easy method for creating an inventory list in SharePoint is through the user interface (UI) using the Custom List option.

To create a Microsoft Lists list from the Excel data shown in Figure A, do the following: Make sure the Excel file isn’t open — you can’t load data from an open file.