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.
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.