This plugin captures tabular data pasted into input fields that are part of tables, and sends the data to the appropriate sibling inputs, mimicking the very basic functionality of pasting a block of cells in Excel.
Just apply gridpaste to any inputs that you want to handle the new paste functionality. It will find the closest outer table automatically, and all the surrounding th's and td's with either inputs or textareas in them. No other tags are supported, nor are thead nor tfoot portions of tables.
This assumes that all tabular data is left-rectified, and that there are no empty cells on lines of their own. Think about parsing rows separated by newlines, and each of them separated by tabs.
You can grab a square block of things that's missing the last item on a line or two, no problem. But if the first line "starts" on the third column, and then you paste, by the time it gets to the target to paste, there's no information left to say that it starts "on the third column for just that line". Try a few non-square chunks in the example.
See JQuery CatchPaste.