Copy and paste grid for child records

It would be cool to have an interactive subgrid that you can copy and paste directly in to rather than entering each child record like a form. Some cases the user already has the bulk information and they need a practical way to provide it. It will need to hook up to a view and follow validation of the columns on each row. Ie 100 rows are pasted but validation runs on each column until all columns are satisfied then it moves on to row 2 etc…