Import lists to SharePoint (not libraries)
> Thank you for taking the time to provide feedback via Sharegate’s Uservoice. Unfortunately, the suggestion provided is not in the current roadmap and has therefore been declined. Although the current status of this suggestion is under “decline”, it has not been deleted from our feedback service. Other users will continue to have the chance to vote for this suggestion.
This is a common requirement. Even i am going to write custom PowerShell for this. Please consider
Alternately, you can start a copy from any list to another. Select an item and export selection to Excel. You can then work in your Excel to create multiple copies of your item and the list is populated!
I used powershell to import items from a CSV to various SharePoint Lists. I would love to see this built-in to Sharegate.
Dany Lavertu commented
From an excel spreadsheet to a SharePoint List