This may be more a Excel question rather than an Cookdown Easytune question, but it is related..

I am attempting to import the tuning pack CSV file for Microsoft SQL Server management pack. One of the column (description) has line breaks with ” as the text qualifier.

I have not been able to import the CSV file successfully into Excel 365 – the line breaks causes new rows which does not contain the right number of columns.

So, how do you import the such a CSV file into Excel?

Or (which is more Easytune related) is it possible to remove the line breaks in the CSV file, and still be able to successfully import the tuning pack into Easytune?

Kenneth Lund-Petersen answered