3

I have an Excel document with 750000 rows and the requirement is to create a custom list in SPO with this data. I am on SharePoint Online.

1

You can export the Excel data to SharePoint Online using combination of Microsoft Access along with Excel. In this approach, you need to create a list with all the necessary schema and use MS Access to map the data from Excel to SharePoint List.

You can refer to the Approach 3 in below article:

https://www.netwoven.com/2016/08/29/ways-to-export-data-from-excel-to-a-sharepoint-list/

2

You can try the script given in below articles

SharePoint Online: Creating a list and import data from CSV using PowerShell

list data in a SharePoint Online List from a CSV File

1

You can use the option 'Export to SharePoint' from Excel.

For more details you can visit this article

  • 3
    Yes, but the data is too much to be imported using 'Export to SP' from Excel. It always crashes when I try to import. – anand Dec 27 '17 at 9:20
0

Although you CAN do this. You MAY want to look at other options for the data. If you choose to load it into SharePoint as a list you will have to manage views of the data so that you can avoid the inevitable list view threshold.

Ask "Why does it NEED to be in SharePoint?" if the answer is "So we can view it" or "So we can report on it" then you may want to look at loading it into Azure SQL and visualize the data in a web part.

Ultimately, you will be dissatisfied with that many items in SharePoint and how cumbersome it will become to manage.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.