It’s not hard to export data from a SQL Server table in SSMS to a CSV (comma separated file) or a tab delimited file. You can simply run your SELECT query in SSMS. At the bottom where the data is displayed, you can first select all of the data (by clicking the top left corner), then right clicking, and choosing Save Results As…

You will notice that the Save Grid Results dialog box asking you for the file name and the location. The file types are CSV and tab delimited.