1.On the List Tools tab on the ribbon, click the List tab, and then click Modify View.
2.On the List Tools tab on the ribbon, click the List tab, and then click Export to Excel.
3.Drag from the upper-left corner down to the lower-right corner. Right-click your selection, and then click Datasheet View.
4.On List Tools tab on the ribbon, click the List tab, and then click the Datasheet View button.