Found myself in this situation recently aswell wanting to paste 1000+ rows into XData from a CSV-sheet. Solved it at that moment having a AutoHotkey script looping the "Insert row"-click procedure to the exact desired amount
A relatively basic/essential functionality to be added I guess - automatically creating new rows to accommodate the copy buffer if larger, or a simple row bulk insertion option in the right-click menu. Can imagine though there might be by now a ticket created for this already?