How to Copy Paste Tab Delimited Text Into Excel

Taking text files and getting them formatted into Excel can be a difficult process. Often, it can be useful to copy-paste from text files into Excel. However, Excel can make this confusing and difficult.



1. Copy-paste a tab delimited text into Excel (likely, this will only show up in the first column).
  
 2. Ensure the column you just pasted is highlighted.
  
3. Open the menu Data-> Text to Columns.

 
4. Select 'Delimited' and click 'Next'. 

 
5. Select 'Tab'. 

 

6. Click 'Finish'.

 

7. Now, you can paste additional tab-delimited text into Excel without needing to apply the Text to Columns function. Instead, they paste into the appropriate   

 
8. Finished.