Hi Guys,Â
Does anyone know any way of importing data from Excel spreadsheet to an existing Sharepoint List?
Cheers.
It’s always tricky to import from Excel to an EXISTING SharePoint list. The way you did to start from scratch (import to a NEW list) is the way to go. In both cases, you need to prepare both Excel and SharePoint lists so they match in terms of fields and format. But that’s easily said than done. I have come across these type of requests. One case was for a very ACTIVE SP list and has to be available to users 24/7, we added a “process” and created new columns to support it. To import “new data”, we created a View which is a Datasheet View to help with quality checking. Since new items are assigned unique IDs, no issue with overwriting current items. The challenge was for “modified items” — so for a growing list of “>10K” items, we got tired of copy/paste and used MS Access instead using data connection.
