Copy huge Excel data to existing sharepoint custom list

Question

Hi I am working on a project where i need to copy around 2 lakh excel data to sharepoint custom list. Till now i have copied 100-200 records so i know we can copy paste. Even i need not worry about View Throttling. So can anyone help how to achieve this scenario. Regards Ramya

Aakash Morya · Answer

Here I have already explained this requirement in my article http://www.c-sharpcorner.com/article/export-excel-data-to-sharepoint-custom-list/ Look at once.

Yogendra Bhardwaj · Answer

Hi Ramya You can use below utility if it helps you. https://difs.codeplex.com/ Please share your experience once will be able to load big amount of data

Manpreet Singh · Answer

Hi Did you tried importing from spreadsheet? Manpreet [MVP SharePoint] Find me here :- https://sharepointworldbymanpreet.wordpress.com/

Amar Gaikwad · Answer

You can fetch the records from excel file using .NET code and add them in SharePoint list using SharePoint Server Side Object Model or SharePoint Client Side Object Model. You can easily find the utilities for reading excel files on internet. If you do not find any utility for reading excel files then you can save your excel file in CSV format read the records and add them in SharePoint list. You can read CSV file using IO and string operations.

Prashant Kumar · Answer

See if it can help you: http://sharepointsolutiontips.blogspot.in/2016/06/bulk-export-sharepoint-files-in-2010.html Kindly let us know you need to copy entire list or excel only. Thanks

Rajkiran Swain · Answer

http://3sharp.com/blog/copy-and-paste-from-excel-to-a-sharepoint-list/

Yogendra Bhardwaj · Answer

Hi Ramya Technically there are so many ways to import data into SharePoint list but based upon data you have I would like you to suggest to do re-assessment of your solution and business requirements because in long run you will have list performance issue with this number of record. You can have this data in SQL and use SharePoint APP can display within SharePoint. Thanks