Using Excel you can import data from a text file with a wizard available at -> Data -> From text.
Is there a way of using the same wizard to import data coming from the clipboard without having to create an empty text file, pasting the contents there and then using the wizard?