Excel pasting dataset in single column, copied from SSMS Results grid
Today while copying data from SQL Server Management Studio (SSMS) into Excel, I observed that all the data is getting copied only to the first column of Excel Sheet. The Data from SSMS in multiple columns was not getting copied to different columns in Excel.
I realized that the previous day I had splitted some comma separated data in Excel to separate columns. So I think Excel saved the same comma-separated setting and thus not allowing to split data in TAB separated format form SSMS.
So I had to do the split of the dataset again, by going to Data ribbon –> Text to Columns option:
Select the Delimiter as TAB and click Next/Finish:
The Dataset in Excel will be separated in different columns just like in the SSMS Results grid: