How to import data in Excel from the clipboard as if it was in a text file?

Question

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?

Answer 1

Text to columns (in data tab) have almost the same functionality than your "import from text file has".

You can split the text to columns by fixed length or at separators, select data type for each column...

Answer 2

Alternatively, if you have the text data on your clipboard, you can Use Text Import Wizard...  (I've confirmed that this works for Excel 2010+; not sure about older versions.)