TL;DR - Old SharePoint List with circa 9k List Items, each with about 50 columns, Exported to Excel, needs to go into a new/live list which is essentially within the same context (it carries out much the same functions as the old one did) - The new list has already been created, has associated workflows and is in production (so I cant import to SharePoint as a new list from excel)
I have inputted en-masse to a list before using the "edit this list" table view, copy-paste from excel etc. but this will not work in this case (i have already tried it) - the volume of data is too extensive and crashes IE or bombs out the session.
The other problem also is that while the majority of columns match the new list, some do not, so there has to be a bit of data manipulation to get them to match up.
Not sure what the best way to approach this is, any suggestions? - I would be very grateful.
SharePoint 2016 On-Prem, SQL Server 2016
Old List is coming from SharePoint 2013.
I am the on-site SharePoint Admin so have full server/database access