SSMS Results Grid > copy as Excel format
The "Copy Data As" results grid options have been very useful for years, but one extra thing would still be super nice to have: "Copy As Excel".
I'm sure everyone has seen issues with data types when copying directly from SSMS into Excel, often changing formats of DATETIME columns, scientific notation and/or math operations done on large numbers, and the most annoying for our company: removing leading Zeroes on UPC data.
Is it a possibility that a new feature can be added for "Copy as Excel", which would copy the results grid into an Excel-native pasteable format that maintains the datatypes?
CSV has no types in it so it doesn't really do anything different than just regular copy/paste, HTML makes a slightly nicer looking table but still has some text/number mixup issues, and JSON/XML don't paste well into Excel at all.
There are a few other SQL tools packages that have this feature so I know it's possible (
SSMS Boost is a big one) and it's honestly the last thing that's keeping SQL Complete from being "perfect" for us!