I have a sample excel file and I intent to insert many rows (10,00,000).

What is the easiest way to do so apart from dragging a sample row till 10,00.000th row