Once you build a SharePoint site, have a list created. If you are creating a list from Excel import then you need to be careful about the limitations, because you won’t be able to load more than 5000 records from the excel file during the creation of the list.

After the list is created, you can load as much data as needed, depending on the size. for instance if you have projects’ list information you can grow your list up to 1 million+ records without any issues.

see the photo below from production list:

For loading list information from a database source, or excel files or any other data source and for continuous automatic updating your list, you can run several methods.

1- using PowerApps

2- using power-automate

3- Powershell scripts

if you have any difficulties working with SharePoint or you need any training or have any request do not hesitate to contact me. I provide the basic analysis and recommendations for free to answer your problems and achieve your needs. on top of that I can also provide you with custom training, advisory, implementation, outsourcing services and support services for Microsoft solutions, MS 365, SharePoint Online, Azure and many other. don’t hesitate to contact me for any need.