quickly populate grid

Is there a best known method for quickly populating a user editable grid? With manual testing I would probably copy and paste from Excel, and could write something to do that, but wanted to know if there's something else that would be more reliable and robust.

Thanks!