SharePoint 2013 - QuickEdit Option in List

This blog will talk about how to do bulk Copy of list items to SharePoint 2013 List using QuickEdit, below are steps with screen shots 

1. First export your content ( in my case i exported from moss 2007 using export to excel option )

  after export hide the columns which we should are not supposed to be imported ex : modified by , modified etc. After import content looks in excel as below

2. Navigate to SharePoint 2013 where content should be imported and create required columns 

Click on list tab from ribbon and click on QuickEdit button 

3. Now copy  the content from excel to list by just copy n paste