How to Append Items to a SharePoint 2013 List With Data From Excel Sheet

This article shows how to append items to an existing SharePoint 2013 List containing data. You would need the Access 2013 desktop version to bridge this gap.
 
Step 1
 
Start Access 2013. Click on the External Data Tab  then select More -> SharePoint List. Choose the list and specify the credentials.
 
 
Step 2
 
Choose the list.
 
 
Step 3
 
Click on External Data then select Import Excel Spreadsheet. You will see the following window. Choose the FileName. You will see options to import data into Access, or append to a SharePoint List or create a linked Access Table.
 
 
Step 4
 
Once you click OK, you will see the import spreadsheet wizard. You can choose a worksheet that has data and click Next.
 
 
Step 5
 
This is an important error message. Your worksheet should contain column names in the first row and the column names should match the SharePoint Columns.
 
 
Step 6
 
After correcting the worksheet, import again.
 
 
Step 7
 
Click Next then click Finish.
 
 
Step 8
 
If all goes well, you will see a status as in the following:
 
 
Step 9
 
Even when this operation is on, you can refresh the list and see the data being appended. You would see that the ID1 column is blank because that does not match the Excel sheet column heading.
 
 
Step 10
 
I am able to add more than 5000 items with this way. In fact I tried with 10,000 items and that took about 15 minutes.
 
 
Step 11
 
Once the data has been imported, you can save these steps so that you can run them without running the wizard. You can also create an Outlook task for a reminder.
 
 
 
I hope this helps.

Up Next
    Ebook Download
    View all
    Learn
    View all