If you want to copy contents from a plain text file, for instance one you have created with Notepad or Notepad++, you may have noticed that contents do not get pasted correctly into the spreadsheet even if you have taken great care of making sure the data is aligned properly in the text document. Ashish Mohta published a little tutorial on his website that explains how you can format text files so that data in them is pasted correctly into Microsoft Excel. The process works with every plain text document regardless of the program it has been created in.
When you normally copy and paste contents into Microsoft Excel they will all be stored in the same cell in the Excel application. That is usually not the desired way of how you want the date to be displayed in Excel. A far better option would be to paste the contents into different cells, especially if the text document used a tablet like structure for the contents as well.
The process is actually very simple. You need to use the TAB key to divide data in the text document. When you paste the contents into Excel, you will notice that Excel will automatically add them to different cells automatically.
Each tap of the TAB button represents a new cell in the Excel spreadsheet and that is all you need to know to paste contents properly into the spreadsheet application. Note that you can press tab at any time to sort data into Excel cells. This is even possible at the beginning of the a line in the text file.
It is also interesting to note that this works in other spreadsheet applications as well. I have tested it in Open Office and it worked exactly as in Microsoft Excel.Advertisement
Advertising revenue is falling fast across the Internet, and independently-run sites like Ghacks are hit hardest by it. The advertising model in its current form is coming to an end, and we have to find other ways to continue operating this site.
We are committed to keeping our content free and independent, which means no paywalls, no sponsored posts, no annoying ad formats or subscription fees.
If you like our content, and would like to help, please consider making a contribution:
Ghacks is a technology news blog that was founded in 2005 by Martin Brinkmann. It has since then become one of the most popular tech news sites on the Internet with five authors and regular contributions from freelance writers.