Add new items with bulk edit metadata Excel export/import
Allow to add list items by adding them to the exported Excel document from the Bulk Edit Metadata tool and importing it.
Because I had over 1k new items to add, would make sense to follow the suggested steps.
Instead, I created a new list/App "Import" > imported the items from excel to populate the new list > then I used Sharegate to copy the new items from the new list to my destination list > after completed, I deleted the Import list.
Doug Loose commented
I have many many request to to this. I wish I could add new items to a list via sharegate. as of now I have to create an item "ZZZZ" by block copy and paste, and then bulk edit. its a huge pain
For anyone finding this post - "Adding items" could be done using the Quick Edit in SharePoint. Recopy any one of the existing rows and keep on duplicate it until you have added enough "dummy" records. Export the list using Sharegate and then edit in Excel i.e. update the dummy records to the real data that needs to be added - and re-import back to SharePoint.