Archive for June 21, 2013

Excel pasting dataset in single column, copied from SSMS Results grid

June 21, 2013 Leave a comment

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.

Excel vs SSMS 01

So I had to do the split of the dataset again, by going to Data ribbon –> Text to Columns option:

Excel vs SSMS 02

Select the Delimiter as TAB and click Next/Finish:

Excel vs SSMS 03

The Dataset in Excel will be separated in different columns just like in the SSMS Results grid:

Excel vs SSMS 04