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.
