The information and procedure for copying an entire collection of records from a spreadsheet and pasting them into a grid are virtually the same as Pasting Selected Records (Rows) from a Spreadsheet.
The only real possible difference is that you select the entire collection instead of just a subset of rows.
Copying Data To/From a Spreadsheet
Copying Entire Collections to a Spreadsheet
Copying Selected Cells to a Spreadsheet
Copying Selected Columns to a Spreadsheet
Copying Selected Records to a Spreadsheet