SQL Server - Grid Export, choose delimiter I'm trying to find the fastest way to actually get SQL Server query results to Excel, with the least possible trouble.

Frankly the query > text is a bit annoying, there's a "9393 results found" at the bottom. There's also a character limit of 8,000.

The query > grid looks nice, but it either exports (copy>paste) with no delimiter whatsoever, or defaults to commas with (save as) - which doesn't work for data containing natural commas.

Is there any way to do grid export > with semicolons or custom deliminator?

Not sure why SQL Server likes to make this as annoying as possible, there are many MySQL clients that make this simple.
The "9393 results found" message can be removed by putting SET NOCOUNT ON before your query.

I'm using SSMS 2016 and I see the option to use a custom delimiter for Results to Text by going to Tools > Options, then looking under Query Results > SQL Server > Results to Text

The "Output format" dropdown has a custom delimiter option.

If you are committed to using Results to Grid, then you might have to edit your SELECT columns, perhaps using QUOTENAME() or another method.