Getting large amounts of data quickly into SharePoint lists can be cumbersome unless you use the Quick Edit mode of SharePoint. This tutorial will show you how to place a list into Quick Edit mode and then make changes just like you do using a spreadsheet by navigating the cells.
The tutorial will also show you how to copy and paste from an appropriately formatted spreadsheet in Excel on your desktop directly into a SharePoint list.
Using Quick Edit mode is the best way to work quickly with SharePoint lists and this tutorial will get you started.
CIAOPS 