Hi Guys,
Does anyone know any way of importing data from Excel spreadsheet to an existing Sharepoint List?
Cheers.
Is this a one-time effort or an ongoing one? As one-time effort, see previous responses. If it’s an ongoing activity like updating the SharePoint list occasionally with new and updated data from an Excel file, I recommend setting up the fields in MS Access similar to your SP List and exporting the list to MS Access. You can use functionality like Update in Access to refresh your SP list (assuming you use the SP Data Connection functionality). Ensure that you have extra column in SP list and MS Access db like “Update” (Y/N) to work with your Access filter condition. In short, if you set up this way, only the new or modified data in MS Access will be updated in your SP List, thus speeding things up.
Depending on how much data you need to import you can: open the list, switch to data sheet view and as long as the columns match up (both the view and the spreadsheet) and simply copy and paste into the view.
Mentioned it in the chat, but I will reply to this post as well since some users do not see the chat. 🙂
I recommend using PowerShell for this. You can modify the script on this link to suit your data:
http://kesarlajayasankar.blogspot.com/2014/03/import-excel-to-sharepoint-list-using.html
