How to copy all data from ExcelSheet and Paste in SharePoint List.

How to copy all data from ExcelSheet and Paste in SharePoint List.

Create Custom List CustomerDetails3 in SharePoint with four fields (CustomerID,CustomerName,Location,MobNumber)

1. Copy your data from excel sheet (only data no headers)

2. Open CustomerDetails3 List in IE (Chrome don’t support)

3. Click edit

4. Bring cursor at CustomerID with keyUP/KeyDown (don’t use mouse)

5.Press Ctrl+V

6.Stop editing.

Verify data

Done  cheers 

by Amir Reza via Everyone's Blog Posts - SharePoint Community