Drag a Text File Into Excel

Last month, I showed you how to drag information from a web browser into Excel. You can also drag text files, to open them quickly in Excel. I find this a really quick way to open a text file, especially if Windows Explorer is already open.

Instead of using the Open command, or the Text Import Wizard, just drag the text file into the Excel window.

TextFileDragExcel01

The text file opens automatically, in separate columns in this example, because the data was tab separated.

TextFileDragExcel02

___________

You may also like...

5 Responses

  1. TheQ47 says:

    That’s brilliant. Simple but brilliant! Who knew? Once again, it’s the little things you show on your blog which constantly amaze me. Thanks again, and keep up the good work.

  2. @TheQ47 — thanks! Glad you like the tips.

  3. Jason Morin says:

    Neat. Never tried that before.

  4. sam says:

    You can also do this with an Access table/Query

  5. Guillermo says:

    Gracias, que Aparejo This page Por Primera Vez y me gustado la forma Sencilla y practica Aprender Más párrafo, lo Cual Me Ayuda en mi Trabajo.

    Bueno; arrastrar El APLIQUE, embargo de pecado, ALGUNOS CARACTERES distorcionan se, Pero si lo copio y pego de Los CARACTERES salen correctamente., Estoy usando Windows XP y Excel 2007

Leave a Reply to sam Cancel reply

Your email address will not be published. Required fields are marked *