18

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?

1
  • what functionality do you exactly need? Data - "Text to column" should work pretty similarly. Aug 24, 2016 at 7:51

2 Answers 2

19

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

10

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

Screenshot from Excel 2017

2
  • 1
    But this seems to provide the exact same functionality as "Text to Columns".   (It might be one less mouse click.)
    – Scott
    Mar 25, 2019 at 17:08
  • 2
    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.
    – Eddy
    Oct 7, 2020 at 15:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.