Is there a way to insert a blank row to enter data in Editor like how it works in Excel?
Even better with Autofill functionality to easily duplicate data.
Just wanted to see what's the best way to mass insert row data with similar column data.
Currently no - sorry. Inline editing old works to edit data since it can only do one field at a time. It can't be used to add new rows. That is something I plan to introduce in future.
To mass insert rows I would suggest using a custom button, which calls the create() method, which can be used to create multiple rows.
It looks like you're new here. If you want to get involved, click one of these buttons!