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?

Solution 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...

Solution 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.)

Comments

[Scott - Слава Україні]

But this seems to provide the exact same functionality as "Text to Columns".   (It might be one less mouse click.)

[Eddy]

I find this option doesn't always show up, depending on the formatting of the source (e.g. copy/paste from webpages). This can be worked-around by pasting into notepad or similar, and then copying again from there. Ugly, but it works.